Computer Science · Programming & Databases
A primary key must be:
ANullableBDuplicateCUnique and not nullDAuto-increment only
Why? A primary key uniquely identifies each row and cannot contain NULL.
Asked in: PPSC
Provincial recruitment examinations for Punjab.
Why? A primary key uniquely identifies each row and cannot contain NULL.
Why? SELECT DISTINCT eliminates duplicate rows from the result set.
Why? The WHERE clause filters rows before grouping or ordering.