Subquery True and False

Question 1

A correlated subquery is executed once for each row processed by the outer query.

- True
- False

Answer 1

True

Question 2

A subquery can be used in the SELECT clause.

- True
- False

Answer 2

True

Question 3

Subqueries can be nested inside other subqueries.

- True
- False

Answer 3

True

Question 4

A scalar subquery can return multiple columns.

- True
- False

Answer 4

False

Question 5

An inline subquery is also known as a derived table or a subquery in the FROM clause.

- True
- False

Answer 5

True