COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
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: -helps identify unique data, such as a customer ID; prevents duplication of records in a table; helps with updating or deleting only specific records; helps ensure that fields aren’t null; helps set up relationships between tables; and. ensures row-level accessibility.
Detailed explanation-2: -Primary Key-a field containing a value that uniquely identifies each record in a table. The primary key is unique and prevents entering duplicate records or a null value in that field. Foreign Key-a key in a related table that refers to the primary key in another table.
There is 1 question to complete.