007题库答案子查询矛盾

[lcw321321]

Which two statements about subqueries are true? (Choose two.)

A. A single row subquery can retrieve data from only one table.
B. A SQL query statement cannot display data from table B that is referred to in its
subquery, unless table B is included in the main query's FROM clause.
C. A SQL query statement can display data from table B that is referred to in its
subquery, without including table B in its own FROM clause.
D. A single row subquery can retrieve data from more than one table.
E. A single row subquery cannot be used in a condition where the LIKE operator is used
for comparison.
F. A multiple-row subquery cannot be used in a condition where the LIKE operator is
used for comparison.
Answer: B, D

Which two statements about subqueries are true? (Choose two.)
A. A single row subquery can retrieve data from only one table.
B. A SQL query statement cannot display data from table B that is referred to in its
subquery, unless table B is included in the main query's FROM clause.
C. A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
D. A single row subquery can retrieve data from more than one table.
E. A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
F. A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
Answer: B, F

这D答案到底是对还是错啊?谢谢
个人觉得是对的

[minitoy]

第二个F明显是错的呀.insert into select;
select可以返回多行.
另外,第一个的F应该没错吧.
第一个感觉bdf全对,第二个bd

[minitoy]

你的答案哪儿来的?

[lcw321321]

从一个国外网站上下载的

[lcw321321]

OCP培训机构给的题库也是这样

[tangren]

哪两个有关子查询的陈述是正确的？ （选择两项）。
A. 单行子查询可以只从一个表中检索数据。
B. 一个SQL查询语句不能显示来自表B的数据，除非表B是包含在主查询的FROM子句。
C. 一个SQL查询语句可以显示来自不包括在自己的FROM子句中的B表的数据。
D. 单行子查询可以检索从多个表中的数据。
E. 单行子查询不能用在这样一种情况：使用LIKE运算符进行比较。
F. 多行子查询不能用在一个条件下的LIKE运算符用于比较。

哪两个有关子查询的陈述是正确的？ （选择两项）。
A. 单行子查询可以只从一个表中检索数据。
B. 一个SQL查询语句不能显示来自表B的数据，除非表B是包含在主查询的FROM子句。
c. 一个SQL查询语句可以显示来自不包括在自己的FROM子句中的B表的数据。
D. 单行子查询可以检索从多个表中的数据。
E. 单行子查询不能使用在LIKE条件中来进行比较。
F. 多行子查询不能用在INSERT语句中一次性插入多行。

动动手，自己实践一下便可知

[iqlife]

1：BD
2：BD

2的F，说的是：多行子查询不能用在INSERT语句的一次插入多行
这个是可以的

INSERT INTO TABLE SELECT .....

[心中的彩虹]

[Quote=引用楼主 lcw321321 的回复:]
Which two statements about subqueries are true? (Choose two.)

A. A single row subquery can retrieve data from only one table.
B. A SQL query statement cannot display data from table B that is refe……
[/Quote]
1
bd

2
bd

F. A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
是可以返回多行的 insert into tb select * from tb