COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How many Primary keys can be created on a table?
|
|
Infinity
|
|
|
2
|
|
|
1
|
|
|
24
|
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: -There are two types of keys: primary and secondary. 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.
Detailed explanation-3: -A table cannot have more than one primary key. A primary key’s main features are: It must contain a unique value for each row of data.
There is 1 question to complete.