Oracle Exam 1Z0-497 Topic 9 Question 20 Discussion

Actual exam question for Oracle's 1Z0-497 exam

Question #: 20
Topic #: 9

After a ___________ statement is issued, a transaction ends. (select three)

ACOMMIT

BROLLBACK

CSAVEPOINT

DSELECT

ECREATE

Show Suggested Answer

Suggested Answer: A, B, E

A transaction ends when any of the following actions occurs:

* (AB) A user issues a COMMIT or ROLLBACK statement without a SAVEPOINT clause.

* (E) A user runs a DDL command such as CREATE, DROP, RENAME, or ALTER.

Etc.

Oracle Database Concepts, 12c, End of a Transaction

by Mona at May 05, 2022, 10:51 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!