Question
Multiple transactions execute concurrently on a database, yet each transaction behaves as though it is the only one running, and is shielded from seeing another transaction's uncommitted intermediate changes (preventing dirty reads). Which ACID property does this describe?
More IT DBMS Questions
- During a fund transfer, ₹5000 is debited from Account A but the system crashes before the corresponding credit to Account B is applied. Which ACID property...
- Which SQL statement is used to remove all rows from a table without logging individual row deletions?
- Which SQL isolation level allows phantom reads but prevents dirty reads and non-repeatable reads?
- What does the acronym ACID stand for in the context of database transaction management?
- Which concurrency anomaly is specific to phantom reads?
- Which normal form in relational database design specifically eliminates transitive dependency of non-key attributes on the primary key?
- What is context switching?
- Transaction T1 reads a row twice within the same transaction. Between the two reads, T2 commits an update to that row, and T1's second read returns the new...
- Which SQL command removes all rows from a table quickly while preserving the table's structure for future use?
- Two transactions T1 and T2 both follow the Two-Phase Locking (2PL) protocol. T1 acquires an exclusive lock on row A and then requests a lock on row B, whil...
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)