Multiple choice technology web technology

A subquery can consist of a statement located within a clause from a parent statement. Which of the following options apply to a subquery? (MCQ)

  1. Create another SELECT statement in a FROM clause

  2. Create a WHERE statement in an UPDATE clause.

  3. Create another SELECT statement in a HAVING clause.

  4. Create an ALTER statement in a SET clause
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

Subqueries can be placed in the FROM clause (inline views), the HAVING clause of a SELECT statement, and the WHERE clause of UPDATE/DELETE/SELECT statements. ALTER is a DDL command and cannot contain subqueries in a SET clause.

Keep practicing — related questions