Oracle
1Z0-071 · Question #130
Which two statements are true regarding subqueries? (Choose two.)
The correct answer is A. A subquery can appear on either side of a comparison operator. C. A subquery can retrieve zero or more rows. See the full explanation below for the reasoning.
Question
Which two statements are true regarding subqueries? (Choose two.)
Options
- AA subquery can appear on either side of a comparison operator.
- BOnly two subqueries can be placed at one level.
- CA subquery can retrieve zero or more rows.
- DA subquery can be used only in SQL query statements.
- EThere is no limit on the number of subquery levels in the WHERE clause of a SELECT statement.
How the community answered
(26 responses)- A73% (19)
- B8% (2)
- D4% (1)
- E15% (4)
Community Discussion
No community discussion yet for this question.