What happens when DML Statement fails?A.User level rollbackB.Statement Level RollbackC.Sustem Level Rollback

  • Interview Candidate
  • 4
  • 3597

Showing Answers 1 - 4 of 4 Answers

Bug virus

  • Mar 8th, 2006
 

Statement level rollback.

  Was this answer useful?  Yes

Narender Reddy

  • May 19th, 2006
 

Hi, Since the DML statement has not been completed, it will not go for any rollback. Because the entry will not found in rollback segments.

  Was this answer useful?  Yes

Chiru

  • Jun 21st, 2006
 

When a DML statement executes (fails/sucess) an automatic Commit is executed. Eg : Create a table t1. Insert a record in t1. Then again to create the same object t1.  

  Was this answer useful?  Yes

g_sidhu

  • Feb 1st, 2008
 

If a single DML statement fails during execution of a transaction, it s effect is undone by a statement-level rollback, but the changes made by the previous DML statements in the transaction are not discarded. They can be committed or rolled back explicitly by the user.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions