Home » Oracle » 1z0-051 » Which two statements are true regarding constraints?
Which two statements are true regarding constraints? (Choose two.)
A. A constraint can be disabled even if the constraint column contains data
B. A constraint is enforced only for the INSERT operation on a table
C. A foreign key cannot contain NULL values
D. All constraints can be defined at the column level as well as the table level
E. A column with the UNIQUE constraint can contain NULL values
Correct Answer: AE
Explanation/Reference:
Explanation:
Including Constraints
• Constraints enforce rules at the table level.
• Constraints prevent the deletion of a table if there are dependencies.
• The following constraint types are valid:
- NOT NULL
- UNIQUE
- PRIMARY KEY
- FOREIGN KEY
- CHECK
Download Printable PDF. VALID exam to help you PASS.
|
|