Question

can there be multiple primary keys in a table? justify your answer​

Answer 1

Answer:

No

Explanation:

You cannot have multiple primary keys in a table. The reason is that only one field can be used as a unique identification feature for every record.

Answer 2

Answer: - No, there cannot be multiple primary keys in a table. This is because the table does not have the permission to contain, or to have multiple primary keys. Primary keys are used for a unique value, so if we try to put multiple primary keys in a table then it won't be able to find the unique value.

Detailed answer: -

• A table can only have a single primary key in it, but the primary key can have different or more than one column.
• As the primary key is used to provide a unique value in a table.
• The unique value helps the user to identify a specific row that is needed in a table.
• Every table has a primary key in it.
• It is formed by one or more than one column.
• The primary key in a table is used to maintain the consistency of the data given in the table, which is the most important task to do.
• The problem in the consistency of data is the problem of duplication and this issue is prevented by the primary key in the table.
• Whenever a user creates a primary key, the database creates an index on the table for it.
• This index which is created by the database is the part of the primary key.

Therefore,

• As single primary keys are used in a table, we cannot add multiple primary keys in the table.

To know more about the topic, visit the below links: -

https://brainly.in/question/5489988

https://brainly.in/question/14856331

#SPJ3