COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How many Primary key a table can max have?
|
Depends on no of Columns
|
|
Only 2
|
|
Only 1
|
|
Depends on DBA
|
Explanation:
Detailed explanation-1: -A table can have only ONE primary key; and in the table, this primary key can consist of single or multiple columns (fields).
Detailed explanation-2: -A table can only have one primary key, but it can have multiple unique constraints.
Detailed explanation-3: -A primary key uniquely identifies each record in a table. Every table has a primary key, and there can only be one primary key per table.
There is 1 question to complete.