Skills101
← All practice quizzes

Quiz: Subqueries and Views

5 questionsNo time limitPass: 60%+10 XP on first pass

Queries inside queries. Single-row and multi-row subqueries, correlated subqueries, EXISTS vs IN, WITH (CTE) for readable SQL, UNION, and views.

Log in to take the quiz

Free account · see your score, answers and explanations, earn XP

  1. Question 1

    A subquery that refers to a column of the outer query is called:

  2. Question 2

    What is the difference between UNION and UNION ALL?

  3. Question 3

    Why can NOT IN (subquery) return no rows unexpectedly?

  4. Question 4

    What does a (non-materialized) view store?

  5. Question 5

    Which keyword starts a Common Table Expression?