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 employeesSET UNUSED COLUMN sal;

F.
Select MAX(sal)FROM employeesWHERE 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 1

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


Bina

Bina

Grant is a DCL operation not DML operation.
Ans D, E