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)- A3% (1)
- B83% (25)
- C10% (3)
- E3% (1)
Community Discussion
No community discussion yet for this question.