Exam 1z0-071 topic 1 question 87 discussion

Actual exam question from Oracle's 1z0-071

Question #: 87
Topic #: 1

[All 1z0-071 Questions]

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

A. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns.
B. The WHERE clause can be used to exclude rows after dividing them into groups.
C. The HAVING clause can be used with aggregating functions in subqueries.
D. The WHERE clause can be used to exclude rows before dividing them into groups.
E. Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query.

Show Suggested Answer

Suggested Answer: CD 🗳️

by yaya32 at Jan. 16, 2024, 1:55 p.m.

Comments

Submit Cancel

826cb95

4 days ago

Selected Answer: CD

C & D tested fine.

upvoted 1 times

...

RIDA_007

5 months, 1 week ago

C is incorrect because subqueries using aggregate functions typically do not use HAVING clauses; rather, HAVING is used in the outer query to filter the results of aggregates

upvoted 1 times

...