What is ACID Property of Transaction?

Answer Posted / hari

Transcation is a sequene of operations performaed a single
logical unit of work .it must be excuted acid properties.
Atomicity : set of t-sql statements act as a batch
constitancy : ---
isolation : to reduce the concurrency
durabality : once chages are commied database permentaly
saved

Is This Answer Correct ?    14 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of replication are there in sql server 2000?

559


How to test subquery results with the exists operator?

555


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1959


SQL Server Architecture ?

1920


Define left outer join in sql server joins?

551






Is mysql the same as sql server?

503


I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

575


Explain trigger and trigger types?

552


How to modify an existing stored procedure in ms sql server?

521


How to create new tables with "create table" statements in ms sql server?

563


What is the purpose of sql profiler in sql server?

509


What are different types of roles provided by ssrs?

112


Which are new data types introduced in sql server 2008?

594


what is the maximum size of a row? : Sql server database administration

531


What is the openxml statement in sql server?

534