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

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

(64 responses)

A
2% (1)
B
6% (4)
C
3% (2)
D
75% (48)
F
14% (9)

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 completion#DDL auto-commit#GRANT#ROLLBACK TO SAVEPOINT

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice