047-134

134. Which two statements are true regarding subqueries? (Choose two.)

A. Only two subqueries can be placed at one level.

B. A subquery can be used to access data from one or more tables or views.

C. If the subquery returns 0 rows, then the value returned by the subquery

expression is NULL.

D. The columns in a subquery must always be qualified with the name or alias

of the table used.

E. A subquery in the WHERE clause of a SELECT statement can be nested up to

three levels only.

Answer: BC

Qualify:限制

SQL> select decode((select revenue from test where dest='dd'),null,11) dest

from test;

DEST

----------

11

说明如果子查询返回0行，则整个返回值为空

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

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