What is ACID Property of Transaction?

Answer Posted / sandeep kumar

Transaction is a one or more database operation that is
execute logical unit of work
Acid properties
A-Atomacity
C-Consistancy
I-Isolation
D-Durability

Is This Answer Correct ?    7 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

801


How do we synchronize On-Premise SQL server with SQL Azure?

114


What is the architecture of ms sql reporting service?

704


Explain what is the use of custom fields in report?

689


How to delete existing rows in a table?

767






Explain the creation and execution of a user-defined function in the sql server?

781


Write a SQL command to insert and update only a particular field?

803


What does the update command do?

786


What are different types of raid levels?

747


Difference between connected and disconnected database in .net with sql server?

772


What are the kinds of subquery?

710


What stored by the msdb? : sql server database administration

749


What are the steps you can take to avoid “deadlocks”?

682


What do you understand by sql server agent?

686


List out some of the requirements to set up a sql server failover cluster?

753