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
Computer science and IT MCQs for competitive and job exams.
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.