What is a primary key?

Question

BlackTom AI · Accepted Answer

The question asks what a primary key is, so we evaluate each option in turn and contrast with the function of a primary key.
Option 1: 'A selected candidate key to uniquely identify records' This aligns with the standard definition: a primary key is chosen from the set of candidate keys and is used to uniquely identify each row in a table. The chosen key must be unique and not null, ensuring each record can be distinguished.
Option 2: 'A key used to create relationships between tables' While a primary key can be used to relate tables via foreign keys in other tables, the primary key itself is not defined by this relational role alone; its core purpose is unique identification. The relationship-building role is more about the foreign key in related tables, not the primary key definition.
Option 3: 'A key that consists of multiple attributes' This is describing a composite key, which is a type of candidate key that happens to involve multiple attributes. However, a primary key does not have to be composite; it can be a single attribute or multiple attributes. Therefore, this statement is not a complete definition and is potentially misleading if interpreted as always.
Option 4: 'A key that can contain null values' This is incorrect because a primary key must not contain null values; nulls would prevent unique identification of records. The rule of primary keys is that they are not nullable to guarantee a unique and present identifier for every row.

What is a primary key?

查看解析

登录即可查看完整答案

类似问题

A primary unique key:

What role does a primary key play in a database?

In RDBMS, what is a primary key?

What does `PRIMARY KEY` in a table ensure?

How many primary keys can a table have?

Question at position 11 In ERDs, the primary key isAn attribute that cannot be modified after it is setAn attribute that uniquely identifies each record in a database tableA graphical symbol indicating the connection between entitiesA set of optional attributes linked to an entity

A database table usually has a(n) _______________________ that uniquely identifies each row in the table.

更多留学生实用工具

考试浏览器助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单