How many Primary keys can have in a table?

DWQA QuestionsCategory: SQLHow many Primary keys can have in a table?
Editor Staff asked 9 months ago

How many Primary keys can have in a table?

  1. Only 1
  2. Only 2
  3. Depends on no of Columns
  4. Depends on DBA
1 Answers
Editor Staff answered 9 months ago

A-Only 1
Explanation: The primary key can consist of a single or combination of the field that uniquely identifies each record in a table. It cannot be null or empty. A table may have duplicate columns, but it can contain only one primary key