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