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.

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.

Answer / tulsi

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

Answer / rahul

used to recover data
that recently deleted

Answer / kotravel. b

To perform line by line transaction we r using save point

What are the disadvantages of file system?

0 Answers  

Can you sum a count in sql?

0 Answers  

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

what is primary key? : Sql dba

0 Answers  

what's the difference between a primary key and a unique key? : Sql dba

0 Answers  

what are all the different normalizations? : Sql dba

0 Answers  

using comand prompt how can import table data and table space with example

2 Answers  

Does group by remove duplicates?

0 Answers  

what is the difference between undefined value and null value? : Sql dba

0 Answers  

What is the best free sql database?

0 Answers  

Explain how can you save or place your msg in a table?

0 Answers  

Can we edit a view in sql?

0 Answers