Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sivasiva
A transaction in SQL (structured query language) is a
larger unit of database processing that contains one or
more database access operations like insertion ,deletion,
retrieval and modification operations.
These transaction are required to fulfil certain
characteristics and they are :
Atomicity: The transaction is either performed entirely or
not performed at all.
Isolation: The transaction should not be interfered by any
other transaction executing concurrently.
Durability: The changes made by the transaction should be
permanently committed in the database.
Consistency preservation: If the database was consistent
before the execution of the transaction .It should remain
consistent after the complete execution of that transaction.
There are two types of transactions: explicit and implicit
Explicit are those that need to be specified like : commit
and roll-back
Commit transaction signals that the transaction was
successfully executed and the changes/ updates (if any)
made by the transaction have been committed to the database
and these changes cannot be undone.
Roll-back signals that the transaction was not successfully
executed , and the changes/updates made by the transaction
have to be undone.
Implicit transactions are those that mark beginning and
end of the transaction, each statement like update,
delete , insert run within these implicit
transactions.,However, you can explicitly specify the
beginning and ending of the transaction by "begin
transaction" and "end transaction" statements respectively.
All the statements within these two boundaries will be
marked as one transaction.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
what purpose does the model database serve? : Sql server database administration
What is the use of toad or sqldbx.?
How can a database be repaired?
How to create and drop temp table in sql server?
What are the disadvantages of using the stored procedures?
What are the advantages of user defined function?
What is thr feature of change data capture?
What is a self join in sql server?
What is the difference between a stored procedure and a user defined function?
How to perform key word search in tables?
Ms sql server index?
How does recursive cte works in sql server?
What is deploy, process and build? : sql server analysis services, ssas
what is the primary use of the model database? : Sql server administration
