Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What are the usage of SAVEPOINTS?

Answers were Sorted based on User's Feedback



What are the usage of SAVEPOINTS?..

Answer / deva

Save points are used to mark our transactions. Then later
on, down the line, we can roll back to that particular
transaction and roll back can be issued to that particular
point.

Is This Answer Correct ?    32 Yes 2 No

What are the usage of SAVEPOINTS?..

Answer / bindhu

Savepoints are used to create marker in the current
transaction by using SAVEPOINT statement which divides the
transaction into smaller section. We can then dicard
pending changes up to that marker by using the ROLLBACK TO
SAVEPOINT statement.

Is This Answer Correct ?    19 Yes 4 No

What are the usage of SAVEPOINTS?..

Answer / tulsi

1)In savepoint we can only rollback to every point the
savepoint is issued but we cant do commit at every savepoint

Is This Answer Correct ?    16 Yes 4 No

What are the usage of SAVEPOINTS?..

Answer / rahul

used to recover data
that recently deleted

Is This Answer Correct ?    0 Yes 0 No

What are the usage of SAVEPOINTS?..

Answer / kotravel. b

To perform line by line transaction we r using save point

Is This Answer Correct ?    4 Yes 5 No

Post New Answer



More SQL PLSQL Interview Questions

Is natural join and inner join same?

0 Answers  


Can I call a procedure inside a function?

0 Answers  


how to include numeric values in sql statements? : Sql dba

0 Answers  


How many clustered indexes can be created on a table?

0 Answers  


how to increment dates by 1 in mysql? : Sql dba

0 Answers  






what are pl/sql collections?

4 Answers   JPMorgan Chase, Oracle,


Is postgresql a server?

0 Answers  


What are the uses of merge?

0 Answers  


What are sql commands?

0 Answers  


Why do we use procedures?

0 Answers  


What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 Answers  


What is string join?

0 Answers  






Categories