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.
Answer: B,C
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_10001.htm#SQLRF01701
A. Savepoints work with with roll back, after commit is executed, save spoint before that are not used. – False
B. Correct
C. Correct
“Transactions apply only to the Data Manipulation Language (DML) portion of the SQL language (such as INSERT, UPDATE, and DELETE). Transactions do not apply to the Data Control Language (DCL) or Data Definition Language (DDL) portions (such as CREATE, DROP, ALTER, and so on.) of the SQL language. DCL and DDL commands always force a commit, which in turn commits everything done before them.”
D. After commit, can’t retrieve back to to last safepoints, false
E. False.
I think the answer is B,C