Module 3 Flashcards
1
Q
A
2
Q
rules that we can apply on the type of data in a table
A
constraints
3
Q
list all available constraints in SQL
A
NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT
4
Q
cannot store a null value in a column
A
NOT NULL
5
Q
all the values in the column must be unique, values in any row of that column must not be repeated
A
UNIQUE
6
Q
field which can uniquely identify each row in a table
A
PRIMARY KEY
7
Q
uniquely identify each row in another table
A
FOREIGN KEY
8
Q
validate the values of a column to meet a particular condition; helps ensure that the value stored in a column meets a specific condition
A
CHECK
9
Q
specifies a default value for the column when no value is specified by the user
A
DEFAULT
10
Q
A