nerdexam
Oracle

1Z0-047 · Question #36

A subquery is called a single-row subquery when

The correct answer is A. the inner query returns a single value to the main query. See the full explanation below for the reasoning.

Question

A subquery is called a single-row subquery when

Options

  • Athe inner query returns a single value to the main query
  • Bthe inner query uses an aggregate function and returns one or more values
  • Cthere is only one inner query in the main query and the inner query returns one or more values
  • Dthe inner query returns one or more values and the main query returns a single value as output

How the community answered

(43 responses)
  • A
    84% (36)
  • B
    9% (4)
  • C
    2% (1)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice