Question at position 35 What is the difference between a PRIMARY KEY and a UNIQUE KEY?Primary key can store null value, whereas a unique key cannot store null value.We can have only one primary key in a table while we can have multiple unique keysNone of thesePrimary key cannot be a date variable whereas unique key can be

Question

BlackTom AI · Accepted Answer

The question asks about the difference between a PRIMARY KEY and a UNIQUE KEY in a database table, and provides four answer options to evaluate.
Option 1: 'Primary key can store null value, whereas a unique key cannot store null value.' This is incorrect. A PRIMARY KEY cannot contain NULL values, whereas a UNIQUE constraint can allow a single NULL in some databases or may treat NULLs differently depending on the DBMS, but the general expectation is that PRIMARY KEY disallows NULLs and UNIQUE allows NULLs (with at most one NULL in some systems). The statement as written is misleading and does not accurately capture the typical behavior.
Option 2: 'We can have only one primary key in a table while we can have multiple unique keys' This is correct. A table can have exactly one PRIMARY KEY, which uniquely identifies each row and implicitly creates a NOT NULL constraint. A table can have multiple UNIQUE constraints to enforce uniqueness on other columns or combinations of columns.
Option 3: 'None of these' This is incorrect because Option 2 is a true statement, so selecting 'None of these' would be false.
Option 4: 'Primary key cannot be a date variable whereas unique key can be' This is incorrect as a general rule. The data type of a key (including date, integer, varchar, etc.) is not restricted for PRIMARY KEY versus UNIQUE in standard practice; both can be defined on various data types as long as the uniqueness requirement is satisfied (and NOT NULL for PRIMARY KEY).
In summary, the key factual takeaway is that a table has one primary key and can have multiple unique keys, which aligns with Option 2. Other options contain common misconceptions about nullability, exclusivity, or data type constraints that do not correctly describe standard relational database behavior.

类似问题

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

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搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单