单项选择题

YouareemployedasaDBAinanorganization.YouareinformedthattherecordofEMP_NO1000ismissingfromtheSCOTT.EMPtable.Youarerequiredtoidentifytheuserwhodeletedtherecord，theSQLstatementthatwillundothedeletion，andthetransactionIDofthetransactionthatdeletedtheemployeerecord.Whichfeaturewillyouusetoperformthetasks？（）
A.OnlytheFlashbackTable
B.BoththeFlashbackTransactionQueryandtheFlashbackVersionQuery
C.OnlytheFlashbackDrop
D.OnlytheFlashbackVersion

A.YouareinformedthattherecordofEMP_NO1000ismissingfromtheSCOTT.EMPtable.Youarerequiredtoidentifytheuserwhodeletedtherecord，theSQLstatementthatwillundothedeletion，andthetransactionIDofthetransactionthatdeletedtheemployeerecord.Whichfeaturewillyouusetoperformthetasks？（）
A.OnlytheFlashbackTable
B.BoththeFlashbackTransactionQueryandtheFlashbackVersionQuery
C.OnlytheFlashbackDrop
D.OnlytheFlashbackVersion

<上一题目录下一题>

热门试题

单项选择题

YouareworkingasaDBAatNetFxCorporation.YoudiscoverthattheSCOTTschemaisdeletedbymistake.Youdecidetoflashthedatabasebacktothetimewhentheschemaexisted.Whichviewwillyouquerytodeterminetheestimatedsizeoftheflashbackdatathatyourequireforyourcurrenttargetretention？（）A.V$FLASHBACK_DATABASE_LOGB.V$FLASHBACK_DATABASE_STATC.V$DATABASED.V$UNDOSTAT

A.YoudiscoverthattheSCOTTschemaisdeletedbymistake.Youdecidetoflashthedatabasebacktothetimewhentheschemaexisted.Whichviewwillyouquerytodeterminetheestimatedsizeoftheflashbackdatathatyourequireforyourcurrenttargetretention？（）
A.V$FLASHBACK_DATABASE_LOG
B.V$FLASHBACK_DATABASE_STAT
C.V$DATABASE
D.V$UNDOSTAT

未分类题

Youareadatabaseadministratorforyourcompany.Thecompanyrunsapopulardatabase-drivenWebsiteagainstaSQLServer2005computernamedSQL2.YouneedtoensureaquickresponsetimeandappropriateaudittrailintheeventthatSQL2experiencesexcessivetrafficduetodenial-of-service（DoS）attacks.Whichtwoactionsshouldyouperform？（）A.CreateanewperformancealerttomonitortheCurrentBandwidthcounter.B.CreateanewperformancealerttomonitortheBytesTotal seccounter.C.ConfigurethenewperformancealerttostartaSQLServerProfilertrace.D.ConfigurethenewperformancealerttostartaNetworkMonitorcapture.