Question 1

Which statement is true about the INTERSECT operator used in compound queries?

Options :

A : It processes NULLS in the selected columns.

B : INTERSECT is of lower precedence than UNION or UNION ALL.

C : It ignores NULLS.

D : Multiple INTERSECT operators are not possible in the same SQL statement.

Answer: A

Question 2

Which statement is true regarding the default behavior of the ORDER BY clause?

Options :

A : In a character sort, the values are case-sensitive.

B : NULLs are not included in the sort operation.

C : Only columns that are specified in the SELECT list can be used in the ORDER BY clause.

D : Numeric values are displayed in descending order if they have decimal positions.

Answer: A

Question 3

The BOOKS_TRANSACTIONS table exists in your schema in this database.

You execute this SQL statement when connected to your schema in your database instance.

SQL> SELECT * FROM books_transactions ORDER BY 3;

What is the result?

Options :

A : The execution fails unless the numeral 3 in the ORDER BY clause is replaced by a column name.

B : All table rows are displayed sorted in ascending order of the values in the third column.

C : The first three rows in the table are displayed in the order that they are stored.

D : Only the three rows with the lowest values in the key column are displayed in the order that they are stored.

Answer: B

Question 4

Which two statements are true? (Choose two.)

Options :

A :

The USER SYNONYMS view can provide information about private synonyms.

B : The user SYSTEM owns all the base tables and user-accessible views of the data dictionary.

C :

All the dynamic performance views prefixed with V$ are accessible to all the database users.

D :

The USER OBJECTS view can provide information about the tables and views created by the user only.

E :

DICTIONARY is a view that contains the names of all the data dictionary views that the user can access.

Answer: A,E

Question 5

Which two statements are true regarding subqueries? (Choose two.)

Options :

A : Only two subqueries can be placed at one level.

B : A subquery in the WHERE clause of a SELECT statement can be nested up to three levels only.

C : A subquery can be used to access data from one or more tables or views.

D : The columns in a subquery must always be qualified with the name or alias of the table used.

E : If the subquery returns 0 rows, then the value returned by the subquery expression is NULL

Answer: A,C

Confidently Practice Online with Free 1Z0-071 Exam Cram

Buying Options: