Multiple choice

Which of the following statements is TRUE about a subquery?

  1. Subqueries are mainly of two types - nested and correlated.

  2. A subquery usually have an outer query and an inner query.

  3. A subquery can be written using either a single or multiple tables.

  4. Generally, the innermost subquery is executed first and based on its results, outer queries will execute.

  5. All of the above

Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Yes, all of the above statements are correct.

Keep practicing — related questions