网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
Youexecutedthefollowingquery:SELECToperation,undo_sql,table_nameFROMflashback_transaction_query;Whichstatementiscorrectregardingthequeryoutput?()
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. ” 相关考题
考题
Youexecutedthefollowingquery:SELECToperation,undo_sql,table_nameFROMflashback_transaction_queryWhichstatementiscorrectregardingthequeryoutput?()
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?()
热门标签
最新试卷