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
- Which query returns departments whose average salary is greater than 60000?
- Consider two tables: Employees(EmpID, Name, DeptID) with 8 rows, and Departments(DeptID, DeptName) with 3 rows. Every employee has exactly one valid DeptID...
- Which SQL clause is used for filtering rows?
- 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 SQL clause is used to filter results after a GROUP BY operation?
- Which SQL keyword prevents duplicate rows in result?
- Which SQL aggregate function returns the total number of rows matching a specified condition?
- Transaction T1 runs 'SELECT COUNT(*) FROM Orders WHERE Amount > 1000' twice within the same transaction. Between the two reads, T2 inserts a new qualifying...
- For the table Employees(EmpID, Name, Dept, Salary), which SQL query correctly retrieves all employees who earn more than the average salary of their own de...
- A 'view' in SQL is best described as:
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)