DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Field
|
|
Primary key
|
|
Either A or B
|
|
None of the above
|
Detailed explanation-1: -Answer: Primary Key-a field containing a value that uniquely identifies each record in a table.
Detailed explanation-2: -Primary key A table can have only one primary key. A primary key consists of one or more fields that uniquely identify each record that you store in the table. Often, there is a unique identification number, such as an ID number, a serial number, or a code, that serves as a primary key.
Detailed explanation-3: -A primary key is a field or set of fields with values that are unique throughout a table. Values of the key can be used to refer to entire records, because each record has a different value for the key. Each table can only have one primary key.
Detailed explanation-4: -A primary key is the column or columns that contain values that uniquely identify each row in a table. A database table must have a primary key for Optim to insert, update, restore, or delete data from a database table. Optim uses primary keys that are defined to the database.
Detailed explanation-5: -A primary key is used as a unique identifier to quickly parse data within the table. 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.