SQL Server Constraints

Question 1

NOT NULL

Answer 1

Ensures that a column cannot have a NULL or empty value

Question 2

UNIQUE

Answer 2

Ensures that all values in a column are different

Question 3

PRIMARY KEY

Answer 3

Uniquely identifies each row in a table

Question 4

FOREIGN KEY

Answer 4

Used to create the link to another table

Question 5

CHECK

Answer 5

Ensures that all values in a column satisfy a specific condition

Question 6

DEFAULT

Answer 6

Sets a default value for a column when no value is specified; for example, set a default for state if most customers are from FL

Question 7

INDEX

Answer 7

Used to create and retrieve data from the database very quickly

Question 8

CONSTRAINT

Answer 8

Is a rule in the database