10 Questions
What type of constraint is applied to a single column only?
Primary Key
Which constraint ensures that a value cannot be NULL?
Primary Key
In database terminology, what does UNIQUE constraint prevent?
Inserting duplicate values
What does a Table Level Constraint affect?
Multiple columns
How many primary keys can a table have?
One and only one
What does a PRIMARY KEY consist of in a database table?
UNIQUE, NOT NULL, Automatic Indexed
Which constraint prevents the insertion of NULL values but allows duplicate values?
UNIQUE
What happens if a column has a DEFAULT constraint when no value is specified during INSERT?
The column gets the value specified in the DEFAULT clause
What does the CHECK constraint allow you to do in a database table?
Verify values against specified conditions
In a composite key, what is the significance of having more than one column as part of the key?
Combines multiple columns to uniquely identify a record
Learn about the various data constraints that can be enforced in a database table, including primary key, not null, unique, default, check, and foreign key constraints. Understand the classification of constraints as column level and table level constraints.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free