ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

104 / 120

Question 104:

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

Answer options:

A. 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.
B. It enables sessions to reuse the same query block in a SELECT statement, if it occurs more than once in a complex query.
C. It enables sessions to store a query block permanently in memory and use it to create complex queries.
D. It enables sessions to store the results of a query permanently.