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 type of join returns rows when there is a match in both tables?
Distributed 2-Phase Commit (2PC) can suffer from:
An ER diagram has entities STUDENT and COURSE joined by a many-to-many relationship ENROLLS, which has the attribute Grade. What is the minimum number of r...
What will re.findall(r'\d+', 'abc123def45ghi') return?
What will be the output of the following Python code: a=[1,2,3,4,5,6] print(a[-1],a[-1:],a[:-1])
The command to test reachability of a host in Linux is:
What does the acronym ACID stand for in the context of database transaction management?
A table Orders(order_id, customer_id, order_date, amount) needs a query that returns each order alongside a running cumulative total of that customer's ord...
Which type of SQL JOIN returns all records from both tables, filling unmatched fields with NULL?
Which of the following is a weak entity in a database?

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