DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Why would you create a primary key?
|
|
To make each record in a database unique
|
|
|
To make each field in a database unique
|
|
|
To make each query in a database unique
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -A primary key is used to ensure data in the specific column is unique. You can only set constraints with primary keys, by setting a foreign key to another column which creates a relationship with the column that has the primary key set. A prime use of a primary key is in the case of a users table.
Detailed explanation-2: -The most significant advantages of a primary key are: It uniquely identifies each row of a table. It gets a unique index for each primary key column that helps with faster access.
There is 1 question to complete.