Question
Transaction T1 runs 'SELECT COUNT(*) FROM Orders WHERE Amount > 1000' twice within the same transaction. Between the two reads, T2 inserts a new qualifying row and commits. T1's second count is higher than the first. What phenomenon is this, and which isolation level is specifically required to fully prevent it?
More SQL Questions
- What is the difference between DELETE, TRUNCATE, and DROP commands in SQL?
- Table Employee(EmpID, ManagerID) has 6 rows: (1,NULL), (2,1), (3,1), (4,2), (5,2), (6,3). How many rows will the following self-join return? SELECT E.EmpI...
- Which clause is used to sort query results in SQL?
- Which SQL keyword prevents duplicate rows in result?
- Materialized views differ from normal views because:
- SQL Injection can be prevented by all EXCEPT:
- Which query returns departments whose average salary is greater than 60000?
- A table emp has salaries 50, 70, 70, 90, 90. What does the following query return? SELECT MAX(salary) FROM emp WHERE salary < (SELECT MAX(salary) FROM...
- In SQL, what is the primary purpose of the GROUP BY clause?
- A view is defined as: CREATE VIEW V AS SELECT dept_id, AVG(salary) AS avg_sal FROM Employees GROUP BY dept_id; Can this view be used directly in an UPDATE ...
Hey! Ask a query
Please enter email id
The email must be a valid email address.
Please enter Mobile Number
Please enter valid Mobile Number
Please enter your Doubt
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)