MCQ: Advanced SQL Tutorial | Subqueries

Select the correct single-word answer.

1. Subqueries are often referred to as ______ queries.

• Nested
• Primary
• Joined
• Outer
• Reveal Answer

2. In which SQL clause can a subquery be used to calculate an aggregate for all rows?

• Where
• From
• Group
• Select
• Reveal Answer

3. Subqueries in the FROM clause are generally considered less ______ than CTEs or temp tables.

• Efficient
• Useful
• Complex