SQL Server Database Administrator Question:
Download Questions PDF

What is a transaction and what are ACID properties?

SQL Server DB Administrator Interview Question
SQL Server DB Administrator Interview Question

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?