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
Answer / 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 |
How do I create an extended event in sql server?
What are various ways to enhance the ssrs report?
How to write a query with a left outer join in ms sql server?
What is an indexing strategy?
Different Types of Functions ?
How can we write or define DDL statements in Sql server and DML statements?
How do I determine how many instances of sql server are installed on a computer?
How many tables can be joined in SQL Server?
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?
How many types of the database links?
Why is DML provided?
1 Answers Ernst Young, Thomson Reuters,
Give main differences between "Truncate" and "Delete".