渠道中线圆曲线主点是指()。

A.ReducedMTTR.

B.Datafilesremainofflinewhilecorruptblocksarerepaired.

C.Datafilesremainonlinewhilecorruptblocksarerepaired.

D.AandC

suspectthelackofindexestobethereasonforthedegradationinperformance.Whichadvisorycomponentwouldyoureferto，inordertodeterminetheappropriateindexes？（）

A.MemoryAdvisor

B.SegmentAdvisor

C.SQLAccessAdvisor

D.AutomaticWorkloadRepository（AWR）

E.AutomaticDatabaseDiagnosticMonitor（ADDM）

A. failures because a data file is renamed by error

B. failures when no standby database is configured

C. failures that require no archive logs to be applied for recovery

D. failures due to loss of connectivity-for example, an unplugged disk cable

A.Schedule，createnewpackage，viewmanifest，viewcontents

B.Createnewpackage，viewmanifest，viewcontents，schedule

C.Schedule，createnewpackage，viewcontents，viewmanifest

D.Createnewpackage，viewcontents，viewmanifest，schedule

E.Noneoftheabove.

finsertsanddeletesarehappeningontheTRANStableintheUSERStablespaceandyoususpectthattheTRANStableisfragmented.Whichadvisorycomponentwouldyoureferto，inordertofindinformationabouttablefragmentation？（）

A.MemoryAdvisor

B.SegmentAdvisor

C.SQLTuningAdvisor

D.SQLAccessAdvisor

E.AutomaticDatabaseDiagnosticMonitor（ADDM）

A.CleansuptheADRbydeletingfilesnotassociatedwithanincidentuploadedtoOracleSupport.

B.IdentifiesallfilesassociatedwithacriticalerrorandaddsthemtoazipfiletobesenttoOracleSupport.

C.AutomaticallyopensaServiceRequestwithOracleSupportforeachcriticalerrorandsendsallrelevantfiles.

D.Displaysahigh-levelviewofcriticalerrorsonthedatabasehomepage.

separation of responsibilities along with a consolidation of RMAN repository.Which condition must be met before you create the VPC?（）

A. A base catalog exists

B. The recovery catalog is empty

C. The base recovery catalog must be dropped

D. A target database is registered in the recovery catalog

raftertheINSERTstatementisissuedandfewrowsareinserted：INSERTINTOEMP_DEP（emp_id，name，salary，dep_name，mgr_id）*ERRORatline1：ORA-01653：unabletoextendtableSCOTT.EMP_DEPby128intablespaceUSERSIdentifytwoactionseitherofwhichwillhelpyouresolvethisproblem.（）

A.GranttheRESOURCEroletoSCOTT.

B.AdddatafilestotheUSERStablespace.

C.GranttheCREATEANYTABLEprivilegetoSCOTT.

D.IncreasethespaceforSCOTTontheUSERStablespace.

E.IncreasethesizeofthedatafileassociatedwiththeUSERStablespace

A.Viewlong-runningSQLworkloads

B.Viewproblemdetails

C.Gatheradditionaldiagnosticinformation

D.CreateaServiceRequest

E.CleanupincidentdataafteruploadtoOracleSupport

Youobservethatdatabaseperformancehasdegradedoveraperiodoftime.Whileinvestigatingthereason，youfindthatthesizeofthedatabasebuffercacheisnotlargeenoughtocachealltheneededdatablocks.Whichadvisorycomponentwouldyoureferto，inordertodeterminetherequiredsizeofthedatabasebuffercache？（）

A.MemoryAdvisor

B.SegmentAdvisor

C.SQLTuningAdvisor

D.SQLAccessAdvisor

E.AutomaticDatabaseDiagnosticMonitor（ADDM）