Which key uniquely defines the characteristics of each row?

The correct answer is A. Primary Key. A primary key is a column or combination of columns that contain values that uniquely identify each row in the table. It enforces the entity integrity of the table and prevents the insertion of duplicate rows. A table can have only one primary key, which is usually defined on…

IT Operations and Infrastructure Management

Question

Options

APrimary Key
BForeign Key
CSecondary Key
DImported Key

How the community answered

(20 responses)

A
90% (18)
B
5% (1)
D
5% (1)

Explanation

A primary key is a column or combination of columns that contain values that uniquely identify each row in the table. It enforces the entity integrity of the table and prevents the insertion of duplicate rows. A table can have only one primary key, which is usually defined on an identity column or a column with not null and unique constraints. A primary key also creates a unique index for the table, which allows fast access to data when the primary key is used in queries.

Topics

#primary key#relational database#row uniqueness

Community Discussion

No community discussion yet for this question.

Full CITM-001 Practice