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.
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.
Only C.
Savepoints can be user with ROLLBACK and only DML statements.