Explain ACID rule of thumb for transactions.
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / dfdfdfsfsdds
A - Alter Table
C - Create Table
I - Insert a Row
D - Delete a Row
| Is This Answer Correct ? | 1 Yes | 14 No |
Why to use lock statement in c#?
What is a long in c#?
how to store the value in textbox using delegates if we have two user control. the value will be called from one user control to another user control. Loading and unloading will be done through delegates.
What is the difference between static and private constructor in c#?
Hello! How to do this: "Create manifest utility intended for creating update content files. Application should take a set of files as input parameter and generate XML based manifest file as output one." I use C# and vs.net 2003. It's urgent! Help please, thanks. Mayana
What is binary search tree in data structure?
Where does the dispose method lie and how can it be used to clean up resources?
What is xml document how do you open it?
what is namespace?
Can interface have virtual methods in c#?
Explain streamreader/streamwriter class?
What is the implicit name of the parameter that gets passed into the set method/property of a class?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)