nerdexam
Oracle

1Z0-071 · Question #384

Which two are true about scalar subquery expressions? (Choose two.)

The correct answer is A. They can return at most one row. D. You must enclose them in parentheses. See the full explanation below for the reasoning.

Question

Which two are true about scalar subquery expressions? (Choose two.)

Options

  • AThey can return at most one row.
  • BYou can use them as a default value for a column.
  • CYou cannot correlate them with a table in the parent statement.
  • DYou must enclose them in parentheses.
  • EThey can return two columns.

How the community answered

(21 responses)
  • A
    76% (16)
  • B
    14% (3)
  • C
    5% (1)
  • E
    5% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice