Which two statements are true regarding savepoints?

Which two statements are true regarding savepoints? (Choose two.)

Which two statements are true regarding savepoints? (Choose two.)

A.
Savepoints are effective only for COMMIT.

B.
Savepoints may be used to ROLLBACK.

C.
Savepoints can be used for only DML statements.

D.
Savepoints are effective for both COMMIT and ROLLBACK.

E.
Savepoints can be used for both DML and DDL statements.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Ritam Tiwari

Ritam Tiwari

Savepoints can be used for only DML statements.
It cannot be used for DDL statements because in DDL statements auto commit happens and when commit happens all the savepoints gets automatically deleted.

Alexandre

Alexandre

Only C.

ejossue

ejossue

Savepoints can be user with ROLLBACK and only DML statements.