Which two statements are true regarding a SAVEPOINT? (Choose two.)
Which two statements are true regarding a SAVEPOINT? (Choose two.)
A SAVEPOINT allows you to set a point within a transaction to which you can later roll back. Rolling back to a SAVEPOINT can undo Data Manipulation Language (DML) statements like DELETE, making statement E correct. A SAVEPOINT itself does not issue a COMMIT, which means that changes before the SAVEPOINT can still be rolled back if needed; therefore, statement D is correct. Other options mentioned actions like CREATE INDEX (a Data Definition Language (DDL) statement), TRUNCATE (also DDL), and restrictions on the number of SAVEPOINTs, none of which align with the fundamental functionalities of SAVEPOINT in SQL.
DE provided answer's are correct.
agree, DE are correct
D and E are correct answers because DDL statements such as CREATE, ALTER, TRUNCATE, etc commit trunsactions. and you can also have multiple savepoints in the same transaction.
A - FALSE; DDL changes cannot be undone B - FALSE; see A C - FALSE; there can be multiple savepoints, see https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/SAVEPOINT.html#GUID-78EEA746-0021-42E8-9971-3BA6DFFEE794 where text "Savepoint names must be distinct within a given transaction. If you create a second savepoint with the same identifier as an earlier savepoint, then the earlier savepoint is erased." is mentioned D - TRUE; savepoint helps to rollback some changes, thus it cannot issue a COMMIT E - TRUE; DELETE is a DML change, and thus it can be undone with ROLLBACK
I agree
It is still correct :-)
DE I agree too
D,E is correct