Module 3 Flashcards

1
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

rules that we can apply on the type of data in a table

A

constraints

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

list all available constraints in SQL

A

NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

cannot store a null value in a column

A

NOT NULL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

all the values in the column must be unique, values in any row of that column must not be repeated

A

UNIQUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

field which can uniquely identify each row in a table

A

PRIMARY KEY

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

uniquely identify each row in another table

A

FOREIGN KEY

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

specifies a default value for the column when no value is specified by the user

A

DEFAULT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly