Exam 1z0-071 Topic 9 Question 123 Discussion

Actual exam question for Oracle's 1z0-071 exam
Question #: 123
Topic #: 9

Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement?
(Choose all that apply.)

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

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business