Difficulty: Easy
Correct Answer: Invalid statement
Explanation:
Introduction / Context:
ACID-compliant systems classify anomalies such as dirty reads, nonrepeatable reads, and phantom reads. Accurate terminology is crucial. The statement uses “filthy read” instead of the standard term “dirty read.”
Given Data / Assumptions:
Concept / Approach:
Although the definition in the sentence matches the phenomenon, the incorrect term makes the statement invalid in a correctness/terminology sense. Precision matters for exams and professional communication.
Step-by-Step Solution:
Identify the anomaly described: read of uncommitted data.Recall the standard name: “dirty read.”Compare with the given term: “filthy read” is nonstandard and incorrect.Therefore, the statement is invalid.
Verification / Alternative check:
Consult isolation level definitions: only “dirty read” appears alongside “nonrepeatable” and “phantom” in documentation and textbooks.
Why Other Options Are Wrong:
Vendor differences do not rename the anomaly; phantom reads are a different phenomenon (new rows matching a predicate appear between reads).
Common Pitfalls:
Mixing up dirty vs. nonrepeatable reads; assuming READ COMMITTED allows dirty reads (it does not).
Final Answer:
Invalid statement
Discussion & Comments