Candidate keys that are not selected or designated as the primary key of a table are known as what? MCQ with Answer and Explanation

Candidate keys that are not selected or designated as the primary key of a table are known as what?
A. Foreign Keys
B. Super Keys
C. Composite Keys
D. Alternate Keys
Answer: Option D
Solution (By JKSSB Mock Tests)
Out of all available candidate keys, the one selected to identify rows uniquely is the primary key, and the remaining unselected candidate keys are called alternate keys.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
Which normal form eliminates transitive dependencies?
A. 1NF
B. 3NF
C. 2NF
D. BCNF

Correct Answer: Option B


Explanation:
Third Normal Form (3NF) removes transitive dependencies on non-prime attributes.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is the purpose of the SQL DISTINCT keyword?
A. To sort the result set
B. To filter rows based on a condition
C. To return only unique rows in the result set
D. To group the results

Correct Answer: Option C


Explanation:
DISTINCT removes duplicate rows from the query result.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which type of relationship is represented by a foreign key in a relational database?
A. All of the above
B. One-to-one
C. Many-to-many
D. One-to-many

Correct Answer: Option A


Explanation:
Foreign keys can represent various relationships, including one-to-one, one-to-many, and many-to-many (via junction tables).

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