Database Management Systems (DBMS)
Identify the correct concept described as: the process of organizing database tables to reduce data redundancy and improve data integrity.
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: the process of organizing database tables to reduce data redundancy and improve data integrity.”
The accepted answer is B. Normalization. “Identify the correct concept described as: the process of organizing database tables to reduce data redundancy and improve data integrity.” is answered by Normalization (option B). Option A (“Transaction”) does not match the stem; it is a near-miss used to catch incomplete recall of Normalization. Option C (“Denormalization”) does not match the stem; it is a near-miss used to catch incomplete recall of Normalization. Remaining alternatives (Foreign key) fall outside the same rule and should be eliminated once Normalization 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 papers.
- A. Transaction
Why not A: “Transaction” is not correct. The accepted answer is B. Normalization. “Identify the correct concept described as: the process of organizing database tables to reduce data redundancy and improve data integrity.” is answered by Normalization (option B)
- B. Normalization ✓
- C. Denormalization
Why not C: “Denormalization” is not correct. The accepted answer is B. Normalization. “Identify the correct concept described as: the process of organizing database tables to reduce data redundancy and improve data integrity.” is answered by Normalization (option B)
- D. Foreign key
Why not D: “Foreign key” is not correct. The accepted answer is B. Normalization. “Identify the correct concept described as: the process of organizing database tables to reduce data redundancy and improve data integrity.” is answered by Normalization (option B)
Correct answer
B. Normalization
Explanation
“Identify the correct concept described as: the process of organizing database tables to reduce data redundancy and improve data integrity.” is answered by Normalization (option B). Option A (“Transaction”) does not match the stem; it is a near-miss used to catch incomplete recall of Normalization. Option C (“Denormalization”) does not match the stem; it is a near-miss used to catch incomplete recall of Normalization. Remaining alternatives (Foreign key) fall outside the same rule and should be eliminated once Normalization 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 papers.
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...
- A set of properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transacti...
- What does Primary key refer to?
- Choose the correct description of ACID properties.
- Which term refers to a column or set of columns that uniquely identifies each row in a database table?
- Which of the following best names the concept in which an SQL operation that combines rows from two or more ta...