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
Whichviewprovidesinformationonthebackupstatusofthedatafilesinthedatabase?()
A. V$BACKUP
B. V$BACKUP_STATUS
C. V$BACKUP_DATAFILE
D. V$DATAFILE_BACKUP
E. V$TABLESPCE_BACKUP