047-122

122. 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.

Answer: CD

Benefits:好处 permanently 永久的

You can use the keyword WITH to assign a name to a subquery block. Once

the name is assigned, you can reference the name from elsewhere in the query.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11312660/viewspace-718934/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11312660/viewspace-718934/