nerdexam
Oracle

1Z0-061 · Question #189

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

The correct answer is A. A sub query can retrieve zero or more rows. D. A sub query can appeal* on either side of a comparison operator. See the full explanation below for the reasoning.

Question

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

Options

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

How the community answered

(57 responses)
  • A
    84% (48)
  • B
    9% (5)
  • C
    4% (2)
  • E
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice