nerdexam
Oracle

1Z0-047 · Question #255

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

The correct answer is B. A column with the UNIQUE constraint can contain NULL. 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? (Choose two.)

Options

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

How the community answered

(30 responses)
  • A
    3% (1)
  • B
    83% (25)
  • C
    10% (3)
  • E
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice