Which statement regarding NOT ENFORCED unique constraints is true?
A. NOT ENFORCED unique constraints enforce uniqueness only for primary key columns.
B. The query optimizer will consider a NOT ENFORCED unique constraint when selecting the optimal data access plan.
C. Storage requirements for NOT ENFORCED unique constraints are identical to storage requirements for a unique index.
D. When attempting to insert data that does not conform to the NOT ENFORCED unique constraint, an error will be returned and the record will not be inserted.
Which statement regarding NOT ENFORCED unique constraints is true?
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Which statement regarding NOT ENFORCED unique constraints is true?
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!