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...
A union query is used to query unrelated tables or queries and combine the results into a single dataset
Indicate whether the statement is true or false
When a penetration or vulnerability test is completed with no issues found, what is the BEST way to summarize the situation?
A. There are no vulnerabilities. B. There are no known vulnerabilities at this time. C. There are no known vulnerabilities. D. The application is secure to use.