nerdexam
Oracle

1Z0-071 · Question #170

Which two statements are true regarding constraints?

The correct answer is B. A column with the UNIQUE constraint can contain null values. D. A constraint can be disabled even if the constraint column contains data. See the full explanation below for the reasoning.

Question

Which two statements are true regarding constraints?

Options

  • AA foreign key column cannot contain null values.
  • BA column with the UNIQUE constraint can contain null values.
  • CA constraint is enforced only for INSERT operation on the table.
  • DA constraint can be disabled even if the constraint column contains data.
  • EAll constraints can be defined at the column level and at the table level.

How the community answered

(30 responses)
  • A
    7% (2)
  • B
    77% (23)
  • C
    3% (1)
  • E
    13% (4)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice