PREMIUM
Join our WhatsApp Channel
Daily MCQs, Past Papers & Jobs for PPSC, FPSC, CSS
Daily MCQs • Past Papers • Jobs for PPSC, FPSC, CSS
Join Channel

What is a primary key in a database?

A. Uniquely identifies each record
B. Auto number is example of key
C. cannot be repeated
D. All of these
Correct Answer: D. All of these

Correct answer: All of these. All three are true, so All of these is the complete answer.

Background: A primary key is a column with a unique value in every row.

  • Uniquely identifies each record: True, but only one property.
  • Auto number is example of key: True, since AutoNumber fields are often used, but only one example.
  • cannot be repeated: True, as duplicates are not allowed, but only one property.

Did you know? One table has one primary key, but it can combine columns.

Memory trick: Primary means one and only.

0 comments

Leave a Reply

Join Our WhatsApp Channel ×