1Z0-007 · Question #181
Which two statements about subqueries are true? (Choose two.)
The correct answer is B. A SQL query statement cannot display data from table B that is referred to in its subquery, unless D. A single row subquery can retrieve data from more than one table. A SQL query statement cannot display data from table B that is referred to in its sub-query, unless table B is included in the main query's FROM clause. And a single row sub-query can retrieve data from more than one table. Incorrect Answers A: A single row sub-query can…
Question
Which two statements about subqueries are true? (Choose two.)
Options
- AA single row subquery can retrieve data from only one table.
- BA SQL query statement cannot display data from table B that is referred to in its subquery, unless
- CA SQL query statement can display data from table B that is referred to in its subquery, without
- DA single row subquery can retrieve data from more than one table.
- EA single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
- FA multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.
How the community answered
(55 responses)- A2% (1)
- B82% (45)
- C9% (5)
- E2% (1)
- F5% (3)
Explanation
A SQL query statement cannot display data from table B that is referred to in its sub-query, unless table B is included in the main query's FROM clause. And a single row sub-query can retrieve data from more than one table. Incorrect Answers A: A single row sub-query can retrieve data from more than one table. C: A SQL query statement cannot display data from table B that is referred to in its sub- query, unless table B is included in the main query's FROM clause. E: A single row sub-query can be used in a condition where the LIKE operator is used for F: A multiple-row sub-query can be used in a condition where the LIKE operator is used for
Topics
Community Discussion
No community discussion yet for this question.