Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 42 of 79

MySQL SQL Revision Tour — Question 10

Back to all questions
10
Question

Question 10

What is a constraint ? Name some constraints that you can apply to enhance database integrity.

Answer

A constraint is a condition or check applicable on a field or set of fields. Some constraints that we can apply to enhance database integrity are:

  1. Unique constraint.
  2. Primary key constraint.
  3. Default constraint.
  4. Check constraint.
  5. Foreign key constraint.