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
Can We Use Data-grids For Our Report In Ssrs?
Can group by be used without aggregate functions?
What is model database? : SQL Server Architecture
What is difference between inner join and full join?
What is the downside of using udf?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
What is built-in/administrator?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is DCL?
What is sql server replication? : sql server replication
Do you know what is a trace frag? Where do we use it?
What is cursors? And what are the different types of cursor?
What is transaction server auto commit?
Can you explain important index characteristics?
What are the different types of collation sensitivity?