首页 > Linux操作系统 > Linux操作系统 > 047-122


原创 Linux操作系统 作者:jbymy2000 时间:2012-03-19 09:41:27 0 删除 编辑
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博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: 047-120
下一篇: 047-123
请登录后发表评论 登录


  • 博文量
  • 访问量