8.7. Review Questions

  1. Which of the following is not a valid ADDM finding type?

    1. Error

    2. Problem

    3. Information

    4. Symptom

    5. All are valid ADDM finding types.

  2. What is the default setting for the STATISTICS_LEVEL initialization parameter?

    1. BASIC

    2. ALL

    3. STANDARD

    4. TYPICAL

    5. None of the above

  3. Which of the following would be used to set or change the value for DBIO_EXPECTED?

    1. The DBIO_EXPECTED initialization parameter

    2. The ALTER SYSTEM statement

    3. The ALTER SESSION statement

    4. All of the above will work.

    5. None of the above will work.

  4. Which of the following are types of problems that the ADDM will consider? (Choose all that apply.)

    1. Database configuration issues

    2. Concurrency issues

    3. CPU bottlenecks

    4. Suboptimal use of Oracle by an application

    5. All of the above

  5. The statistical data needed for ADDM to accurately diagnose problems is stored in which of the following areas?

    1. Automatic Workload Repository (AWR)

    2. Data dictionary

    3. ADDM repository

    4. PERFSTAT tables

    5. None of the above

  6. Which of the following is not a valid DBMS_ADVISOR procedure or function?

    1. CREATE_TASK_SCRIPT

    2. RESTART_TASK

    3. INTERRUPT_TASK

    4. RESUME_TASK

    5. None of the above

  7. In an RAC environment, which element(s) always uniquely identifies a snapshot?

    1. INSTANCE_ID

    2. CLUSTER_ID

    3. SNAP_ID

    4. Both A and C

    5. A, B, and C

  8. If the ASH buffer is filled in less than 30 minutes, which process is responsible for flushing it?

    1. SMON

    2. MMON

    3. MMNL

    4. PMON

    5. AMON

  9. Which are valid SCOPE settings for the SQL Tuning Advisor? (Choose all that apply.)

    1. Full

    2. Comprehensive

    3. Detailed

    4. Basic

    5. Limited

  10. If a metrics threshold is defined with an OBSERVATION_PERIOD setting of 5 and a CONSECUTIVE_OCCURRENCES setting of 2, an alert would be generated after how many minutes of consecutive violations?

    1. 10

    2. 15

    3. 20

    4. 5

    5. None of the above

  11. Which of the following statements regarding the Automatic Tuning Optimizer (ATO) is incorrect?

    1. The ATO generates more efficient execution plans than the query optimizer in normal mode.

    2. The ATO is nothing more than the query optimizer in tuning mode.

    3. The ATO can take a long time to process a SQL statement, especially when performing a comprehensive analysis.

    4. The ATO does generate a SQL Profile when performing a limited analysis.

    5. All the above statements are correct.

  12. The AWR resides in which tablespace?

    1. SYSTEM

    2. TOOLS

    3. SYSAUX

    4. AWR

    5. None of the above

  13. Which DBMS_STATS function is used to allow Oracle to dynamically choose an appropriate par allel degree based on the size of the object and the values of certain initialization parameters?

    1. AUTO

    2. CHOOSE

    3. DETECT

    4. AUTO_DEGREE

    5. BEST_DEGREE

  14. Which Oracle process updates the data dictionary with DML activity information gathered by the Automatic DML Monitoring feature?

    1. SMON

    2. PMON

    3. MMNL

    4. DMON

    5. MMON

  15. Which of the following views can be queried to display advisor findings?

    1. V$ADVISOR_FINDINGS

    2. DBA_ADV_FINDINGS

    3. DBA_ADV_RECOMMENDATIONS

    4. DBA_ADVISOR_FINDINGS

    5. Findings can be viewed only through Enterprise Manager.

  16. Which view shows the current AWR settings?

    1. DBA_AWR_SETTINGS

    2. DBA_AWR_CONFIG

    3. DBA_HIST_WR_CONTROL

    4. DBA_HIST_WR_SETTINGS

    5. DBA_REPOSITORY

  17. On an eight-CPU system with a Shared Pool size of 1GB, what size would the ASH buffer be set to?

    1. 8MB

    2. 16MB

    3. 50MB

    4. 32MB

    5. 32KB

  18. __________ is a hash value that uniquely identifies a SQL statement in the database.

    1. SQL_HASH

    2. SQL_HASH_ID

    3. SQL_ID

    4. SID

    5. SPID

  19. Which package(s) can be used to interface with the SQL Tuning Advisor? (Choose all that apply.)

    1. DBMS_ADVISOR

    2. DBMS_SQL_TUNE

    3. DBMS_SQLTUNE

    4. DBMS_SQL_ADVISOR

    5. DBMS_SQL_TUNE_ADV

  20. On the Edit Thresholds screen in Oracle Enterprise Manager, what does it mean if the Select button is disabled for a specific metric?

    1. The metric is disabled on the current instance.

    2. The metric is stale.

    3. The metric does not support multiple thresholds.

    4. The threshold is locked and cannot be modified.

    5. None of the above.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset