Database Management Systems (DBMS)
Which term refers to a column or set of columns that uniquely identifies each row in a database table?
Difficulty: Easy
About this MCQ
This Easy Database Management Systems (DBMS) MCQ checks one syllabus fact.
The question is: “Which term refers to a column or set of columns that uniquely identifies each row in a database table?”
The accepted answer is C. Primary key. Primary key is the person body or term that satisfies Which term refers to a column or set of columns that uniquely identifies each row in a database table option C Option A Denormalization does not match the stem it is a near-miss used to catch incomplete recall of Primary key Option B Database trigger does not match the stem it is a near-miss used to catch incomplete recall of Primary key Remaining alternatives Transaction deadlock fall outside the same rule and should be eliminated once Primary 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 PPSC.
- A. Denormalization
Why not A: “Denormalization” is not correct. The accepted answer is C. Primary key. Primary key is the person body or term that satisfies Which term refers to a column or set of columns that uniquely identifies each row in a database table option C Option A Denorm
- B. Database trigger
Why not B: “Database trigger” is not correct. The accepted answer is C. Primary key. Primary key is the person body or term that satisfies Which term refers to a column or set of columns that uniquely identifies each row in a database table option C Option A Denorm
- C. Primary key ✓
- D. Transaction deadlock
Why not D: “Transaction deadlock” is not correct. The accepted answer is C. Primary key. Primary key is the person body or term that satisfies Which term refers to a column or set of columns that uniquely identifies each row in a database table option C Option A Denorm
Correct answer
C. Primary key
Explanation
Primary key is the person body or term that satisfies Which term refers to a column or set of columns that uniquely identifies each row in a database table option C Option A Denormalization does not match the stem it is a near-miss used to catch incomplete recall of Primary key Option B Database trigger does not match the stem it is a near-miss used to catch incomplete recall of Primary key Remaining alternatives Transaction deadlock fall outside the same rule and should be eliminated once Primary 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 PPSC.
Source: Database Management Systems (DBMS) Official Reference Guide
Tags: computer science, dbms, SQL, databases
Submitted by: MCQsHub Editorial
Related MCQs
- What is the name for a column that creates a link between data in two tables by referencing a primary key in a...
- Which of the following best describes Foreign key?
- 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.