网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）
Youexecutedthefollowingquery:SELECToperation,undo_sql,table_nameFROMflashback_transaction_queryWhichstatementiscorrectregardingthequeryoutput?()

A.Itwouldreturninformationregardingonlythelastcommittedtransaction.

B.Itwouldreturnonlytheactivetransactionsinalltheundosegmentsinthedatabase.

C.Itwouldreturnonlythecommittedtransactionsinalltheundosegmentsinthedatabase.

D.Itwouldreturnbothactiveandcommittedtransactionsinalltheundosegmentsinthedatabase.

E.Itwouldreturninformationregardingthetransactionsthatbeganandwerecommittedinthelast30minutes.

参考答案

更多 “ Youexecutedthefollowingquery:SELECToperation,undo_sql,table_nameFROMflashback_transaction_queryWhichstatementiscorrectregardingthequeryoutput?() A.Itwouldreturninformationregardingonlythelastcommittedtransaction.B.Itwouldreturnonlytheactivetransactionsinalltheundosegmentsinthedatabase.C.Itwouldreturnonlythecommittedtransactionsinalltheundosegmentsinthedatabase.D.Itwouldreturnbothactiveandcommittedtransactionsinalltheundosegmentsinthedatabase.E.Itwouldreturninformationregardingthetransactionsthatbeganandwerecommittedinthelast30minutes. ” 相关考题
考题 Youexecutedthefollowingquery:SELECToperation,undo_sql,table_nameFROMflashback_transaction_query;Whichstatementiscorrectregardingthequeryoutput?() A.Itwouldreturninformationregardingonlythelastcommittedtransaction.B.Itwouldreturnonlytheactivetransactionsinalltheundosegmentsinthedatabase.C.Itwouldreturnonlythecommittedtransactionsinalltheundosegmentsinthedatabase.D.Itwouldreturnbothactiveandcommittedtransactionsinalltheundosegmentsinthedatabase.E.Itwouldreturninformationregardingthetransactionsthatbeganandwerecommittedinthelast30minutes.
查看答案
考题 At5：30PM，adatabaseadministrator，William，isinformedthatanimportantrecordofemployeenoE0025ismissingfromtheSCOTT.EMPLOYEEtable.At4：30P.M，thetablecontainedtherecordofemployeenoE0025.WilliamissuesthefollowingcommandtofindtheSQLstatementsthatareusedtoundothedeletion：SELECToperation，undo_sql，logon_userFROMFLASHBACK_TRANSACTION_QUERYWHERExid=HEXTORAW（’0100043E23456’）；where’0100043E23456’isthetransactionIDofthetransactionthatdeletedtherow.Beforeissuingtheabovestatement，whichtaskdidWilliamperformtoidentifythetransactionIDofthetransactionthatdeletedtherow？（）
查看答案
热门标签
最新试卷