Which two statements about subqueries are true? (Choose two.)

Question

Options

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

• A
  3% (1)
• B
  70% (23)
• C
  15% (5)
• D
  6% (2)
• E
  6% (2)

Explanation

subquery can retrieve zero or more rows, subquery is used with an inequality camparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column. Incorrect answer: A subquery can retrieve zero or more rows C subquery is not SQL query statement D subquery can be nested E group function can be use with subquery

No community discussion yet for this question.