Advanced SQL – True or False

11. Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table.

A. True
B. False

Correct Answer: B. False

12. A correlated subquery is where the outer query depends on data from the inner query.

A. True
B. False

Correct Answer: B. False

13. A function returns one value and has only output parameters.

A. True
B. False

Correct Answer: B. False

14. With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.

A. True
B. False

Correct Answer: A. True

Leave A Comment?

4 × four =