nerdexam
Oracle

1Z0-071 · Question #152

A subquery is called a single-row subquery when _______.

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

Question

A subquery is called a single-row subquery when _______.

Options

  • AThere is only one subquery in the outer query and the inner query returns one or more values
  • BThe inner query returns a single value to the outer query.
  • CThe inner query uses an aggregating function and returns one or more values.
  • DThe inner query returns one or more values and the outer query returns a single value.

How the community answered

(48 responses)
  • A
    15% (7)
  • B
    73% (35)
  • C
    4% (2)
  • D
    8% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice