题目内容

Considerthefollowingcommand:Backupdatabaseplusarchivelogdeleteinput;Howmanybackupsetswouldbecreatedbythiscommandifthefollowingweretrue:()Control-fileaNNutobackupswereenabled.NNThesizeofbackupsetswasnotrestricted.NNOnechannelwasallocated.

A. 1
B. 2
C. 3
D. 4
E. 5

查看答案
更多问题

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

答案查题题库