单选题While performing monitoring and tuning the database， you want to view the summarized information about the warning level alerts and critical level alerts. Which section of the Oracle Enterprise manager displays the summarized information about the warn

第1题：

You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）

• A、 The EVENT parameter was not set
• B、 The SQL_TRACE parameter is set to FALSE
• C、 The Enterprise Manager Grid Control is not used
• D、 The STATISTICS_LEVEL parameter is set to BASIC
• E、 The TIMED_STATISTICS parameter is set to FALSE

第2题：

Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?（）

• A、Journal
• B、Task Center
• C、Control Center
• D、Activity Monitor

第3题：

第4题：

Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）

• A、Allocates memory for RMAN backup and restore operations
• B、Allocates memory for shared and private SQL areas
• C、Contains a cursor area for storing runtime information about cursors
• D、Contains stack space
• E、Contains a hash area performing hash joins of tables

第5题：

A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）

• A、Execute the query and view Active Session History (ASH) for information about the query.
• B、Enable SQL trace for the query.
• C、Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.
• D、Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

第6题：

Which of the following tasks does the tool Incident Packaging Service （IPS） perform？（）  

• A、 Cleans up the ADR by deleting files not associated with an incident uploaded to Oracle Support.
• B、 Identifies all files associated with a critical error and adds them to a zip file to be sent to Oracle Support.
• C、 Automatically opens a Service Request with Oracle Support for each critical error and sends all relevant files.
• D、 Displays a high-level view of critical errors on the database home page.

第7题：

You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）

• A、Application Server Control
• B、Oracle Management Service
• C、Oracle Enterprise Manager Repository
• D、Oracle Enterprise Manager Database Control

第8题：

第9题：

You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%， respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）

• A、The EVENT parameter was not set.
• B、The SQL_TRACE parameter is set to FALSE
• C、The Enterprise Manager Grid Control is not used.
• D、The STATISTICS_LEVEL parameter is set to BASIC
• E、The TIMED_STATISTICS parameter is set to FALSE

第10题：

You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used.  Which method would you follow to achieve this？（）

• A、enable index monitoring and query the DBA_OBJECTS view
• B、enable index monitoring and query the DBA_INDEXES view
• C、enable index monitoring and query the V$OBJECT_USAGE view
• D、enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view