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
Is BCNF better than 2NF & 3NF? Why?
Should you normalize audio?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What are triggers in ms sql server?
What is store procedure? How do they work?
Can you pass expressions to stored procedure parameters?
How do I find the size of a sql server database?
where the connection string store in the database
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
What is 1nf 2nf?
What is read committed?
How can I track the changes or identify the latest insert-update-delete from a table?
Can you please explain the difference between function and stored procedure?
How to get the definition of a view out of the sql server?
How to create sub reports?