Oracle
1Z0-071 · Question #208
Which two statements are true regarding subqueries? (Choose two.)
The correct answer is C. A subquery can be used to access data from one or more tables or views. E. If the subquery returns 0 rows, then the value returned by the subquery expression is NULL. See the full explanation below for the reasoning.
Question
Which two statements are true regarding subqueries? (Choose two.)
Options
- AOnly two subqueries can be placed at one level.
- BA subquery in the WHERE clause of a SELECT statement can be nested up to three levels only.
- CA subquery can be used to access data from one or more tables or views.
- DThe columns in a subquery must always be qualified with the name or alias of the table used.
- EIf the subquery returns 0 rows, then the value returned by the subquery expression is NULL.
How the community answered
(64 responses)- A16% (10)
- B8% (5)
- C72% (46)
- D5% (3)
Community Discussion
No community discussion yet for this question.