Explain hownested transactions can be implemented using savepoints and procedure calls. Assume that the children of each subtransaction do not run concurrently.
What will be an ideal response?
A savepoint is declared immediately prior to calling a procedure, and its Id is passed
as an argument to the procedure. To abort, the procedure rolls back to that savepoint.
The only rollbacks to that savepoint are in the procedure’s body. After executing the
rollback the procedure returns, with a failure indication as an out argument.
You might also like to view...
Which of the following statements is false?
a. Primitive types are keywords. b. Primitive types must appear in all lowercase letters. c. Real numbers contain decimal points. d. Variable name identifiers must begin with a lowercase letter.
Choose the correct XML syntax:
a)
A class that is not intended to be instantiated but is to be used only as a base class is called a(n) ____________.
a. abstract class b. dummy class c. placeholder d. entity class
The ipconfig command displays the personal computer’s IP address and ____________________.
What will be an ideal response?