Transactions can start with BEGIN (or START TRANSACTION), end with COMMIT, or abort with ROLLBACK. In addition to these, there is a temporary save feature for data called SAVEPOINT.
For complex transactions, it may be useful to be able to change the flow of processing depending on the contents of the data, and cancel and redo only the updates after a certain point. In such a case, you can use SAVEPOINT for temporary save.

SAVEPOINT is used in the form of 'SAVEPOINT name', with the savepoint name specified as a parameter. This pairs with 'ROLLBACK TO name', which allows you to return to that point (that is, it discards any updates since the temporary save). A savepoint name is required for both SAVEPOINT and ROLLBACK TO.
The same savepoint name can be used repeatedly. In that case, the savepoint is overwritten and the state of the previous temporary save is lost. Note that it is temporarily saved in a more recent state, so no data is lost).

If you execute ROLLBACK instead of 'ROLLBACK TO name', existing SAVEPOINT will be discarded and all updates in the transaction will be discarded.
COMMIT commits and writes all updates in a transaction, with or without SAVEPOINT.

So the correct answers are C, D, and E.