Oracle
1Z0-061 · Question #189
Which two statements are true regarding sub queries? (Choose two.)
The correct answer is A. A sub query can retrieve zero or more rows. D. A sub query can appeal* on either side of a comparison operator. See the full explanation below for the reasoning.
Question
Which two statements are true regarding sub queries? (Choose two.)
Options
- AA sub query can retrieve zero or more rows.
- BOnly two sub queries can be placed at one level.
- CA sub query can be used only in SQL query statements.
- DA sub query can appeal* on either side of a comparison operator.
- EThere is no limit on the number of sub query levels in the WHERE clause of a SELECT statement.
How the community answered
(57 responses)- A84% (48)
- B9% (5)
- C4% (2)
- E4% (2)
Community Discussion
No community discussion yet for this question.