What is the ACID Properties in the Database System? ACID Properties in Database System (Atomicity, Consistency, Isolation, Durability) What is a Phantom read? A phantom read occurs when, in the course of a transaction, two identical queries are executed, and the collection of rows returned by the second query is different from the first. This … Continue reading SQL Server: Database Lock, Deadlock, Block and Isolation Interview Questions and Answers (Day-1)