nerdexam
Oracle

1Z0-071 · Question #139

Which two statements are true regarding constraints? (Choose two.)

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

Question

Which two statements are true regarding constraints? (Choose two.)

Options

  • AAll constraints can be defined at the column level and at the table level.
  • BA constraint can be disabled even if the constraint column contains data.
  • CA column with the UNIQUE constraint can contain NULLS.
  • DA foreign key column cannot contain NULLS.
  • EA constraint is enforced only for INSERT operations.

How the community answered

(40 responses)
  • A
    13% (5)
  • B
    80% (32)
  • D
    3% (1)
  • E
    5% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice