Which two statements best describe the benefits of using the WITH clause? (Choose two.)
A.
It enables users to store the query block permanently in the memory and use it to create
complex queries.
B.
It enables users to reuse the same query block in a SELECT statement, if it occurs more
than once in a complex query.
C.
It enables users to store the results of a query permanently.
D.
It can improve the performance of a large query by storing the result of a query block
having the WITH clause in the user’s temporary tablespace.