Which two statements are true about the Primary Key constraint in SQL? (Choose two.)
Which two statements are true about the Primary Key constraint in SQL? (Choose two.)
A Primary Key must contain UNIQUE values, ensuring that each entry in that column is distinct and identifiable. Additionally, a Primary Key uniquely identifies each record in a SQL database table, ensuring that each record can be retrieved through this unique identifier.
correct answer is AB
Should A and B
Correct:AB "The PRIMARY KEY constraint uniquely identifies each record in a table. Primary keys must contain UNIQUE values, and cannot contain NULL values. A table can have only ONE primary key; and in the table, this primary key can consist of single or multiple columns (fields)." https://www.w3schools.com/sql/sql_primarykey.ASP#:~:text=Primary%20keys%20must%20contain%20UNIQUE,or%20multiple%20columns%20(fields).
C is not a true statement. A primary key can be made up of one or more columns in a table. Therefore answer is A and B
Correct Answer: AB