Multiple choice technology databases

Which of the following statements about subqueries are true? (Choose 3)

  1. Subqueries can have up to 16 levels of nesting

  2. Subqueries can have up to 50 levels of nesting

  3. Subqueries returning only one row can follow “=” in a WHERE clause

  4. Subqueries returning only one row can follow “IN” in a WHERE clause
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

Subqueries can be nested up to 16 levels deep in SQL Server. Single-row subqueries can follow = operator in WHERE clauses, while both single and multiple-row subqueries can follow IN operator. Options A, C, and D are all valid statements about subquery behavior.

Keep practicing — related questions