Q50 You currently have an active transaction in your session and have been granted select access to V$TRANSACTION

0 Shares

Q50 You currently have an active transaction in your session and have been granted select access to V$TRANSACTION.

word image 5028 1

In which three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has started?

(A). after successfully executing a commit or rollback followed by a select statement
(B). after successfully executing a create table as select statement followed by a select for update statement
(C). after successfully executing a commit or rollback followed by a DML statement
(D). after successfully executing a create table statement followed by a create index statement
(E). after successfully executing a DML statement following a failed DML statement
(F). after successfully executing a truncate statement followed by a DML statement