OCP-1Z0-新051-61题版本-31

QUESTION NO: 31

Which two statements about sub queries are true? (Choose two.)

A. A sub query should retrieve only one row.

B. A sub query can retrieve zero or more rows.

C. A sub query can be used only in SQL query statements.

D. Sub queries CANNOT be nested by more than two levels.

E. A sub query CANNOT be used in an SQL query statement that uses group functions.

F. When a sub query is used with an inequality comparison operator in the outer SQL statement,

the column list in the SELECT clause of the sub query should contain only one column.

Answer: B,F

答案解析：

参考：133：http://blog.csdn.net/rlhua/article/details/12883407

F选项跟133不一致：非等值比较时，子查询只能出现一个值，正确。

Explanation: Explanation: sub query can retrieve zero or more rows, sub query is used with an

inequality comparison operator in the outer SQL statement, and the column list in the SELECT

clause of the sub query should contain only one column.

Incorrect answer:

Oracle 1z0-051 Exam

"Pass Any Exam. Any Time." - 100% Pass Guarantee 26

Asub query can retrieve zero or more rows

Csub query is not SQL query statement

Dsub query can be nested

Egroup function can be use with sub query