<{p}>You currently have an active transaction in your session and have been granted select access<{/p}><{p}>to VSTRANSACTION<{/p}><{p}>In which three situations will re-executing this query still return a row but with a different XID<{/p}><{p}> <{/p}><{p}>indicating a new transaction has started?<{/p}>

【多选题】
A <{p}>after successfully executing a TRUNCATE statement followed by a DML statement<{br/}><{/p}>
B <{p}>after successfully executing a CREATE TABLE AS Select statement followed by a SELECT<{/p}><{p}> <{/p}><{p}>FOR UPDATE statement<{/p}>
C <{p}>after successfully executing a CREATE TABLE statement followed by a CREATE INDEX<{/p}><{p}> <{/p}><{p}>statement<{/p}>
D <{p}>after successfully executing a commit or ROLLBACK followed by a DML statement<{br/}><{/p}>
E <{p}>after successfully executing a DML statement following a failed DML statement<{br/}><{/p}>
F <{p}>after successfully executing a commit or ROLLBACK followed by a Select statement<{br/}><{/p}>

查看更多