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 SQL command is used to modify existing records in a table?
- Which SQL operator is used to search for a pattern in a column?
- In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
- In normalization, which normal form removes transitive dependencies?
- Table T has five rows and X values (10,20,NULL,20,NULL). What does SELECT COUNT(X) FROM T return?
- SQL Injection can be prevented by all EXCEPT:
- Which SQL keyword removes duplicate rows automatically from results?
- Which operator is used for pattern matching in SQL?
- A table T has exactly 10 rows. Its column X contains 3 NULL values among its 10 entries, and of the remaining 7 non-null values, exactly two are duplicates...
- Which single SQL constraint, when applied to a column, automatically enforces both uniqueness of values and a NOT NULL restriction, and is also used to uni...
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)