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