A candidate key is: MCQ with Answer and Explanation

Question

Share Report Error

A candidate key is:

A. Any key with duplicates

B. A foreign key only

C. A minimal super key

D. Always the primary key

Answer: Option C

Solution (By JKSSB Mock Tests)

A candidate key is a minimal set of attributes that can uniquely identify a tuple.

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

Share Report

Which normal form eliminates all transitive dependencies?

A. 2NF

B. 1NF

C. 3NF

D. BCNF

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Third Normal Form (3NF) eliminates transitive dependencies, where non-key attributes depend on other non-key attributes.

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

Question #2

Share Report

Which of the following is a characteristic of a DBMS?

A. Security and access control

B. Data independence

C. Data redundancy control

D. All of the above

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A DBMS provides features like data independence, reduced redundancy, security, and concurrent access.

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

Question #3

Share Report

What is a deadlock in a database?

A. A query error

B. A type of backup

C. A system crash

D. A situation where two or more transactions are waiting indefinitely for each other to release locks

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Deadlock occurs when each transaction holds a lock that the other needs, resulting in a circular .

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

Explore All Database Management System (DBMS) MCQs