Question
What is SavePoint? Give an example.
Answers
A savepoint marks a point that the current transaction can roll back to. Instead of rolling all of its changes back, it can choose to roll back only some of them. For example, suppose you

start a transaction.
insert 10 rows into a table.
set a savepoint.
insert another 5 rows.
rollback to the savepoint.
commit the transaction.

After doing this, the table will contain the first 10 rows you inserted. The other 5 rows will have been deleted by the rollback. A savepoint is just a marker that the current transaction can roll back to.   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q Is Silverlight supported by all major browsers?
  • Q Comment on the appropriateness of demands for new states?
  • Q Danakill tribe Ethiopia - mans grave 1 stone for each what he did
  • Q three clocks where set to true time .First run with the exact time ..second slows one minute/day. third gains one minute/day. after how many days they will show true time.
  • Q Who is your favourite architect?
  • Q What will be the output of the below code: def foo (i= []): i.append (1) return i >>> foo () >>> foo ()
  • Q What is a male camel called
  • Q What is the most convenient hashing method to be used to hash passwords?
  • Q Which Committee recommended for the inclusion of Fundamental Duties in Indian Constitution:
  • Q When did you graduate from school/college?
  • Q The fish eating bulldog is what type of creature