Transactions & ACID · SQL SQL
In PostgreSQL and MySQL, what is the default transaction isolation level?
Practice question from Transactions & ACID (SQL SQL), with the correct answer and a step-by-step solution.
medium · MCQ · Q-EB7AED
In PostgreSQL and MySQL, what is the default transaction isolation level?
- A.Read Uncommitted
- B.Read CommittedCorrect answer
- C.Repeatable Read
- D.Serializable
Solution
PostgreSQL and MySQL (InnoDB) both use Read Committed as their default isolation level, where a query sees only data committed before the query began.
More from Transactions & ACID
- Which property of ACID ensures that once a transaction has been committed, its effects are permanently recorded in the database, even in th…
- Which of the following phenomena can still occur under the 'Repeatable Read' isolation level in standard ANSI SQL, but is prevented in Post…
- What is the primary purpose of the Write-Ahead Logging (WAL) protocol in database transaction management?
- Explain the difference between a 'Dirty Read' and a 'Non-Repeatable Read' anomaly.
Practise more SQL
Sign up free for adaptive practice on this chapter, with instant feedback and hints on every question.
Start practising freeFree to start · No credit card needed