You currently have an active transaction in your session and have been granted select access
To VSTRANSACTIONIn which three situations will re-executing this query still return a row but with a different XID
Indicating a new transaction has started?
Select xid, status FROM v$transcation;
In your session returns:
XID STATUS
-------------------------------
0A007000A070000 ACTIVE
A.after successfully executing a TRUNCATE statement followed by a DML statement B.after successfully executing a CREATE TABLE AS Select statement followed by a SELECT正确答案ABD
FOR UPDATE statement C.after successfully executing a CREATE TABLE statement followed by a CREATE INDEX
Statement D.after successfully executing a commit or ROLLBACK followed by a DML statement E.after successfully executing a DML statement following a failed DML statement F.after successfully executing a commit or ROLLBACK followed by a Select statement
