adspace


Explain atomicity?

Answer Posted / Sukh Beer Singh

In SQL Server, atomicity refers to the property of a database transaction ensuring that the entire transaction completes successfully or fails as a whole. This means that if one operation within the transaction fails, all prior operations are rolled back, ensuring data integrity.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of subquery?

1240


How to convert character strings into numeric values?

1196


what is the difference between openrowset and openquery?

1208


What are wait types?

1262


What is the primary use of the model database?

1156


What kind of problems occurs if we do not implement proper locking strategy?

1508


How to connect php with different port numbers?

1197


What are the different SQL Server Versions you have worked on?

1084


How efficient you are in oracle and SQL server?

1269


Can you index views?

958


How can we solve concurrency problems?

1130


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1303


What is in place upgrade in sql server?

1137


what is the Ticketing tool used in Wipro technologies at Bangalore...???

8239


What is self contained sub query?

1148