SQL Server Database Administrator Question:
Download Questions PDF

What is a transaction and what are ACID properties?

Answer:

A transaction is a logical unit of work in which, all the steps must be performed or none. ACID stands for Atomicity, Consistency, Isolation, Durability. These are the properties of a transaction.

Download SQL Server DB Administrator Interview Questions And Answers PDF

Previous QuestionNext Question
What type of Index will get created after executing the above statement?What is normalization? Explain different levels of normalization?