Oracle Database SQL 12c 1z0-071 Exam Practice Test 2

Question : 16 of 50

Marks: +1, -0

Which three statements are true regarding the usage of the WITH clause in complex correlated subqueries? (Choose three.)

It can be used only with the SELECT clause.
The WITH clause can hold more than one query.
If the query block name and the table name are the same, then the table name takes precedence.
The query name in the WITH clause is visible to other query blocks in the WITH clause as well as to the main query block

Go to Question:

Prev Question

Next Question