Database Management Systems (DBMS)
Identify the correct concept described as: a minimal set of attributes that can uniquely identify a record in a table.
Difficulty: Medium
About this MCQ
This Medium Database Management Systems (DBMS) MCQ checks one syllabus fact.
The question is: “Identify the correct concept described as: a minimal set of attributes that can uniquely identify a record in a table.”
The accepted answer is B. Candidate key. Identify the correct concept described as a minimal set of attributes that can uniquely identify a record in a table is answered by Candidate key option B Option A SQL JOIN does not match the stem it is a near-miss used to catch incomplete recall of Candidate key Option C Database view does not match the stem it is a near-miss used to catch incomplete recall of Candidate key Remaining alternatives ACID properties fall outside the same rule and should be eliminated once Candidate 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 NTS and CSS.
- A. SQL JOIN
Why not A: “SQL JOIN” is not correct. The accepted answer is B. Candidate key. Identify the correct concept described as a minimal set of attributes that can uniquely identify a record in a table is answered by Candidate key option B Option A SQL JOIN does no
- B. Candidate key ✓
- C. Database view
Why not C: “Database view” is not correct. The accepted answer is B. Candidate key. Identify the correct concept described as a minimal set of attributes that can uniquely identify a record in a table is answered by Candidate key option B Option A SQL JOIN does no
- D. ACID properties
Why not D: “ACID properties” is not correct. The accepted answer is B. Candidate key. Identify the correct concept described as a minimal set of attributes that can uniquely identify a record in a table is answered by Candidate key option B Option A SQL JOIN does no
Correct answer
B. Candidate key
Explanation
Identify the correct concept described as a minimal set of attributes that can uniquely identify a record in a table is answered by Candidate key option B Option A SQL JOIN does not match the stem it is a near-miss used to catch incomplete recall of Candidate key Option C Database view does not match the stem it is a near-miss used to catch incomplete recall of Candidate key Remaining alternatives ACID properties fall outside the same rule and should be eliminated once Candidate 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 NTS and CSS.
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 situation in which two transactions are each waiting for the other to release a lock, p...
- What does Database view refer to?
- Which term refers to a virtual table based on the result of a stored SQL query?
- Select the accurate description of Database trigger.
- The following statement describes a specific concept. What is it called? a stored procedure that automatically...
- What is Denormalization primarily used for?