单项选择题

Youfindthattheexecutiontimeofreportsinyourdatawarehouseapplicationissignificantlyhigh.You suspectthelackofindexestobethereasonforthedegradationinperformance.Whichadvisorycomponentwouldyoureferto，inordertodeterminetheappropriateindexes？（）
A.MemoryAdvisor
B.SegmentAdvisor
C.SQLAccessAdvisor
D.AutomaticWorkloadRepository（AWR）
E.AutomaticDatabaseDiagnosticMonitor（ADDM）

A.You
B.Whichadvisorycomponentwouldyoureferto，inordertodeterminetheappropriateindexes？（）
A.MemoryAdvisor
C.SegmentAdvisor
D.SQLAccessAdvisor
E.AutomaticWorkloadRepository（AWR）
F.AutomaticDatabaseDiagnosticMonitor（ADDM）

你可能感兴趣的试题

单项选择题

FromtheV$SESSION_LONGOPSview，youfindthatsomeofthedatabaseusershavelongrunningqueriesandareconsumingalotofCPUtime.Thiscausesproblemsforyouwhenyoutrytologonasthesystemuserandperformsmallmaintenancetasks.YouwouldliketoensurethatusersSYSandSYSTEMgetpriorityoverallotherusers.Whichmethodwouldyouusetoachievethisobjective？（）
A.createaplandirectiveintheSYS_GROUP
B.createthependingareafortheconsumergroup
C.activatetheprovidedSYSTEM_PLANinResourceManager
D.settheTIMED_STATISTICSparametertoTRUEintheparameterfile
E.settheexecutiontimelimitforallusers，exceptSYSandSYSTEM，intheirprofiles

A.Thiscausesproblemsforyouwhenyoutrytologonasthesystemuserandperformsmallmaintenancetasks.YouwouldliketoensurethatusersSYSandSYSTEMgetpriorityoverallotherusers.Whichmethodwouldyouusetoachievethisobjective？（）
A.createaplandirectiveintheSYS_GROUP
B.createthependingareafortheconsumergroup
C.activatetheprovidedSYSTEM_PLANinResourceManager
D.settheTIMED_STATISTICSparametertoTRUEintheparameterfile
E.settheexecutiontimelimitforallusers，exceptSYSandSYSTEM，intheirprofiles

单项选择题

InwhichcasewouldyouusetheFlashbackDatabasefeaturetoperformarecovery？（）

A.torecoveradroppedtablespace
B.torecoverdatafromatruncatedtable
C.torecoveradatafilethathasbeenshrunk
D.torecoveradatabasetothestatethatexistedbeforetheRESETLOGSoperation