Questions
Questions
Single choice

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

Options
A.Primary key cannot be a date variable whereas unique key can be
B.Primary key can store null value, whereas a unique key cannot store null value.
C.None of these
D.We can have only one primary key in a table while we can have multiple unique keys
View Explanation

View Explanation

Verified Answer
Please login to view
Step-by-Step Analysis
Question restatement: What is the difference between a PRIMARY KEY and a UNIQUE KEY? Options include a mix of factual claims, and we must assess each for accuracy before identifying the correct statement. Option 1: 'Primary key cannot be a date variable whereas unique key can be' This is misleading. A primary key can be of any data type that uniquely identifies a row (including dates......Login to view full explanation

Log in for full answers

We've collected over 50,000 authentic exam questions and detailed explanations from around the globe. Log in now and get instant access to the answers!

More Practical Tools for International Students

Join us and instantly unlock extensive past papers & exclusive solutions to get a head start on your studies!