What is transaction ? Give me one example.
Answer Posted / nirmala.s
transaction is series of actions that should happen without
any fail.
if the transaction consists of 3 actions , if anyone of
these fails, then whole transaction wil be rolled back.
like,
banking: we used to say it as a transaction.
logging in, transfer fund and logging out.
if any one of these fails ,
the transaction will not be completed.
Is This Answer Correct ? | 44 Yes | 9 No |
Post New Answer View All Answers
Is port 1433 secure?
How to create a view using data from another view?
What is the difference between a primary key and a unique key? Are they the same?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
How will you optimize a stored procedure optimization?
What is db stored procedure?
How to make a remote connection in a database?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is index in an assignment?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What are database states in ms sql server?
Do you know spatial data types - geometry and geography in sql server 2008?
How can we rewrite sub-queries into simple select statements or with joins?
What is the difference between insensitive and scroll cursor?
Tell me what is the difference between locking and multi-versioning?