A candidate key is: MCQ with Answer and Explanation

A candidate key is:
A. A minimal super key
B. Always the primary key
C. A foreign key only
D. Any key with duplicates
Answer: Option A
Solution (By JKExamLibrary)
A candidate key is a minimal set of attributes that can uniquely identify a tuple.

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
Which property of ACID ensures that a transaction is treated as a single unit that either fully succeeds or fully fails?
A. Isolation
B. Durability
C. Consistency
D. Atomicity

Correct Answer: Option D


Explanation:
Atomicity ensures that all operations within a transaction are completed successfully; otherwise, the transaction is aborted and all changes are rolled back.

This question belongs to: Computer Database Management System (DBMS)
Question #2 Report Error
What is a tuple in a relational database?
A. A relationship between tables
B. The name of the table
C. A single column in a table
D. A single row in a table

Correct Answer: Option D


Explanation:
In RDBMS, a tuple represents a single row or record in a relation (table).

This question belongs to: Computer Database Management System (DBMS)
Question #3 Report Error
What is the purpose of the REVOKE command in SQL?
A. To remove user permissions
B. To create a user
C. To delete a table
D. To rollback a transaction

Correct Answer: Option A


Explanation:
REVOKE is used to take away privileges previously granted to users.

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