Oracle Oracle Certifications 1Z0-071 Questions & Answers

• Question 141:

  Which two are true about savepoints? (Choose two.)

  A. After issuing a savepoint, you can roll back to the savepoint name within the current transaction.

  B. They make uncommitted updates visible to sessions owned by other users.

  C. You can commit updates done between two savepoints without committing other updates in the current transaction.

  D. A ROLLBACK TO SAVEPOINT command issued before the start of a transaction results in an error.

  E. They make uncommitted updates visible to other sessions owned by the same user.

  F. After issuing a savepoint, you cannot roll back the complete transaction.

  Correct Answer: AD

• Question 142:

  The ORDERS table has a column ORDER_DATE of data type DATE.

  The default display format for a date is DD-MON-RR.

  Which two WHERE conditions demonstrate the correct usage of conversion functions? (Choose two.)

  A. WHERE order_date > TO_DATE(`JUL 10 2018', ` MON DD YYYY')

  B. WHERE order_date > TO_DATE(ADD_MONTH(SYSDATE, 6), `MON DD YYYY')

  C. WHERE order_date IN (TO_DATE(`Oct 21 2018', `Mon DD YYYY'), TO_CHAR(`Nov 21 2018', `Mon DD YYYY'))

  D. WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), `MON DD YYYY')

  E. WHERE TO_CHAR(order_date. `MON DD YYYY') = `JAN 20 2019'

  Correct Answer: AE

• Question 143:

  Examine this query:

  What is the result?

  A. an error

  B. no rows

  C. 1 row

  D. 3 rows

  E. 6 rows

  F. 8 rows

  Correct Answer: B

• Question 144:

  Which two object privileges can be restricted to a subset of columns in a table? (Choose two.)

  A. INDEX

  B. ALTER

  C. UPDATE

  D. INSERT

  E. DELETE

  Correct Answer: CD

• Question 145:

  Which three statements are true about an ORDER BY clause? (Choose three.)

  A. By default an ORDER BY clause sorts rows in descending order

  B. An ORDER BY clause will always precede a HAVING clause if both are used in the same top-level query.

  C. An ORDER BY clause always sorts NULL values last.

  D. By default an ORDER BY clause sorts rows in ascending order.

  E. An ORDER BY clause can perform a binary sort.

  F. An ORDER BY clause can perform a linguistic sort.

  Correct Answer: DEF

• Question 146:

  Which two queries return the string Hello! We're ready? (Choose two.)

  A. SELECT "Hello! We're ready" FROM DUAL;

  B. SELECT 'Hello! We're ready' FROM DUAL;

  C. SELECT q'!Hello! We're ready!' FROM DUAL;

  D. SELECT q'[Hello! We're ready]' FROM DUAL;

  E. SELECT 'Hello! We\'re ready' ESCAPE '\' FROM DUAL;

  Correct Answer: CD

• Question 147:

  Which three statements are true about the DESCRIBE command? (Choose three.)

  A. It can be used from SQL Developer.

  B. It displays the PRIMARY KEY constraint for any column or columns that have that constraint.

  C. It displays all constraints that are defined for each column.

  D. It displays the NOT NULL constraint for any columns that have that constraint.

  E. It can be used only from SQL* Plus.

  F. It can be used to display the structure of an existing view.

  Correct Answer: ADF

• Question 148:

  Which two statements are true regarding non-equijoins? (Choose two.)

  A. Table aliases must be used.

  B. The SQL:1999 compliant ANSI join syntax must be used.

  C. The USING clause can be used.

  D. The Oracle join syntax can be used.

  E. The ON clause can be used.

  Correct Answer: DE

• Question 149:

  Which two statements are true about CURRENT_TIMESTAMP? (Choose two.)

  A. The value varies depending on the setting of SESSIONTIMEZONE.

  B. It returns a value of data type TIMESTAMP.

  C. The date is in the time zone of DBTIMEZONE.

  D. It returns the same date as CURRENT_TIME.

  E. The time is in the time zone of DBTIMEZONE.

  F. It always returns the same value as SYSTEMTIMESTAMP.

  Correct Answer: AB

• Question 150:

  Which two are true about the data dictionary? (Choose two.)

  A. The data dictionary is constantly updated to reflect changes to database objects, permissions, and data.

  B. All user actions are recorded in the data dictionary.

  C. All users have permissions to access all information in the data dictionary by default.

  D. The SYS user owns all base tables and user-accessible views in the data dictionary.

  E. Base tables in the data dictionary have the prefix DBA_.

  Correct Answer: AD