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 type of index physically reorders the data rows in the table itself based on the index key, meaning the data is stored in the order of the index?
- Which of the following is a common use case for a PL/SQL trigger?
- Which of the following is a key characteristic that distinguishes a PL/SQL `FUNCTION` from a PL/SQL `PROCEDURE`?
- A `BEFORE INSERT` trigger fires:
- What is the difference between DELETE, TRUNCATE, and DROP commands in SQL?
- What is the main function of a PL/SQL `TRIGGER`?
- Customers(cust_id,name): (1,'A'),(2,'B'),(3,'C'). Orders(order_id,cust_id,amount): (1,1,200),(2,2,150),(3,1,300),(4,3,100). What does the following query r...
- ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) assigns:
- When does an implicit cursor get automatically declared and managed by PL/SQL?
- What is an SQL `VIEW`?
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)