nerdexam
Oracle

1Z0-071 · Question #130

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

The correct answer is A. A subquery can appear on either side of a comparison operator. C. A subquery can retrieve zero or more rows. See the full explanation below for the reasoning.

Question

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

Options

  • AA subquery can appear on either side of a comparison operator.
  • BOnly two subqueries can be placed at one level.
  • CA subquery can retrieve zero or more rows.
  • DA subquery can be used only in SQL query statements.
  • EThere is no limit on the number of subquery levels in the WHERE clause of a SELECT statement.

How the community answered

(26 responses)
  • A
    73% (19)
  • B
    8% (2)
  • D
    4% (1)
  • E
    15% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice