OCP 9 Intelligent Infrastructure Enhancements

The flashcards below were created by user Tralala on FreezingBlue Flashcards.

  1. Which procedure of the DBMS_RESOURCE_MANAGER package can you use to run the I/O Calibration tool to calibrate the I/O storage capabilities and estimate the maximum number of I/O requests and maximum latency time?
    The CALIBRATE_IO procedure
  2. To which value must the FILESYSTEMIO_OPTIONS initialization parameter be set to successfully run the CALIBRATE_IO procedure of the DBMS_RESOURCE_MANAGER package?
    Either ASYNCH or SETALL
  3. For a repeating baseline, what does MMON do with old baselines when it creates a baseline?
    Automatically removes it
  4. Which procedure of the DBMS_WORKLOAD_REPOSITORY package allows you to modify the window size for the system-defined moving window baseline?
  5. How must a lightweight job be created?
    Using a template
  6. Which input parameter of the CALIBRATE_IO procedure specifies the approximate number of physical disks in the database?
    The num_physical_disks parameter
  7. When using baseline templates, which process reviews the templates and creates the necessary baselines each night?
    The MMON process
  8. Which procedure of the DBMS_SCHEDULER package do you use to create a job template for generating lightweight jobs?
    The CREATE_PROGRAM procedure
  9. Which two views contain the status and results of running the CALIBRATE_IO procedure?
  10. What is the primary benefit of using a persistent lightweight job over a regular job?
    It creates less metadata, and reduces the time and redo required to start a job.
  11. Which column of the DBA_AUTOTASK_CLIENT view displays the percentage of maintenance resources for high priority maintenance tasks?
  12. Which action must you take to create the system-defined moving window baseline?
    None, it is created by default.
  13. What is the benefit of using baseline templates?
    The system will automatically generate baselines for future time periods.
  14. Which action must you take before you can set up AWR baseline metric thresholds for a specific baseline?
    Compute the baseline statistics.
  15. Significance Level thresholds are only supported by which type of metrics?
    Basic metrics
  16. Which four server-generated alerts are enabled by default?
    Snapshot Too Old, Tablespace Space Usage, Resumable Session Suspended, and Recovery Area Low on Free Space
  17. In which situation would it be most useful to use a persistent lightweight job?
    When you have users who are creating many jobs in a short period of time
  18. If you do not specify the JOB_STYLE argument when creating a job using the CREATE_JOB procedure, is a regular or lightweight job created by default?
    A regular job
  19. Which background process spawns the Autotask Background Process (ABP) when a maintenance window starts?
    The MMON process
  20. All predefined maintenance windows use which resource plan by default?
    The DEFAULT_MAINTENANCE_PLAN resource plan
  21. By default, when you create an Oracle 11g database, which default resource plans are activated?
    None, several default resource plans are created, but none is activated.
  22. Which initialization parameter must be set to TRUE to successfully run the CALIBRATE_IO procedure of the DBMS_RESOURCE_MANAGER package computing latency?
    The TIMED_STATISTICS parameter
  23. Can you set privileges for persistent lightweight jobs?
    No, they inherit them from their parent job template.
  24. Which output parameter of the CALIBRATE_IO procedure identifies the maximum number of I/O requests that can be sustained per second?
    The max_iops parameter
  25. In which tablespace does the Autotask Background Process (ABP) store task execution history?
    The SYSAUX tablespace
  26. Which process determines and prioritizes jobs that need to be created for each maintenance task, creates the jobs, and assigns them to Scheduler job classes?
    The Autotask Background Process (ABP)
  27. By default, which three tasks are executed as part of the Automated Maintenance Task?
    Optimizer statistics collection, Segment Advisor, and SQL Tuning Advisor
  28. What is the maximum number of calibrations that can run concurrently?
  29. Does performing I/O calibration positively or negatively affect running sessions?
  30. Which column of the DBA_AUTOTASK_CLIENT view displays the average elapsed time, in seconds, for maintenance task jobs?
    The MEAN_JOB_DURATION column
  31. Which initialization parameter setting enables baselines by default?
  32. To what value is the size of the default system-defined moving window baseline set by default?
    The size of the AWR retention time (eight days)
  33. Which procedure of the DBMS_ WORKLOAD_REPOSITORY package can you use to create a repeating baseline template?
  34. When resizing the system-defined moving window, what is the maximum value that can be specified?
    A value equal to the size of the AWR retention period
  35. On which two bases can single AWR baselines be specified?
    By either a specific snapshot range or a specific time period
  36. When creating a resource plan directive, which argument defines the amount of I/O (in MB) that a session can use?
    The SWITCH_IO_MEGABYTES argument
  37. What information can be displayed using the DBA_AUTOTASK_CLIENT view?
    Statistical data for each automated maintenance task
  38. Which two input parameters can you specify when calling the CALIBRATE_IO procedure?
  39. When creating an AWR baseline, to what value should you set the expiration to ensure the baseline expires?
    A value other than NULL
  40. By default, what percentage of resources is allocated to automated maintenance operations with the DEFAULT_MAINTENANCE_PLAN resource plan?
    25 percent
  41. To what does the term baseline refer?
    A set of AWR snapshots taken over time
  42. Which two actions do you take to resize the system-defined moving window?
    Increase the AWR retention period, and increase the number of days in the moving window.
  43. What do Significance Level thresholds use to determine when the threshold has been breached?
    Statistical relevance
  44. Which output parameter of the CALIBRATE_IO procedure identifies the average latency, based on the maximum number of sustainable I/O requests?
    The actual_latency parameter
  45. By default, which baseline is used to compute statistics with adaptive thresholds?
    The system-defined moving window baseline
  46. Which privilege must you have to successfully run the CALIBRATE_IO procedure of the DBMS_RESOURCE_MANAGER package?
    The SYSDBA privilege
  47. For what purpose is Resource Manager enabled during a maintenance window?
    So that a resource plan can be automatically enabled when the maintenance window opens, preventing maintenance tasks from consuming excessive resources
  48. Which argument of CREATE_JOB should you specify to create a lightweight job?
    The JOB_STYLE argument
Card Set:
OCP 9 Intelligent Infrastructure Enhancements
2013-04-15 13:15:02
OCP Intelligent Infrastructure Enhancements

OCP 9 Intelligent Infrastructure Enhancements
Show Answers: