Question

Which of the following is NOT a type of SQL constraint?
A.PRIMARY KEY
B.ALTERNATE KEY
C.FOREIGN KEY
D.UNIQUE

Answer 1

______✨ HEY MATE ✨_____

➡️ Option (D) UNIQUE is the right answer ✔️

$<marquee>✌️ I THINK IT HELPED YOU ✌️$

Answer 2

ALTERNATE KEY is NOT a type of SQL constraint. Hence, correct option is option(b).

• There are three types of keys in SQL which are PRIMARY KEY, FOREIGN KEY, and UNIQUE KEY.
• The ALTERNATE KEY has all the properties to become the candidate key and they uniquely identify a row in the table.
• The set of candidate keys other than the PRIMARY KEY is called the ALTERNATE KEY.
• They are unique for each row and can have single or multiple attributes.