Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 14 Answers
- 78024 Views
- Config Systems, IBM, TCS, Virtusa, I also Faced
- E-Mail Answers
Answer Posted / sonu
A transaction is a sequence of sql Operations,
work as single atomic unit of work. To be qualify
as a "Transaction" , this sequence of operations must satisfy 4 properties , which is knwon as ACID test.any database must follow these acid properties.
Atomicity:-The sequence of operations must be atomic,
either all or no operations are performed.
Consistency:- When completed, the sequence of operations
must leave data in consistent mode. All the defined
relations/constraints must me Maintained.
Isolation: A Transaction must be isolated from all other
transactions. A transaction sees the data before the
operations are performed , or after all the operations has
performed, it can't see the data in between.
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 ? | 7 Yes | 10 No |
Post New Answer View All Answers
What is the sql profiler?
How to drop an existing table with "drop table" statements in ms sql server?
Explain the properties of subqueries in sql server?
What is executereader?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What are the types of processing and explain each? : sql server analysis services, ssas
Using the customer, and order table in northwind database, please write a query to produce xml?
Define outer join in sql server joins?
Describe in brief databases and sql server databases architecture.
How to Insert multiple rows with a single insert statement?
What are the new features of sql server 2008 r2 reporting service?
What is 5nf in normalization form?
What is the full form of dql?
what purpose does the model database serve? : Sql server database administration
