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?()