Which two statements complete a transaction? (Choose two)
A.
DELETE employees;
B.
DESCRIBE employees;
C.
ROLLBACK TO SAVEPOINT C;
D.
GRANT SELECT ON employees TO SCOTT;
E.
ALTER TABLE employees
SET UNUSED COLUMN sal;
F.
Select MAX(sal)
FROM employees
WHERE department_id = 20;
Explanation:
D: 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.
Incorrect Answers
A:. The DELETE command is data-manipulation language (DML) command and it does not complete a
transaction.
B:. The DESCRIBE command is internal SQL*Plus command and it has nothing to do with completion a
transaction.
C: ROLLBACK is not used to commit or complete a transaction, it is used to undo a transaction
F:. SELECT command is used to retrieve data. It does not complete a transaction.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 281-282
Chapter 3: Advanced Data Selection in Oracle