Which of the following statements best describe the features of a primary key? Each correct answer represents a complete solution. Choose three.

The correct answer is A. It uniquely identifies each record. C. It should be simple and contain as few attributes as possible. D. It should exist when the record is created. The features of a primary key are as follows: It uniquely identifies each record. It cannot be null. It should exist when the record is created. Its value should remain stable once it is established. It should be simple and contain as few attributes as possible.

Building Tables

Question

Which of the following statements best describe the features of a primary key? Each correct answer represents a complete solution. Choose three.

Options

AIt uniquely identifies each record.
BIts value should be changed time by time.
CIt should be simple and contain as few attributes as possible.
DIt should exist when the record is created.

How the community answered

(33 responses)

A
76% (25)
B
24% (8)

Explanation

The features of a primary key are as follows: It uniquely identifies each record. It cannot be null. It should exist when the record is created. Its value should remain stable once it is established. It should be simple and contain as few attributes as possible.

Topics

#primary key#unique identifier#table design#record identification

Community Discussion

No community discussion yet for this question.

Full 77-885 Practice