Vidyalelo
SQL · Q49

SQL

Programming · SQL · question 49

Q49

Which of the following is NOT a type of SQL constraint?

A.
PRIMARY KEY
B.
ALTERNATE KEY
Answer
C.
FOREIGN KEY
D.
UNIQUE

Answer: Option B

Solution

Answer: Option B
Solution:
An ALTERNATE KEY is not a type of SQL constraint. The other options, PRIMARY KEY, FOREIGN KEY, and UNIQUE, are all types of constraints used in SQL:
PRIMARY KEY ensures that a column or set of columns uniquely identifies each row in a table.
FOREIGN KEY establishes a link between two tables, enforcing referential integrity between them.
UNIQUE constraint ensures that values in a column (or set of columns) are unique across the table, but it doesn't require that the column(s) be the primary means of identifying rows.
Option B, ALTERNATE KEY, is not a standard SQL constraint term.