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.

The correct answer is 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. 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 MS Access ensures that each record consists of a value in the primary key field. MS Access ensures that each…

Building Tables

Question

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.

Options

AMS Access restricts the data type, valid values, and range of possible values for columns in a
BMS Access ensures that each record consists of a value in the primary key field.
CMS Access improves the database performance.
DMS Access ensures that each value in the primary key field is unique.

How the community answered

(44 responses)

A
18% (8)
B
82% (36)

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 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.

Topics

#primary key#data integrity#database performance#field uniqueness

Community Discussion

No community discussion yet for this question.

Full 77-885 Practice