下列属于人工建筑材料的有（ ）。

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）

dUSING (department_id)WHERE d.department_id NOT IN (10,40)ORSER BY dept_name;The statement fails when executed. Which change fixes the error? （）

A. remove the ORDER BY clause

B. remove the table alias prefix from the WHERE clause

C. remove the table alias from the SELECT clause

D. prefix the column in the USING clause with the table alias

E. prefix the column in the ORDER BY clause with the table alias

F. replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"

A.A

B.B

C.C

D.D

A.BMRlowersthemeantimetorecover（MTTR）.

B.BMRsupportspointintimerecoveryofindividualdatablocks.

C.BMRenablesyoutouseincrementalbackupsforblockrecovery.

D.BMRenablesrecoveryevenwhenthedatabaseisnotmountedoropen.

E.BMRenablesyoutouseproxybackupstoperformblockmediarecovery.

F.BMRenablesincreasedavailabilityofdataduringrecoverybecausethedatafilethatrequiresa recoverycanremainonline.

A. Archived redo log files are backed up along with data files.

B. Only data files are backed up and a restore point named FY06Q4 is created.

C. Archived log files are backed up along with data files, and the archived log files are deleted.

D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.