Oracle
1Z0-071 · Question #156
1Z0-071 Question #156: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #156. The question stem and answer options stay visible for context.
Question
Which two statements are true regarding the WHERE and HAVING clauses in a SELECT statement? (Choose two.)
Options
- AThe WHERE and HAVING clauses can be used in the same statement only if they are applied to
- BThe aggregate functions and columns used in the HAVING clause must be specified in the
- CThe WHERE clause can be used to exclude rows after dividing them into groups.
- DThe HAVING clause can be used with aggregate functions in subqueries.
- EThe WHERE clause can be used to exclude rows before dividing them into groups.
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.