At which isolation level can 'phantom reads' occur — where a transaction re-runs a query and finds new rows inserted by another committed transaction?
Analyze — Tests ability to break down and examine complex problems.
Answer Options
Want to see the correct answer?
Get the answer with a detailed explanation, plus practice 15+ more RDBMS & SQL questions with adaptive quizzes and timed interviews.
See the Answer on Guru Sishya →This question is from the RDBMS & SQL topic (Databases).
More RDBMS & SQL Questions
Which JOIN type returns all rows from the left table and matched rows from the right table, filling NULLs where there is no match?
EasyWhat is the difference between RANK() and DENSE_RANK() window functions when there are ties?
Medium-EasyWhat type of index should you use for a column that is only ever queried with exact equality checks (e.g., WHERE user_id = 42)?
Medium-EasyWhich ACID property guarantees that a committed transaction's data survives a system crash?
EasyA table has columns: order_id (PK), customer_id, customer_name, product_id, product_name, quantity. Which normal form violation does this represent?
Medium