Which of the following are the benefits of specifying a primary key for a table in Microsoft Office Access 2010?

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.

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *