9.5. Review Questions

  1. Which of the following components of Oracle architecture stores the statistics gathered by the MMON process?

    1. ADDM

    2. AWR

    3. Data dictionary views

    4. Dynamic performance views

  2. Which of the following options for the PFILE/SPFILE parameter STATISTICS_LEVEL turns off AWR statistics gathering and ADDM advisory services?

    1. OFF

    2. TYPICAL

    3. ALL

    4. BASIC

  3. The following graphic is from the Sessions: Waiting And Working section of the EM Database Control Performance screen. Using this output, which of the following is the primary source of user wait activity?



    1. CPU Used

    2. User I/O

    3. System I/O

    4. Configuration

  4. The following graphic shows the SQL statements that are having the greatest impact on overall DB Time. Which statement has had the greatest impact?



    1. 9d87jmt7vo6nb(2.

    2. 8acv8js8kr574(24.

    3. b6usrq82hwsa3(73.

    4. None of the above was highest.

  5. Suppose you have used EM Database Control to drill down into ADDM findings and have found that a single SQL statement is causing the majority of I/O on your system. Which of the following advisors is best suited to troubleshoot this SQL statement?

    1. SQL Tuning Advisor

    2. SQL Access Advisor

    3. Both A and B

    4. Neither A or B

  6. Nearly all the advisors submit their analysis activities to the database in the form of a job. When the analysis job is submitted, which option for job scope adds the least overhead to the system?

    1. Limited

    2. Restricted

    3. Comprehensive

    4. Thorough

  7. Using the Top SQL link of the EM Database Control Performance screen produces the output shown in the following graphic. Approximately which time interval produced the highest activity for this monitored event?



    1. 9:45 to 9:50

    2. 10:00 to 10:45

    3. 9:55 to 10:10

    4. 10:00 to 10:05

  8. Which data dictionary view contains information explaining why ADDM made its recommendations?

    1. DBA_ADVISOR_FINDINGS

    2. DBA_ADVISOR_OBJECTS

    3. DBA_ADVISOR_RECOMMENDATIONS

    4. DBA_ADVISOR_RATIONALE

  9. Which of the following advisors determines if the space allocated to the Shared Pool, Large Pool, or Buffer Cache are adequate?

    1. SQL Tuning Advisor

    2. SGA Tuning Advisor

    3. Memory Advisor

    4. Pool Advisor

  10. Which of the following advisors determines if the estimated instance recovery duration is within the expected service-level agreements?

    1. Undo Management Advisor

    2. SQL Access Advisor

    3. SQL Tuning Advisor

    4. MTTR Advisor

  11. If no e-mail address is specified, where will alert information be displayed?

    1. In the DBA_ALERTS data dictionary view

    2. In the V$ALERTS dynamic performance view

    3. In the EM Database Control main screen

    4. No alert information is sent or displayed.

  12. When you configure an alert, which of the following types of alert thresholds can you use to monitor a tablespace for diminishing free space?

    1. Warning threshold

    2. Critical threshold

    3. Both A and B

    4. Neither A or B

  13. Multiple baseline metrics can be gathered and stored in the AWR. Why might you want more than one metrics baseline?

    1. You might want a separate baseline metric for each user.

    2. You might want a separate baseline metric for daytime usage versus off-hours usage.

    3. You might want a separate baseline metric for each schema.

    4. You would never want more than one baseline metric, even though it is possible to gather and store them.

  14. Using EM Database Control, you discover that two application PL/SQL functions and a view are currently invalid. Which of the following might you use to fix these objects? (Choose two.)

    1. Shut down and restart the database.

    2. Use EM Database Control to recompile the object.

    3. Export the invalid objects, drop them, and then import them.

    4. Use the ALTER FUNCTION ... COMPILE and ALTER VIEW ... COMPILE commands.

  15. You have just created a database using scripts that you wrote. Now you notice that the automatic collection of database statistics by the EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_ PROCS procedure is not running. What might be the cause?

    1. The PFILE/SPFILE parameter GATHER_STATS=FALSE.

    2. Only databases created using Database Configuration Assistant have automatic statistics collection enabled.

    3. The SYSMAN user who owns the AWR is not logged in.

    4. The operating system does not support automatic statistics collection.

  16. Which of the following is a performance metric that could be defined as "the amount of work that a system can perform in a given amount of time"?

    1. Response time

    2. Uptime

    3. Throughput

    4. Runtime

  17. Which of the following is not one of the three primary sources of performance metric information in the EM Database Control Performance screen?

    1. Host

    2. Session

    3. Instance

    4. Network

  18. By default, how long will database statistics be retained in the AWR?

    1. 7 days

    2. 30 days

    3. 7 hours

    4. Indefinitely

  19. Your users have called to complain that system performance has suddenly decreased markedly. Where would be the most likely place to look for the cause of the problem in the EM Database Control?

    1. Main screen

    2. Performance screen

    3. Administration screen

    4. Maintenance screen

  20. Using EM Database Control, you've identified that the following SQL statement is the source of a high amount of disk I/O:

    SELECT NAME, LOCATION, CREDIT_LIMIT FROM CUSTOMERS

    What might you do first to try to improve performance?

    1. Run the SQL Tuning Advisor.

    2. Run the SQL Access Advisor.

    3. Check the EM Database Control main screen for alerts.

    4. Click the Alert Log Content link in the EM Database Control main screen.

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

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