Database Management Systems (DBMS)
What is the name for a column that creates a link between data in two tables by referencing a primary key in another table?
Difficulty: Medium
About this MCQ
This Medium Database Management Systems (DBMS) MCQ checks one syllabus fact.
The question is: “What is the name for a column that creates a link between data in two tables by referencing a primary key in another table?”
The accepted answer is A. Foreign key. Foreign key is the fact required by What is the name for a column that creates a link between data in two tables by referencing a primary key in another table option A Option B Candidate key does not match the stem it is a near-miss used to catch incomplete recall of Foreign key Option C Normalization does not match the stem it is a near-miss used to catch incomplete recall of Foreign key Remaining alternatives Transaction fall outside the same rule and should be eliminated once Foreign key is identified Database Management Systems DBMS questions of this type reward precise definitions rather than approximate associations Database Management Systems DBMS recall of this distinction is a regular item in FPSC.
- A. Foreign key ✓
- B. Candidate key
Why not B: “Candidate key” is not correct. The accepted answer is A. Foreign key. Foreign key is the fact required by What is the name for a column that creates a link between data in two tables by referencing a primary key in another table option A Option B Can
- C. Normalization
Why not C: “Normalization” is not correct. The accepted answer is A. Foreign key. Foreign key is the fact required by What is the name for a column that creates a link between data in two tables by referencing a primary key in another table option A Option B Can
- D. Transaction
Why not D: “Transaction” is not correct. The accepted answer is A. Foreign key. Foreign key is the fact required by What is the name for a column that creates a link between data in two tables by referencing a primary key in another table option A Option B Can
Correct answer
A. Foreign key
Explanation
Foreign key is the fact required by What is the name for a column that creates a link between data in two tables by referencing a primary key in another table option A Option B Candidate key does not match the stem it is a near-miss used to catch incomplete recall of Foreign key Option C Normalization does not match the stem it is a near-miss used to catch incomplete recall of Foreign key Remaining alternatives Transaction fall outside the same rule and should be eliminated once Foreign key is identified Database Management Systems DBMS questions of this type reward precise definitions rather than approximate associations Database Management Systems DBMS recall of this distinction is a regular item in FPSC.
Source: Database Management Systems (DBMS) Official Reference Guide
Tags: computer science, dbms, SQL, databases
Submitted by: MCQsHub Editorial
Related MCQs
- Which term refers to a column or set of columns that uniquely identifies each row in a database table?
- Identify the correct concept described as: the process of organizing database tables to reduce data redundancy...
- Normalization is best defined as which of the following?
- A set of properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transacti...
- Choose the correct description of ACID properties.
- Which of the following best names the concept in which an SQL operation that combines rows from two or more ta...