Which of these are standard and best practises for SQL?
Answer options
A
Each table must have a primary key.
B
Tables should not have foreign keys.
C
NULL values should never be used.
D
All columns must have unique values.
Correct answer: Each table must have a primary key.
Explanation
Quick AnswerThe correct answer is Each table must have a primary key. because it directly addresses the core logic of Database Management.
Best practice mandates every table has a primary key to uniquely identify rows.