At5:30PM,adatabaseadministrator,William,isinformedthatanimportantrecordofemployeenoE0025ismissingfromtheSCOTT.EMPLOYEEtable.At4:30P.M,thetablecontainedtherecordofemployeenoE0025.WilliamissuesthefollowingcommandtofindtheSQLstatementsthatareusedtoundothedeletion:
SELECToperation,undo_sql,logon_user
FROMFLASHBACK_TRANSACTION_QUERYWHERExid=
HEXTORAW(’0100043E23456’);
where’0100043E23456’isthetransactionIDofthetransactionthatdeletedtherow.Beforeissuingtheabovestatement,whichtaskdidWilliamperformtoidentifythetransactionIDofthetransactionthatdeletedtherow?()