Oracle
1Z0-071 · Question #208
1Z0-071 Question #208: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #208. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.