Oracle 1Z0-071 Quiz 49 Topic 9 Questions 241-245

Question: 1

Which statement is true about an inner join specified in the WHERE clause of a query?

AIt must have primary-key and foreign-key constraints defined on the columns used in the join condition.

BIt requires the column names to be the same in all tables used for the join conditions.

CIt is applicable for equijoin and nonequijoin conditions.

DIt is applicable for only equijoin conditions.

Show Answer

Question: 2

Which statement is true regarding the INTERSECT operator?

AThe names of columns in all SELECT statements must be identical.

BIt ignores NULLs.

CReversing the order of the intersected tables alters the result.

DThe number of columns and data types must be identical for all SELECT statements in the query.

Show Answer

Question: 3

Examine the following query:

SQL> SELECT prod_id, amount_sold

FROM sales

ORDER BY amount_sold

FETCH FIRST 5 PERCENT ROWS ONLY;

What is the output of this query?

AIt displays 5 percent of the products with the highest amount sold.

BIt displays the first 5 percent of the rows from the SALES table.

CIt displays 5 percent of the products with the lowest amount sold.

DIt results in an error because the ORDER BY clause should be the last clause.

Show Answer

Question: 4

The first DROP operation is performed on PRODUCTS table using this command:

DROP TABLE products PURGE;

Then a FLASHBACK operation is performed using this command:

FLASHBACK TABLE products TO BEFORE DROP;

Which is true about the result of the FLASHBACK command?

AIt recovers only the table structure.

BIt recovers the table structure, data, and the indexes.

CIt recovers the table structure and data but not the related indexes.

DIt is not possible to recover the table structure, data, or the related indexes.

Show Answer

Question: 5

These are the steps for a correlated subquery, listed in random order:

The WHERE clause of the outer query is evaluated.

A candidate row is fetched from the table specified in the outer query.

This is repeated for the subsequent rows of the table, until all the rows are processed.

Rows are returned by the inner query, after being evaluated with the value from the candidate row in the outer query.

Which is the correct sequence in which the Oracle server evaluates a correlated subquery?

A2, 1, 4, 3

B4, 1, 2, 3

C4, 2, 1, 3

D2, 4, 1, 3

Show Answer

Oracle 1Z0-071 Quiz:49 Topic:9 Questions:241-245