Explain ACID rule of thumb for transactions.

Question Posted / guest

3 Answers
8038 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Explain ACID rule of thumb for transactions...

Answer / guest

Transaction must be Atomic (it is one unit of work and does
not dependent on previous and following transactions),
Consistent (data is either committed or roll back, no
?in-between? case where something has been updated and
something hasn?t), Isolated (no transaction sees the
intermediate results of the current transaction), Durable
(the values persist if the data had been committed even if
the system crashes right after).

Is This Answer Correct ?

9 Yes

0 No

Explain ACID rule of thumb for transactions...

Answer / vishalakshi patil

Atomicity- Each transaction is said to be atomic if when
one part of the transaction fails, the entire transaction
fails and database state is left unchanged.

Consistency-transaction will take the database from one
consistent state to another consistent state.

Isolation-Isolation refers to the requirement that other
operations cannot access or see data that has been modified
during a transaction that has not yet completed

Durability-Durability is the DBMS's guarantee that once the
user has been notified of a transaction's success, the
transaction will not be lost.

Is This Answer Correct ?

4 Yes

0 No

Explain ACID rule of thumb for transactions...

Answer / dfdfdfsfsdds

A - Alter Table

C - Create Table

I - Insert a Row

D - Delete a Row

Is This Answer Correct ?

1 Yes

14 No

Post New Answer

More C Sharp Interview Questions

How do you specify a custom attribute for the entire assembly (rather than for a class)?

0 Answers

Can we overload indexer in c#?

0 Answers

Hello Friends..am Mohammed riyash..final year BCA in Jamal Mohamed College 2009. Trichy. My doubt is while connecting SQL2005 Built in Database withing the Visual Studio 2005 Framework.. I am getting the error.. That " An Error occurred and it may be due to , under the default settings of the Server, the connection cannot be established.." But the code works in MS Access for me.. Both in VB.Net and C#.Net am getting the same error.. Any genius please Message me to 9994558822 or mail me.. riyash.ips@gmail.com

3 Answers

What is the example of predicate?

0 Answers

What is difference between value and reference types?

5 Answers Accenture,

What is datagridview in c#?

0 Answers

Explain metadata in c#.

0 Answers

Is as operator in c#?

0 Answers

which access modifier we can declare the abstract class?