Which of the following are the benefits of specifying a primary key for a table in Microsoft Office
Access 2010?
Each correct answer represents a complete solution. Choose all that apply.
A.
MS Access restricts the data type, valid values, and range of possible values for columns in a table.
B.
MS Access ensures that each record consists of a value in the primary key field.
C.
MS Access improves the database performance.
D.
MS Access ensures that each value in the primary key field is unique.
Explanation:
The various benefits of specifying a primary key for a table are as follows:
MS Access improves the database performance by automatically generating an index for the primary key.
MS Access ensures that each record consists of a value in the primary key field.
MS Access ensures that each value in the primary key field is unique.
Answer A is incorrect. Domain integrity enforces data validity by restricting the data type, valid
values (using CHECK constraints and rules), and range of possible values (using FOREIGN KEY
constraints) for columns in a table.