Database Management Systems (DBMS)
A set of properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transactions. What is this concept called?
Difficulty: Hard
About this MCQ
This Hard Database Management Systems (DBMS) MCQ checks one syllabus fact.
The question is: “A set of properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transactions. What is this concept called?”
The accepted answer is A. ACID properties. “A set of properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transactions. What is this concept called” is answered by ACID properties (option A). Option B (“SQL JOIN”) does not match the stem; it is a near-miss used to catch incomplete recall of ACID properties. Option C (“Database trigger”) does not match the stem; it is a near-miss used to catch incomplete recall of ACID properties. Remaining alternatives (Transaction) fall outside the same rule and should be eliminated once ACID properties 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. ACID properties ✓
- B. SQL JOIN
Why not B: “SQL JOIN” is not correct. The accepted answer is A. ACID properties. “A set of properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transactions. What is this concept called” is answered by ACID properties (opt
- C. Database trigger
Why not C: “Database trigger” is not correct. The accepted answer is A. ACID properties. “A set of properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transactions. What is this concept called” is answered by ACID properties (opt
- D. Transaction
Why not D: “Transaction” is not correct. The accepted answer is A. ACID properties. “A set of properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transactions. What is this concept called” is answered by ACID properties (opt
Correct answer
A. ACID properties
Explanation
“A set of properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transactions. What is this concept called” is answered by ACID properties (option A). Option B (“SQL JOIN”) does not match the stem; it is a near-miss used to catch incomplete recall of ACID properties. Option C (“Database trigger”) does not match the stem; it is a near-miss used to catch incomplete recall of ACID properties. Remaining alternatives (Transaction) fall outside the same rule and should be eliminated once ACID properties 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
- Identify the correct concept described as: the process of organizing database tables to reduce data redundancy...
- Which of the following best names the concept in which an SQL operation that combines rows from two or more ta...
- Which of the following best describes Foreign key?
- What is the function or purpose of SQL JOIN?
- What is the name for a column that creates a link between data in two tables by referencing a primary key in a...
- The concept in which a database structure that improves the speed of data retrieval operations on a table is b...