Which two statements complete a transaction? (Choose two.)
A.
ROLLBACK TO SAVEPOINT C;
B.
SELECT MAX(sal)
FROM employees
WHERE department_id = 20;
C.
GRANT SELECT ON employees TO SCOTT;
D.
DESCRIBE employees;
E.
ALTER TABLE employees
SET UNUSED COLUMN sal;
F.
DELETE employees;
Explanation:
C: GRANT is a DML operation which will cause an implicit commit
E: It is important to understand that an implicit COMMIT occurs on the database when a user exits
SQL*Plus or issues a data-definition language (DDL) command such as a CREATE TABLE
statement, used to create a database object, or an ALTER TABLE statement, used to alter a
database object.