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

Question : 13 of 50

Marks: +1, -0

Which two statements best describe the benefits of using the WITH clause? (Choose two.)

It can improve the performance of a large query by storing the result of a query block having the WITH clause in the session's temporary tablespace.
It enables sessions to reuse the same query block in a SELECT statement, if it occurs more than once in a complex query.
It enables sessions to store a query block permanently in memory and use it to create complex queries.
It enables sessions to store the results of a query permanently.

Go to Question:

Prev Question

Next Question