Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

How to add Foreign key in a table after the creation of the table?

5 Answers   Satyam,


What is indexing in sql and its types?

0 Answers  


What is the difference between the conventional and direct path loader? : aql loader

0 Answers  


Is join and inner join the same?

0 Answers  


How can you save or place your msg in a table?

0 Answers  


why sql is used as interpreter frequently rather than a compile?

1 Answers  


What are the types of join and explain each?

0 Answers  


What is diff between bulk collect and forall

3 Answers   Metric Stream,


how to create a database in oracle?please gve anser with example

1 Answers  


Types of joins?

4 Answers   Microsoft,


What is Histogram?

0 Answers   NIIT,


What is memory optimized?

0 Answers  


Categories