Interested to Buy Any Domain ? << Click Here >> for more details...
wt is mean by acid property? i know it is
atomocity,consistency,isolation and durabulaty but wt is
these mean and wt actions it's perform
- 1 Answers
- 8834 Views
- Idea, I also Faced
- E-Mail Answers
Answer Posted / praveen
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 ? | 4 Yes | 1 No |
Post New Answer View All Answers
How many partitions a clustered index has by default in sql server 2012?
what is sql server? : Sql server database administration
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What happens when transaction log is full?
What is the optimization being performed in oracle and SQL Server?
Tell about MOM Tool(Microsoft Operator Manager)?
Can we use trigger new in before insert?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How many types of objects are there?
What is index, cluster index and nonclustered index?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
Difference between 2NF &3NF ?
Is sql server 2016 free?
How to configure odbc dsn with different port numbers?
What are the types of stored procedures in an sql server?
