Multiple choice technology databases

Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy

  1. Yes

  2. No

  3. NA

  4. na
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

By default, an integrity constraint cannot be enabled or enforced on a table if existing rows violate it. You must clean up the violating data first, or use the NOVALIDATE state, making 'No' the correct choice and 'Yes' incorrect.

Keep practicing — related questions