Which two statements complete a transaction?

Which two statements complete a transaction? (Choose two)

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *