Which two statements best describe the benefits of using the WITH clause? (Choose two.)
A.
It enables users to store the results of a query permanently.
B.
It enables users to store the query block permanently in the memory and use it to create
complex queries.
C.
It enables users to reuse the same query block in a SELECT statement, if it occurs more than
once in a complex query.
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.