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 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.
D.
It enables users to store the results of a query permanently.