Question

Which transaction isolation level permits non-repeatable reads and phantom reads while still guaranteeing that dirty reads never occur?

Q: Answer-Which transaction isolation level permits non-repeatable reads and phantom reads while still guarant...

Read Committed guarantees a transaction only ever reads data that has been committed no dirty reads, but because each statement re-reads current committed data, a value read twice within the same transaction can change non-repeatable read and new rows matching a querys predicate can appear phantom read between reads.

A Read Uncommitted — permits dirty, non-repeatable, and phantom reads

B Read Committed — prevents dirty reads but still allows non-repeatable and phantom reads

C Repeatable Read — prevents dirty and non-repeatable reads but may still allow phantom reads

D Serializable — prevents dirty reads, non-repeatable reads, and phantom reads entirely

E Snapshot Isolation — prevents all three anomalies using multi-version concurrency control

Practice Next

More IT DBMS Questions

Which normal form eliminates transitive dependency?
A transaction T1 updates a row and then waits for a lock held by T2. T2 is waiting for a lock held by T1. What condition has occurred?
Consider the following Java code snippet public class Car { private String model; private int year; public Car(String model, int year) {...
What is 'query optimization' in DBMS?
Which of the following is a significant disadvantage of using a traditional file system compared to an RDBMS?
What is the primary purpose of a "Trigger" in a database?
What is context switching?
Given a relation R(A, B, C, D, E) and functional dependencies {A -> B, BC -> D, D -> E}. Which of the following is a candidate key for R?
In a database with a foreign key constraint defined using "ON DELETE CASCADE," what happens when a row in the parent (referenced) table is deleted?
Distributed transactions typically use which protocol for atomicity?

Hey! Ask a query

🎓

Think You're Ready for RBI Grade B?

RBI Grade B 2026 Phase 1 Memory Based Paper

200 Questions with Detailed Solutions
Section-wise Coverage (GA, English, Quant & Reasoning)

Download Now 100% Free PDF

Which transaction isolation level permits non-repeatable reads and phantom reads while still guaranteeing that dirty reads never occur?

Detailed Solution

More IT DBMS Questions

Hey! Ask a query

Please Register/Login

RBI Grade B 2026 Phase 1 Memory Based Paper