Question

QUESTION 55

Which of the following is true of the primary key?
A. It must be defined as a Text or AutoNumber field.
B. It can only be made up of one field.
C. It can never be changed.
D. It's values must be unique.
E. It must be first in a table.

Answer 1

The primary key must have unique values, but it can be defined as any data type and can be composed of one or multiple fields.

Step-by-step explanation:

The correct answer is D. Its values must be unique. A primary key is a field or combination of fields that uniquely identifies each record in a table. It's important for primary key values to be unique because it ensures that each record can be uniquely identified and accessed.

A primary key can be made up of one or multiple fields, so option B is incorrect. Option A is also incorrect because a primary key can be defined as any data type, not just Text or AutoNumber. Option C is incorrect because a primary key can be changed, although it is generally not recommended. Option E is also incorrect because the primary key can be any field in a table, not just the first one.

In summary, the primary key must have unique values, but it can be defined as any data type and can be composed of one or multiple fields.