OCP-1Z0-051 补充题库第31题 subquery子查询的注意事项

最新推荐文章于 2022-04-13 20:14:00 发布

原创

最新推荐文章于 2022-04-13 20:14:00 发布 · 3.5k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#OCP-1Z0-051 #subquery #子查询 #11g

本文详细解析了Oracle认证考试中的子查询相关问题，指出子查询可以返回0行或多行，并且可以广泛应用于SQL的各种语句中，如SELECT, DELETE, INSERT, UPDATE等。同时强调，在子查询与不等值操作结合时，子查询的SELECT子句应只包含一列。通过示例演示了子查询的正确用法及其限制。" 52668162,5656698,MDX查询基础与应用,"['多维数据', '数据查询', '数据筛选', '数据分析']

一、原题

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.

答案: B,F

二、题目翻译

下面关于子查询的说法，哪两个是正确的?（选择