Appian Associate Developer (ACD100) — Question 17

Which two statements are true about the Primary Key constraint in SQL? (Choose two.)

Answer options

• A. A Primary Key must contain UNIQUE values.
• B. A Primary Key uniquely identifies each record in a SQL database table.
• C. A Primary Key must be mode of a single column only.
• D. A Primary Key must be on integer.

Correct answer: B, C

Explanation

Option B is correct because a Primary Key serves the purpose of uniquely identifying each record in a table. Option C is also correct, as a Primary Key can only be made up of a single column, although it can be part of a composite key with other columns. Options A and D are incorrect; while a Primary Key must have UNIQUE values, it can contain more than one column and does not necessarily have to be an integer.