Answer Posted / subba reddy
A transaction is a series of SQL data manipulation
statements that does a logical unit of work. Oracle
treats the series of SQL statements as a unit so that all
the changes brought about by the statements are
either committed (made permanent) or rolled back (undone)
at the same time. If your program fails in the
middle of a transaction, the database is automatically
restored to its former state
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a rownum?
Where are sql server usernames and passwords stored in the sql server?
How can i Relate Tables in SSIS
Explain what is analysis service repository?
How to get @@error and @@rowcount at the same time?
What is nolock?
What is BCP? When does it used in sql server 2012?
What is the difference between system objects and user objects?
What is query parameter in ssrs?
What is an execution plan? When would you use it?
Why I am getting this error when dropping a database in ms sql server?
Where do you find the default Index fill factor and how to change it?
What is pessimistic concurrency?
Where views are stored in sql server?
What is transaction server auto commit?