What is a candidate key? MCQ with Answer and Explanation

Question
What is a candidate key?
A. A column that can be used as a primary key but is not chosen
B. A column that allows duplicate values
C. A set of columns that uniquely identifies a row and can serve as a primary key
D. A foreign key
Answer: Option C
Solution (By JKSSB Mock Tests)
A candidate key is an attribute or set of attributes that can uniquely identify a tuple; one is selected as the primary key.
This question belongs to: Computer Database Management System (DBMS)
Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
In the context of databases, what is a 'tuple'?
A. A row of a table
B. A column of a table
C. A table itself
D. A key constraint
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
In relational databases, a tuple is a single row or record of a table.
This question belongs to: Computer Database Management System (DBMS)
Question #2
In an Entity-Relationship (ER) diagram, what geometric shape is used to represent an entity type?
A. Triangle
B. Ellipse
C. Diamond
D. Rectangle
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
In standard ER modeling notation, rectangles are used to represent entity sets or entity types.
This question belongs to: Computer Database Management System (DBMS)
Question #3
Which key establishes a logical relationship between two tables by referencing the primary key of another table?
A. Alternate Key
B. Super Key
C. Foreign Key
D. Candidate Key
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A Foreign Key is an attribute or collection of attributes in one table that references the primary key of another table to maintain referential integrity.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?