What is an alternate key? MCQ with Answer and Explanation

What is an alternate key?
A. A foreign key
B. The primary key
C. A super key with extra attributes
D. A candidate key that is not chosen as the primary key
Answer: Option D
Solution (By JKExamLibrary)
An alternate key is any candidate key that is not the primary key.

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 of the following is true about a surrogate key?
A. It is a natural key derived from the data
B. It is an artificial key, usually an auto-increment integer, with no business meaning
C. It is a composite key
D. It is a foreign key

Correct Answer: Option B


Explanation:
A surrogate key is a system-generated unique identifier, typically numeric, that has no business significance.

This question belongs to: Computer Database Management System (DBMS)
Question #2 Report Error
What is a data dictionary in a DBMS?
A. A table containing user data
B. A log file
C. A repository of metadata about the database
D. A backup of the database

Correct Answer: Option C


Explanation:
The data dictionary stores metadata such as table definitions, column types, constraints, and other database objects.

This question belongs to: Computer Database Management System (DBMS)
Question #3 Report Error
An attribute whose value is computed dynamically from another attribute (such as calculating Age from Date_of_Birth) is called a what?
A. Derived Attribute
B. Base Attribute
C. Multi-valued Attribute
D. Stored Attribute

Correct Answer: Option A


Explanation:
A Derived Attribute is an attribute whose values are not stored physically in the database but are calculated at runtime from other stored attributes.

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