单项选择题

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？（）

A.EMPLOYEEtable.At4：30P.M，thetablecontainedtherecordofemployeenoE0025.WilliamissuesthefollowingcommandtofindtheSQLstatementsthatareusedtoundothedeletion：

你可能感兴趣的试题

YoudeploymobiledevicesthatrunMicrosoftWindowsMobile5.0withMicrosoftMessagingandSecurityFeaturePack.AserverthatrunsMicrosoftExchangeServer2003ServicePack2isconfiguredbyusingthedefaultinstallationsettings.CompanysecuritypolicyrequiresacomplexpasswordforunlockingtheWindowsMobilebaseddevices.YouneedtoensurethattheWindowsMobilebaseddevicesthatperformMicrosoftActiveSyncsynchronizationmeetthecompanysecuritypolicy.Whichtwoactionsshouldyouperform？（）
A.EnterallmobiledeviceusersintheExceptionslist.
B.EnabletheRequirebothnumbersandlettersoption.
C.EnabletheAllowaccesstodevicesthatdonotfullysupportpasswordsettingsoption.
D.EnabletheMinimumpasswordlength（characters）option.Configureavalueof6orgreater.

A.0withMicrosoftMessagingandSecurityFeaturePack.AserverthatrunsMicrosoftExchangeServer2003ServicePack2isconfiguredbyusingthedefaultinstallationsettings.CompanysecuritypolicyrequiresacomplexpasswordforunlockingtheWindowsMobilebaseddevices.YouneedtoensurethattheWindowsMobilebaseddevicesthatperformMicrosoftActiveSyncsynchronizationmeetthecompanysecuritypolicy.Whichtwoactionsshouldyouperform？（）
A.EnterallmobiledeviceusersintheExceptionslist.
B.EnabletheRequirebothnumbersandlettersoption.
C.EnabletheAllowaccesstodevicesthatdonotfullysupportpasswordsettingsoption.
D.EnabletheMinimumpasswordlength（characters）option.Configureavalueof6orgreater.

单项选择题

Attheendofthefinancialyear，anaccountsaccumulationbatchisrun.Thisbatchupdatesthecompany’saccountingrecords.Duringthebatchrunprocess，someincorrectentrieswereinsertedintotheACCOUNTtable.Youidentifiedthebugandimmediatelystoppedthebatchrunprocess，but3000incorrectrecordswereinsertedintotheACCOUNTtablebeforethebatchprocesswasstopped.Youwanttorecoverthetabletothestateitwasat11：50P.M.Whichflashbackfeaturewillyouuse？（）
A.FlashbackDrop
B.FlashbackDatabase
C.FlashbackTable
D.FlashbackVersionQuery

A.Thisbatchupdatesthecompany’saccountingrecords.Duringthebatchrunprocess，someincorrectentrieswereinsertedintotheACCOUNTtable.Youidentifiedthebugandimmediatelystoppedthebatchrunprocess，but3000incorrectrecordswereinsertedintotheACCOUNTtablebeforethebatchprocesswasstopped.Youwanttorecoverthetabletothestateitwasat11：50P.M.Whichflashbackfeaturewillyouuse？（）
A.FlashbackDrop
B.FlashbackDatabase
C.FlashbackTable
D.FlashbackVersionQuery