What type of key uniquely identifies each record in a table and cannot contain NULL values? MCQ with Answer and Explanation

What type of key uniquely identifies each record in a table and cannot contain NULL values?
A. Candidate Key
B. Primary Key
C. Foreign Key
D. Secondary Key
Answer: Option B
Solution (By JKExamLibrary)
A Primary Key is a unique identifier for each tuple in a relation. It enforces entity integrity and strictly cannot accept NULL values.

This question belongs to: Computer Database Management System (DBMS)

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1 Report Error
What is an alternate key?
A. The primary key
B. A candidate key that is not chosen as the primary key
C. A super key with extra attributes
D. A foreign key

Correct Answer: Option B


Explanation:
An alternate key is any candidate key that is not the primary key.

This question belongs to: Computer Database Management System (DBMS)
Question #2 Report Error
In the context of databases, what is a 'tuple'?
A. A row of a table
B. A key constraint
C. A column of a table
D. A table itself

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 #3 Report Error
What is an attribute called when it can hold more than one value for a single entity instance, such as multiple phone numbers for a person?
A. Composite Attribute
B. Derived Attribute
C. Multi-valued Attribute
D. Complex Attribute

Correct Answer: Option C


Explanation:
A Multi-valued Attribute is an attribute that can store multiple distinct values for a single entity instance (e.g., skill_set, phone_numbers).

This question belongs to: Computer Database Management System (DBMS)