Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
Oracle Transaction
« Previous
Next »
Savepoints divide a long transaction into smaller parts
Options
- True
- False
CORRECT ANSWER : True
Discussion Board
Savepoints
The above statement is true. Savepoints divide a long transaction into smaller parts. You can declare intermediate markers called savepoints within the context of a transaction. Using savepoints, you can arbitrarily mark your work at any point within a long transaction. Savepoints are similarly useful in application programs. If a procedure contains several functions then you can create a savepoint before each function begins. Then, if a function fails, it is easy to return the data to its state before the function began and re-run the function with revised parameters or perform a recovery action.
Prajakta Pandit 02-19-2017 10:49 PM
« Previous
Next »
Write your comments
*
*
Email must be in the form someone@domain.com
*
*
Enter the code shown above:
Please enter the code shown above
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
Related Content
Oracle (40)
Oracle (30)
Oracle (49)
Oracle (51)
Oracle (52)
Oracle DBA (29)
Oracle PLSQL (30)
Oracle Replication (20)
Oracle Architecture (20)
Oracle Transaction (20)
PLSQL (22)
PLSQL (24)
PLSQL (50)
Advertisement
▲