COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The key that can be used for data retrieval is known as ____
|
|
Foreign key
|
|
|
Surrogate key
|
|
|
Primary key
|
|
|
Secondary key
|
Explanation:
Detailed explanation-1: -Alternate keys are candidate keys that are not selected as the primary keys. The alternate key can also work as a primary key. The alternate key is also called the “Secondary Key”.
Detailed explanation-2: -Candidate key is an attribute or set of attributes that you can consider as a Primary key. Note: Secondary Key is not a Foreign Key.
Detailed explanation-3: -4) Secondary key: is a key that is used strictly for data retrieval purposes. For example: suppose customer data are stored in a CUSTOMER table in which the customer number is the primary key. Do you suppose that most customers will remember their numbers?
There is 1 question to complete.