Which two statements complete a transaction? (Choose two)

The correct answer is D. GRANT SELECT ON employees TO SCOTT; E. ALTER TABLE employees. 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 SQLPlus or issues a data-definition language (DDL) command such as a CREATE TABLE statement, used to create a…

Manipulating Data (DML)

Question

Options

ADELETE employees;
BDESCRIBE employees;
CROLLBACK TO SAVEPOINT C;
DGRANT SELECT ON employees TO SCOTT;
EALTER TABLE employees
FSelect MAX(sal)

How the community answered

(40 responses)

A
3% (1)
B
3% (1)
C
10% (4)
D
80% (32)
F
5% (2)

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 SQLPlus 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 SQLPlus 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.

Topics

#transaction control#DDL auto-commit#GRANT commit#ROLLBACK SAVEPOINT

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice