nerdexam
Oracle

1Z0-071 · Question #74

Which statement is true regarding the UNION operator?

The correct answer is B. Null values are not ignored during duplicate checking. See the full explanation below for the reasoning.

Question

Which statement is true regarding the UNION operator?

Options

  • ABy default, the output is not sorted.
  • BNull values are not ignored during duplicate checking.
  • CNames of all columns must be identical across all select statements.
  • DThe number of columns selected in all select statements need not be the same.

How the community answered

(24 responses)
  • A
    4% (1)
  • B
    71% (17)
  • C
    8% (2)
  • D
    17% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice