CONTRAINTS Flashcards
1
Q
Ensures that a column cannot have a NULL value
A
NOT NULL
2
Q
Ensures that all values in a column are different
A
UNIQUE
3
Q
A combination of aNOT NULLandUNIQUE. Uniquely identifies each row in a table
A
PRIMARY KEY
4
Q
Prevents actions that would destroy links between tables
A
FOREIGN KEY
5
Q
Ensures that the values in a column satisfies a specific condition
A
CHECK
6
Q
Sets a _ value for a column if no value is specified
A
DEFAULT
7
Q
Used to create and retrieve data from the database very quickly
A
CREATE INDEX
