Errors discovered during SQL statement execution cause statement-level rollback - Oracle Transaction

Q.  Errors discovered during SQL statement execution cause
- Published on 13 Aug 15

a. statement-level rollback
b. Row-level rollback
c. Deadlock
d. Both a and b

ANSWER: statement-level rollback
 

    Discussion

  • Nirja Shah   -Posted on 22 Sep 15
    - If at any time during execution a SQL statement causes an error, all effects of the statement are rolled back.

    - The effect of the rollback is as if that statement had never been run. This operation is a statement-level rollback.

    - Errors discovered during SQL statement execution cause statement-level rollbacks.

    - An example of such an error is attempting to insert a duplicate value in a primary key.

    - Single SQL statements involved in a deadlock (competition for the same data) can also cause a statement-level rollback.

    - Errors discovered during SQL statement parsing, such as a syntax error, have not yet been run, so they do not cause a statement-level rollback.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)