Key constraint states that:
2016
Key constraint states that:
Answer: D. the value of primary key must be unique in all tuples — a key constraint ensures that an identifier uniquely distinguishes each row within a relation. The value of a primary key must be unique in all tuples and…
- A.
a table can't have more than one candidate keys
- B.
a table can't have both primary key and foreign key
- C.
the value of foreign key can't be null
- D.
the value of primary key must be unique in all tuples
Attempted by 402 students.
Show answer & explanation
Correct answer: D
a key constraint ensures that an identifier uniquely distinguishes each row within a relation. The value of a primary key must be unique in all tuples and cannot contain duplicate values, maintaining data integrity. Therefore, Option D is the correct answer.
Loading lesson…