ExamGecko
Question list
Search
Search

Question 49 - CITM-001 discussion

Report
Export

Which key uniquely defines the characteristics of each row?

A.

Primary Key

Answers
A.

Primary Key

B.

Foreign Key

Answers
B.

Foreign Key

C.

Secondary Key

Answers
C.

Secondary Key

D.

Imported Key

Answers
D.

Imported Key

Suggested answer: A

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 queries12.Reference:1: Primary and Foreign Key Constraints - SQL Server12: Primary and Foreign Key in SQL With Examples - DataFlair2

asked 18/11/2024
Timothy Luisterburg
32 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first