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 |
Explain about multithreading?
What is a cs file?
What is the different types of private assembly and shared assembly?
What is the default value of date?
Why do I get a security exception when I try to run my c# app?
What?s a satellite assembly?
Why do we need properties in c#?
What is the difference between firstordefault and singleordefault?
What is the full form of GAC? Explain its uses?
Assembly Code. in Rejester AL. How do Contast Replece( or Change): Bit D3 With Bit D4 and Bit D2 With Bit D5 and Bit D1 With Bit D6 and Bit D0 With Bit D7 I am Not Know Very Well Write English.
How Global.asax is used ?
hi , how could i analyse a text the user added on a site to look for some words like "car" "shouffere" .. and then i can use that information in addition to other information to make a decision about the adds im going to to show on the site.