WHAT ARE THE DISTINGUISHING CHARACTERISTICS OF A SCALAR SUBQUERY

6. What are the distinguishing characteristics of a scalar subquery? (Choose two

correct answers.)

A. A scalar subquery returns one row.

B. A scalar subquery returns one column.

C. A scalar subquery cannot be used in the SELECT list of the parent query.

D. A scalar subquery cannot be used as a correlated subquery.