Which of the following statements are correct? A. The HAVING CLAUSE is an…

2026

Which of the following statements are correct?

A. The HAVING CLAUSE is an optional clause which tells Oracle to group rows based on distinct values that exist for specified columns.

B. Unions can be used in subqueries.

C. The intersect clause outputs only rows produced by both the queries intersected.

D. The statement containing a subquery is called a parent statement.

E. If a select statement is defined as a subquery, the innermost select statement gets executed first.

Choose the correct answer from the options given below:

  1. A, B, C Only

  2. C, D, E Only

  3. B, C, E Only

  4. A, B, D Only

  1. A.

    1

  2. B.

    2

  3. C.

    3

  4. D.

    4

Attempted by 85 students.

Show answer & explanation

Correct answer: C

Statement A is incorrect because HAVING filters groups after aggregation, whereas GROUP BY handles distinct values. Statement B is correct as unions can be used in subqueries (derived tables). Statement C correctly defines INTERSECT, outputting only rows produced by both queries. Statement E accurately describes subquery execution order (innermost first). Thus, B, C, and E are the correct statements.

Explore the full course: Mppsc Assistant Professor