Youexecutedthefollowingquery:SELECToperation,undo_sql,table_nameFROMflashback_transaction_query;Whichstatementiscorrectregardingthequeryoutput?()A.Itwouldreturninformationregardingonlythelastcommittedtransaction.B.Itwouldreturnonlytheactivetransactionsina
题目
Youexecutedthefollowingquery:SELECToperation,undo_sql,table_nameFROMflashback_transaction_query;Whichstatementiscorrectregardingthequeryoutput?()
A.Itwouldreturninformationregardingonlythelastcommittedtransaction.
B.Itwouldreturnonlytheactivetransactionsinalltheundosegmentsinthedatabase.
C.Itwouldreturnonlythecommittedtransactionsinalltheundosegmentsinthedatabase.
D.Itwouldreturnbothactiveandcommittedtransactionsinalltheundosegmentsinthedatabase.
E.Itwouldreturninformationregardingthetransactionsthatbeganandwerecommittedinthelast30minutes.
相似考题
参考答案和解析
参考答案：D