Question $7$

$2$ pts

When building a sub query that refers to the same table as the outer query, the use of a correlation variable is required to distinguish accessing the table from the outer query versus the sub query.

True

False

Question $8$

$2$ pts

Sub queries are limited in use to the WHERE and FROM clauses

$$ True

False

Question $9$

$2$ pts

Temporary tables are limited to combining two other tables and it only persists for the current active session.

True

False

Question $10$

$2$ pts

Scalar sub queries are used when a single value is expected as a result. If more than one value is returned you will get a runtime error.

$$ True:

Fatse