Interested to Buy Any Domain ? << Click Here >> for more details...
What is a transaction and what are ACID properties?
- 14 Answers
- 77375 Views
- Config Systems, IBM, TCS, Virtusa, I also Faced
- E-Mail Answers
Answer Posted / archana
A transaction is an atomic unit of work that must be
completed in its entirety.The transaction succeeds if it
committed and fails if it is aborted.Transactions have four
essential properties:atomicity,consistency,isolation, and
durability(known as the ACID properties).
Atomicity:The work cannot be broken into smaller
parts.Although a transaction might contain many SQL
statements,it must be run as all-or-nothing
proposition,which means that,if a transaction is only
partially complete when an error occurs,the work revertss
to its state prior to the start of the transaction.
Consistency:A transaction must operate on a consistent view
of the data and also leave the data in a consistency
state.Any work in progress must not be visible to other
transactions until the transaction has been committed.
Isolation:A transaction should appear to be running by
itself,the effects of other ongoing transactions must be
invisible to this transaction,and the effects of this
transaction must be invisible to other ongoing transaction.
Durability:When the transaction is committed,it must be
persisted so it is not lost in the event of a power
failure.Only committed transaction are recovered during
power-up and crash recovery;uncommitted work is roll back.
| Is This Answer Correct ? | 72 Yes | 13 No |
Post New Answer View All Answers
How can you set the threshold at which sql server will generate keysets asynchronously?
Explain how does the report manager work in ssrs?
What is the importance of a recovery model?
Can sql servers linked to other servers?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is conditional split?
How to return the top 5 rows from a select query in ms sql server?
write an SQL query to list the employees who joined in the month of January?
How to create a simple table to test triggers in ms sql server?
What is the distinction amongst delete and truncate?
Define constraints and give an example of their use?
What is subquery in sql?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
How can I create a report based on a query? : sql server management studio
What are parameterized reports?
