Multiple choice technology programming languages

Which three statements are true about multiple-row subqueries?

  1. They can contain a subquery within a subquery.

  2. They can return multiple columns as well as rows.

  3. They cannot contain a subquery within a subquery.

  4. They can return only one column but multiple rows.

  5. They can contain group functions and GROUP BY and HAVING clauses.

  6. They can contain group functions and the GROUP BY clause, but not the HAVING clause.
Reveal answer Fill a bubble to check yourself
A,B,E Correct answer
Explanation

Multiple-row subqueries can be nested (subquery within a subquery), can return multiple columns along with rows, and support group functions with GROUP BY and HAVING clauses for advanced data aggregation and filtering.

Keep practicing — related questions