What is a foreign key in a database table? MCQ with Answer and Explanation

What is a foreign key in a database table?
A. A column that references the primary key of another table
B. A key that allows null values
C. A key used to uniquely identify records in the same table
D. A key that is always indexed
Answer: Option A
Solution (By JKExamLibrary)
A foreign key is a field in one table that links to the primary key of another table, establishing a relationship between tables.

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
What is the main advantage of using a DBMS?
A. All of the above
B. Data integrity and security
C. Reduced application development time
D. Data sharing and concurrency control

Correct Answer: Option A


Explanation:
DBMS provides numerous benefits including data sharing, concurrency control, integrity, security, and reduces development time.

This question belongs to: Computer Database Management System (DBMS)
Question #2 Report Error
Data that has been processed, organized, structured, or presented in a given context to make it useful is known as what?
A. Information
B. Raw facts
C. Database
D. Field

Correct Answer: Option A


Explanation:
Information is data that has been processed, structured, or organized in a meaningful way to provide context and utility to the user.

This question belongs to: Computer Database Management System (DBMS)
Question #3 Report Error
Which key establishes a logical relationship between two tables by referencing the primary key of another table?
A. Candidate Key
B. Alternate Key
C. Foreign Key
D. Super Key

Correct Answer: Option C


Explanation:
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.

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