QUESTION: 61

Which statement is true regarding the INTERSECT operator?

The names of columns in all SELECT statements must be identical.
It ignores NULL values.
Reversing the order of the intersected tables alters the result.
The number of columns and data types must be identical for all SELECT statements in the query.

Answer(s): D

Explanation:

INTERSECT Returns only the rows that occur in both queries' result sets, sorting them and removing duplicates.
The columns in the queries that make up a compound query can have different names, but the output result set will use the names of the columns in the first query.

Show Answer Next Question

QUESTION: 62

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?

It displays 5 percent of the products with the highest amount sold.
It displays the first 5 percent of the rows from the SALES table.
It displays 5 percent of the products with the lowest amount sold.
It results in an error because the ORDER BY clause should be the last clause.

Answer(s): C

Reference:

https://oracle-base.com/articles/12c/row-limiting-clause-for-top-n-queries-12cr1

Show Answer Next Question

QUESTION: 63

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?

It recovers only the table structure.
It recovers the table structure, data, and the indexes.
It recovers the table structure and data but not the related indexes.
It is not possible to recover the table structure, data, or the related indexes.

Answer(s): D

Reference:

https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9003.htm

Show Answer Next Question

QUESTION: 64

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

1. The WHERE clause of the outer query is evaluated.
2. A candidate row is fetched from the table specified in the outer query.
3. This is repeated for the subsequent rows of the table, until all the rows are processed.
4. 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?

2,1,4,3
4,1,2,3
4,2,1,3
2,4,1,3

Answer(s): D

Reference:

http://rajanimohanty.blogspot.co.uk/2014/01/correlated-subquery.html

Show Answer Next Question

Free Oracle 1Z0-071 Exam Braindumps (page: 17)

QUESTION: 61

Explanation:

QUESTION: 62

Reference:

QUESTION: 63

Reference:

QUESTION: 64

Reference:

1Z0-071 Exam Discussions & Posts