题目内容

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

查看答案

Whilesettingupthethresholdsfortablespacespaceusagemetricsforoneofyourtablespaces，youdefinethecriticalthresholdas60%andwarningthresholdas75%.Whatwouldbetheresultofthissetting？（）

A. Itwouldresultinanerrorbecausethewarningthresholdcannotbemorethanthecriticalthreshold.
B. Thewarningthresholdisignoredandalertswouldbegeneratedwhenspaceusageexceedsthecriticalthreshold.
C. Thecriticalthresholdisignoredandalertswouldbegeneratedwhenspaceusageexceedsthewarningthreshold.
D. Boththresholdvaluesareusedandalertsaregeneratedwhenspaceusageexceedstherespectivethresholdvalues.

查看答案

TheDBAhaschosentomanageSGAandPGAmemoryseparatelyinanOLTPdatabasebecauseofhisuniqueknowledgeoftheapplication.WhichofthesearegoodstartingpointstousewhenconfiguringthemaximumvaluesforSGAandPGA，basedontheamountofmemoryavailableonthesystem？（）

A. 20%SGA 80%PGA
B. 25%SGA 75%PGA
C. 50%SGA 50%PGA
D. 75%SGA 25%PGA
E. 80%SGA 20%PGA

查看答案

A. createaplandirectiveintheSYS_GROUP B. createthependingareafortheconsumergroup C. activatetheprovidedSYSTEM_PLANinResourceManager D. settheTIMED_STATISTICSparametertoTRUEintheparameterfile E. settheexecutiontimelimitforallusers，exceptSYSandSYSTEM，intheirprofiles

Whichviewprovidesinformationonthebackupstatusofthedatafilesinthedatabase？（）

YourdatabaseisfunctioninginNOARCHIVELOGmode.Yourdatabasecontains15tablespaces.YouwanttouseRecoveryManager（RMAN）toperformbackups.Whichtwobackupswouldyoubeabletoperformwhenthedatabaseisbeingaccessedbyusers？（）

Whilesettingupthethresholdsfortablespacespaceusagemetricsforoneofyourtablespaces，youdefinethecriticalthresholdas60%andwarningthresholdas75%.Whatwouldbetheresultofthissetting？（）

TheDBAhaschosentomanageSGAandPGAmemoryseparatelyinanOLTPdatabasebecauseofhisuniqueknowledgeoftheapplication.WhichofthesearegoodstartingpointstousewhenconfiguringthemaximumvaluesforSGAandPGA，basedontheamountofmemoryavailableonthesystem？（）

A. createaplandirectiveintheSYS_GROUP
B. createthependingareafortheconsumergroup
C. activatetheprovidedSYSTEM_PLANinResourceManager
D. settheTIMED_STATISTICSparametertoTRUEintheparameterfile
E. settheexecutiontimelimitforallusers，exceptSYSandSYSTEM，intheirprofiles