Question

Which SQL isolation level allows phantom reads but prevents dirty reads and non-repeatable reads?

Q: Answer-Which SQL isolation level allows phantom reads but prevents dirty reads and non-repeatable reads?

Read Committed prevents dirty reads only committed data read but allows non-repeatable reads and phantoms Repeatable Read prevents non-repeatables but can allow phantoms in some systems.

A Read Uncommitted

B Read Committed

C Repeatable Read

D Serializable

E Snapshot Isolation

Practice Next

More IT DBMS Questions

What will re.findall(r'\d+', 'abc123def45ghi') return?
Which of the following operators is used to compare a value to a list of literal values that have been specified?
Which type of join returns all rows from the left table and matching rows from the right table?
Which normal form removes partial dependency?
Which SQL command is used to retrieve data from a table?
Which of these ensures referential integrity?
An SQL `VIEW` is a:
Which of the following is not part of the process control block (PCB)?
Distributed 2-Phase Commit (2PC) can suffer from:
Bitmap indexes are most efficient when:

Hey! Ask a query

Which SQL isolation level allows phantom reads but prevents dirty reads and non-repeatable reads?

Detailed Solution

More IT DBMS Questions

Hey! Ask a query

Please Register/Login