Considerthefollowingcommand:Backupdatabaseplusarchivelogdeleteinput;Howmanybackupsetswouldbecreatedbythiscommandifthefollowingweretrue:()Control-fileaNNutobackupswereenabled.NNThesizeofbackupsetswasnotrestricted.NNOnechannelwasallocated.
查看答案
Thecurrenttimeis12:00noon.YouwanttorecovertheUSERStablespacefromafailurethatoccurredat11:50a.m.Youdiscoverthattheonlymemberofanunarchivedredologgroupcontaininginformationfrom11:40a.m.onwardsiscorrupt.Withreferencetothisscenario,ifyouarenotusingRecoveryManager(RMAN),whichrecoverymethodwouldyouuse?()
A. timebasedrecovery
B. logsequencerecovery
C. cancelbasedrecovery
D. changebasedrecovery
IfyouissuethecommandshutdownabortpriortotryingtoputthedatabaseinARCHIVELOGmode,whatwillbetheresultwhenyouissuethecommandalterdatabasearchivelog?()
A. Thealterdatabasearchivelogcommandwillfail
B. ThealterdatabasearchiveloginconsistentcommandmustbeusedtoputthedatabaseinARCHIVELOGmode
C. Thealterdatabasearchivelogcommandwillsucceed
D. Thealterdatabasearchivelogcommandwillaskifyouwanttomakethedatabaseconsistentfirst
E. Thereisnoalterdatabasearchivelogcommand.Thecorrectcommandisalterdatabasealterlogging
古代逻辑的发源地包括()。
A. 古希腊
B. 中国
C. 古印度
D. 以上都对
FromtheV$SESSION_LONGOPSview,youfindthatsomeofthedatabaseusershavelongrunningqueriesandareconsumingalotofCPUtime.Thiscausesproblemsforyouwhenyoutrytologonasthesystemuserandperformsmallmaintenancetasks.YouwouldliketoensurethatusersSYSandSYSTEMgetpriorityoverallotherusers.Whichmethodwouldyouusetoachievethisobjective?()
A. createaplandirectiveintheSYS_GROUP
B. createthependingareafortheconsumergroup
C. activatetheprovidedSYSTEM_PLANinResourceManager
D. settheTIMED_STATISTICSparametertoTRUEintheparameterfile
E. settheexecutiontimelimitforallusers,exceptSYSandSYSTEM,intheirprofiles