Which two statements about sub queries are true? (Choose two.)

Question

Options

• AA sub query should retrieve only one row.
• BA sub query can retrieve zero or more rows.
• CA sub query can be used only in SQL query statements.
• DSub queries CANNOT be nested by more than two levels.
• EA sub query CANNOT be used in an SQL query statement that uses group functions.
• FWhen a sub query is used with an inequality comparison operator in the outer SQL statement, the

• A
  3% (1)
• B
  76% (26)
• C
  6% (2)
• E
  15% (5)

Explanation

sub query can retrieve zero or more rows, sub query is used with an inequality comparison operator in the outer SQL statement, and the column list in the SELECT clause of the sub query should contain only one column.

No community discussion yet for this question.