Choose the right statement
[A]
Sub-queries return a single constant this constant can be compared with another value in a WHERE clause;
[B]
Sub-queries return relations, that can be used in WHERE clause
[C]
Sub-queries can appear in FROM clauses, followed by a tuple variable
[D]
All of the others
Answer: D