What is a candidate key in a relation? MCQ with Answer and Explanation

Question

Share Report Error

What is a candidate key in a relation?

A. A super key that is minimal

B. A key that is not unique

C. A foreign key

D. Any column that can be used as a primary key

Answer: Option A

Solution (By JKExamLibrary)

A candidate key is a minimal super key, meaning no subset of it can uniquely identify a row.

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

What is the difference between a database and a database management system?

A. A database is the data; DBMS is the software that manages it

B. Database is a file; DBMS is a table

C. They are the same

D. DBMS is the data; database is the software

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A database is a collection of structured data, while a DBMS is the software used to interact with and manage that data.

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

Question #2

Which of the following commands is a part of Transaction Control Language (TCL) in SQL?

A. ALTER

B. COMMIT

C. GRANT

D. DELETE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
COMMIT is a TCL command used to permanently save all modifications made during the current transaction into the database.

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

Question #3

Which SQL operator is used to check if a value is within a range?

A. EXISTS

B. LIKE

C. BETWEEN

D. IN

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
BETWEEN checks if a value falls within a specified range (inclusive of boundaries).

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

Explore All Database Management System (DBMS) MCQs