Question at position 39 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 39: 'One solution for a table without any candidate keys is to create an auto-increment attribute. True/False'

Option 1: True. This statement is correct because when a table has no candidate keys to serve as a natural primary key, a surrogate key can be introduced. An auto-increment (or identity) attribute provides a unique, system-generated value for each row, effectively serving as a primary key and enabling reliable row identification, foreign key references, and efficient joins.

Option 2: False. This would be incorrect because it overlooks a common and practical approach in database design. Auto-increment surrogate keys are widely used precisely to establish a unique identifier when no suitable natural candidate key exists. While not the only possible solution, it is a valid and standard one, making the statement false only if we misinterpret the utility of surrogate keys.

Additional clarification: Even if a table lacks candidate keys, you are not prohibited from creating a new key; you can also introduce a composite key, or a surrogate key like an auto-increment column, or alter constraints to designate a primary key. The core idea is that a unique, non-null identifier is feasible and often desirable for rows, which auto-increment attributes provide.

In summary, the statement 'True' aligns with common database design practices for handling tables without candidate keys by adding an auto-increment surrogate key.

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

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单