单选题In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation. How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?（）A It

第1题：

第2题：

Identify two correct statements about multitenant architectures.（）

• A、Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.
• B、Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.
• C、Multiple CDBs share certain PDB resources.
• D、Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.
• E、Patches are always applied at the CDB level.
• F、A PDB can have a private undo tablespace.

第3题：

第4题：

You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）

• A、Enable Memory Access Mode, which reads performance data from SGA.
• B、Use emergency monitoring to fetch data directly from SGA analysis.
• C、Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
• D、Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
• E、Run ADDM in diagnostic mode.

第5题：

You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.  Which advisory component would you refer to， in order to determine the appropriate indexes？（）

• A、Memory Advisors
• B、Segment Advisors
• C、SQL Tuning and Access Advisors
• D、Automated Workload Repository （AWR）
• E、Automatic Database Diagnostic Monitor （ADDM）

第6题：

Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）

• A、The ADDM requires at least four AWR snapshots for analysis.
• B、The ADDM runs after each AWR snapshot is collected automatically by MMON.
• C、The results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.
• D、The ADDM analysis provides only diagnostic information but does not provide recommendations.
• E、The ADDM calls other advisors if required， but does not provide recommendations about the advisors.

第7题：

In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation. How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?（）

• A、It collects data from SGA and compares it with a preserved snapshot.
• B、It collects data from SGA, analyzes it, and provides a report.
• C、It collects data from SGA and compares it with the latest snapshot.
• D、It collects data from both SGA and PGA, analyzes it, and provides a report

第8题：

第9题：

You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）

• A、 Memory Advisor
• B、 Segment Advisor
• C、 SQL Access Advisor
• D、 Automatic Workload Repository （AWR）
• E、 Automatic Database Diagnostic Monitor （ADDM）

第10题：

Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?（）

• A、If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that pdb.
• B、In a PDB plan, subplans may be used with up to eight consumer groups.
• C、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.
• D、If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
• E、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.