Which key establishes a logical relationship between two tables by referencing the primary key of another table? MCQ with Answer and Explanation

Which key establishes a logical relationship between two tables by referencing the primary key of another table?
A. Candidate Key
B. Foreign Key
C. Alternate Key
D. Super Key
Answer: Option B
Solution (By JKSSB Mock Tests)
A Foreign Key is an attribute or collection of attributes in one table that references the primary key of another table to maintain referential integrity.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
What does ACID stand for in database transactions?
A. All Correct Information Display
B. Accuracy, Control, Integrity, Data
C. Access, Create, Insert, Delete
D. Atomicity, Consistency, Isolation, Durability

Correct Answer: Option D


Explanation:
ACID properties ensure reliable transaction processing in DBMS.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is a candidate key?
A. A column that can be used as a primary key but is not chosen
B. A column that allows duplicate values
C. A foreign key
D. A set of columns that uniquely identifies a row and can serve as a primary key

Correct Answer: Option D


Explanation:
A candidate key is an attribute or set of attributes that can uniquely identify a tuple; one is selected as the primary key.

This question belongs to: Computer Database Management System (DBMS)
Question #3
DCL commands in SQL include:
A. GRANT and REVOKE
B. CREATE and DROP
C. INSERT and UPDATE
D. SELECT and JOIN

Correct Answer: Option A


Explanation:
Data Control Language (DCL) commands manage access permissions.

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