Which three statements about subqueries are true?

Q. Which three statements about subqueries are true? (Choose three).

A. A single row subquery can retrieve only one column and one row

B. A single row subquery can retrieve only one row but many columns

C. A multiple row subquery can retrieve multiple rows and multiple columns

D. A multiple row subquery can be compared using the ">" operator

E. A single row subquery can use the IN operator F. A multiple row subquery can use the "=" operator

Answer: BCE