13. You executed the following query:
SELECT operation, undo_sql, table_name FROM flashback_transaction_que
ry;
Which statement is correct regarding the query output?
A. It would return information regarding only the last committed tran
saction.
B. It would return only the active transactions in all the undo segme
nts in the database.
C. It would return only the committed transactions in all the undo se
gments in the database.
D. It would return both active and committed transactions in all the
undo segments in the database.
E. It would return information regarding the transactions that began
and were committed in the last 30 minutes.
Answer: D
flashback_transaction_query 中的数据来自undo datafile，只要事务
对应的before image 在undo datafile 中存在，flashback_transaction_query 里面就可
以查询到数据...目前没发现受那个参数的制约。
undo中除了active的数据还有expired和unexpired的数据。C不全面。
插一句。select的时候会对比数据中的scn，如果小于当前值，那么就会去undo中找。
undo中除了active的数据还有expired和unexpired的数据。C不全面。
插一句。select的时候会对比数据中的scn，如果小于当前值，那么就会去undo中找。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-717628/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
