Which two statements are true regarding a SAVEPOINT? (Choose two.)
A. A SAVEPOINT does not issue a COMMIT
B. Only one SAVEPOINT may be issued in a transaction
C. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
D. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
E. Rolling back to a SAVEPOINT can undo a DELETE statement
A,E
AE
ONLY DDL COMMANDS ISSUE COMMIT IMPLICITLY
I wonder with the E
table-privilege
DELETE |
INSERT |
REFERENCES [column list] |
SELECT [column list] |
TRIGGER |
UPDATE [column list]