Oracle
1Z0-047 · Question #67
1Z0-047 Question #67: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-047 to reveal the answer and full explanation for question #67. The question stem and answer options stay visible for context.
Question
Which two statements are true regarding subqueries? (Choose three.)
Options
- AThe ORDER BY clause can be used in the subquery.
- BA subquery can be used in the FROM clause of a SELECT statement.
- CIf the subquery returns NULL, the main query may still return result rows.
- DA subquery can be placed in a WHERE clause, GROUP BY clause, or a HAVING clause.
- ELogical operators, such as AND, OR and NOT, cannot be used in the WHERE clause of a subquery.
Unlock 1Z0-047 to see the answer
You've previewed enough free 1Z0-047 questions. Unlock 1Z0-047 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.