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
YourdatabaseisfunctioninginNOARCHIVELOGmode.Yourdatabasecontains15tablespaces.YouwanttouseRecoveryManager(RMAN)toperformbackups.Whichtwobackupswouldyoubeabletoperformwhenthedatabaseisbeingaccessedbyusers?()
A. backupofofflinetablespaces
B. backupofreadonlytablespaces
C. backupofsystemcriticaltablespaces
D. backupofonline,locallymanagedtablespaces
E. backupofread/writedictionarymanagedtablespaces