OCP-1Z0-新051-61题版本-31
来源:互联网 发布:畅享6s只有2g网络 编辑:程序博客网 时间:2024/05/19 16:49
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
- OCP-1Z0-新051-61题版本-31
- OCP-1Z0-新051-61题版本-61
- OCP-1Z0-新051-61题版本-1
- OCP-1Z0-新051-61题版本-2
- OCP-1Z0-新051-61题版本-3
- OCP-1Z0-新051-61题版本-4
- OCP-1Z0-新051-61题版本-5
- OCP-1Z0-新051-61题版本-6
- OCP-1Z0-新051-61题版本-7
- OCP-1Z0-新051-61题版本-8
- OCP-1Z0-新051-61题版本-9
- OCP-1Z0-新051-61题版本-10
- OCP-1Z0-新051-61题版本-11
- OCP-1Z0-新051-61题版本-12
- OCP-1Z0-新051-61题版本-13
- OCP-1Z0-新051-61题版本-14
- OCP-1Z0-新051-61题版本-15
- OCP-1Z0-新051-61题版本-16
- map、multimaps函数
- 常量指针与指针常量的区别(转帖)
- 时域和频域的关系及matlab演示
- OCP-1Z0-新051-61题版本-30
- 原子移动云服务开发者春季联盟启动了
- OCP-1Z0-新051-61题版本-31
- 世界名著100部简介
- PCB设计的一般原则
- OCP-1Z0-新051-61题版本-32
- 锁相环的组成和工作原理
- 聊聊主流框架,Less/Sass/Compass/Bootstrap/H5bp
- 如何在iphone/ipad/itouch上设置新浪VIP邮箱
- HTTP Keep-Alive
- 题目1208:10进制 VS 2进制