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.