题目内容

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

答案查题题库