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)- A13% (5)
- B80% (32)
- D3% (1)
- E5% (2)
Community Discussion
No community discussion yet for this question.