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

Question

BlackTom AI · Accepted Answer

The question asks whether introducing an auto-increment attribute can be a solution for a table that lacks any candidate keys.
Option 1: True. In relational design, a table with no natural or candidate keys can still be uniquely identified by an artificial or surrogate key. Auto-increment columns are a common way to create such a surrogate primary key, ensuring every row has a unique identifier independent of the existing data values. This approach is widely used to establish a stable primary key when meaningful candidate keys are absent.
Option 2: False. This would assert that you cannot use or should not use an auto-increment attribute to solve the problem of lacking candidate keys. However, the practical and conventional solution in many database systems is to add a surrogate key (often auto-incrementing) to guarantee uniqueness and enable reliable row identification, which directly addresses the issue described in the question.
Additional nuance: While auto-increment keys are convenient and effective for uniqueness, they are not a substitute for identifying valid candidate keys for business meaning. They serve as a technical identifier, while the choice of candidate keys remains important for data integrity and natural-key design. Nevertheless, given the scenario of no candidate keys, introducing an auto-increment attribute is a valid and accepted solution.
In summary, recognizing the goal of ensuring each row is uniquely identifiable, option True aligns with common database design practices, whereas option False contradicts the practical method used in many schemas.

Question at position 50 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 40 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搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单