Answer Posted / vishal
Atomicity means either the transaction is complete or it it will go on its previous condition
consistency :- it means that after and before the transaction process the data remains in consistent manner;
Isolation :- if two transaction process than each transaction is unaware to both of them
Durability :-means when the transaction is committed .it must be durable even the system is crash..
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is inline variable assignment?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What are the types of lock supported by ?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
Define full outer join?
What triggers long term care?
Determine when an index is appropriate?
Mention the differences between having and where clause.
What is the contrast amongst drop and truncate?
How to perform key word search in tables?
Explain multiserver query
What is raid and what are different types of raid levels?
what is normalization? Explain different levels of normalization? : Sql server database administration
What are the different types of collation sensitivity in sql server?
How can i Relate Tables in SSIS