Question at position 40 One solution for a table without any candidate keys is to create an auto-increment attribute.TrueFalse

Question

BlackTom AI · Accepted Answer

Question at position 40: 'One solution for a table without any candidate keys is to create an auto-increment attribute. True/False'

Option 1: True. Creating an auto-increment attribute introduces a surrogate key, which is a separate internal identifier that guarantees uniqueness for each row even when there is no natural (candidate) key defined. In databases, surrogate keys like an auto-incremented integer are a common pragmatic solution to ensure a stable, unique primary key when no candidate key is available or when existing columns do not uniquely identify rows. This approach avoids relying on potentially mutable or composite natural keys and supports reliable joins and referential integrity.

Option 2: False. This would imply that an auto-increment attribute cannot be used when there are no candidate keys. In reality, the absence of candidate keys does not preclude using an auto-increment surrogate key; surrogate keys are specifically designed for this scenario. While there are caveats—such as potential overuse of surrogate keys, concerns about meaning-less identifiers, or portability considerations across systems—the statement that you cannot use an auto-increment when no candidate keys exist is inaccurate.

Summary of the contrast: The core idea is that when a table lacks a natural key, introducing a surrogate key via auto-increment is a widely accepted strategy to achieve a unique, stable identifier for each row. The alternative view in option two rests on the incorrect assumption that auto-increment cannot serve in the absence of candidate keys, which misinterprets the role of surrogate keys in relational design.

Question at position 40 One solution for a table without any candidate keys is to create an auto-increment attribute.TrueFalse

查看解析

登录即可查看完整答案

类似问题

Which of the following is NOT true about Candidate keys?

Question at position 50 One solution for a table without any candidate keys is to create an auto-increment attribute.TrueFalse

Question at position 39 One solution for a table without any candidate keys is to create an auto-increment attribute.TrueFalse

Which key helps enforce identity and integrity in a table?

更多留学生实用工具

考试浏览器助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单