What is a transaction and what are ACID properties?
Answer Posted / ravina
A transaction is a sequence of sql Operations(commands),
work as single atomic unit of work. To be qualify
as "Transaction" , this sequence of operations must satisfy
4 properties , which is knwon as ACID test.
A(Atomicity):-The sequence of operations must be atomic,
either all or no operations are performed.
C(Consistency):- When completed, the sequence of operations
must leave data in consistent mode. All the defined
relations/constraints must me Maintained.
I(Isolation): A Transaction must be isolated from all other
transactions. A transaction sees the data defore the
operations are performed , or after all the operations has
performed, it can't see the data in between.
D(Durability): All oprtaions must be permanently placed on
the system. Even in the event of system failure , all the
operations must be exhibit.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a view and a stored procedure?
How to provide default values to function parameters?
What is the chart in report?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What command do we use to rename a db, a table and a column?
What are different types of table joins?
What is the use of RDBMS?
what are the three command line utilities and what are their primary functions?
Explain filtered indexes benefits?
Explain an incremental backup?
How to create a user name in a database?
How can you set the threshold at which sql server will generate keysets asynchronously?
How do you implement session management in SQL Server mode?
What is the importance of concurrency control?
Explain what is the difference between a local and a global temporary table?