Database Management Systems (DBMS)
What term describes the following? a sequence of one or more database operations executed as a single logical unit of work.
Difficulty: Medium
About this MCQ
This Medium Database Management Systems (DBMS) MCQ checks one syllabus fact.
The question is: “What term describes the following? a sequence of one or more database operations executed as a single logical unit of work.”
The accepted answer is B. Transaction. Transaction is the fact required by “What term describes the following? a sequence of one or more database operations executed as a single logical unit of work.” (option B). Option A (“ACID properties”) does not match the stem; it is a near-miss used to catch incomplete recall of Transaction. Option C (“Candidate key”) does not match the stem; it is a near-miss used to catch incomplete recall of Transaction. Remaining alternatives (Denormalization) fall outside the same rule and should be eliminated once Transaction 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
Why not A: “ACID properties” is not correct. The accepted answer is B. Transaction. Transaction is the fact required by “What term describes the following? a sequence of one or more database operations executed as a single logical unit of work.” (option B). Option
- B. Transaction ✓
- C. Candidate key
Why not C: “Candidate key” is not correct. The accepted answer is B. Transaction. Transaction is the fact required by “What term describes the following? a sequence of one or more database operations executed as a single logical unit of work.” (option B). Option
- D. Denormalization
Why not D: “Denormalization” is not correct. The accepted answer is B. Transaction. Transaction is the fact required by “What term describes the following? a sequence of one or more database operations executed as a single logical unit of work.” (option B). Option
Correct answer
B. Transaction
Explanation
Transaction is the fact required by “What term describes the following? a sequence of one or more database operations executed as a single logical unit of work.” (option B). Option A (“ACID properties”) does not match the stem; it is a near-miss used to catch incomplete recall of Transaction. Option C (“Candidate key”) does not match the stem; it is a near-miss used to catch incomplete recall of Transaction. Remaining alternatives (Denormalization) fall outside the same rule and should be eliminated once Transaction 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
- The concept in which a database structure that improves the speed of data retrieval operations on a table is b...
- Select the correct name for: a diagram that visually represents entities and their relationships within a data...
- What is the function or purpose of SQL JOIN?
- Which statement correctly explains Entity-Relationship (ER) diagram?
- Which of the following best names the concept in which an SQL operation that combines rows from two or more ta...
- Which concept is defined as follows: the process of intentionally introducing redundancy into a database to im...