试题详情
- 多项选择题Which two statements about subqueries are true? （）
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 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.
关注下方微信公众号，在线模考后查看
热门试题
- Which four statement
- Which four are corre
- Examine the data in
- Examine the structu
- You need to produce
- What is true of usin
- The EMPLOYEES table
- ClicktheExhibitbutto
- Which SQL statement
- The user Alice wants
- Which three SELECT s
- The EMP table has t
- You need to change t
- ClicktheExhibitbutto
- Examine the descrip
- Which two statements
- Examine this stateme
- Evaluate this SQL st
- ClicktheExhibitbutto
- Which are DML statem