What is the default setting for the STATISTICS_LEVEL initialization parameter?
BASIC
ALL
STANDARD
TYPICAL
None of the above
Which of the following would be used to set or change the value for DBIO_EXPECTED?
The DBIO_EXPECTED initialization parameter
The ALTER SYSTEM statement
The ALTER SESSION statement
All of the above will work.
None of the above will work.
Which of the following are types of problems that the ADDM will consider? (Choose all that apply.)
Database configuration issues
Concurrency issues
CPU bottlenecks
Suboptimal use of Oracle by an application
All of the above
The statistical data needed for ADDM to accurately diagnose problems is stored in which of the following areas?
Automatic Workload Repository (AWR)
Data dictionary
ADDM repository
PERFSTAT tables
None of the above
Which of the following is not a valid DBMS_ADVISOR procedure or function?
CREATE_TASK_SCRIPT
RESTART_TASK
INTERRUPT_TASK
RESUME_TASK
None of the above
In an RAC environment, which element(s) always uniquely identifies a snapshot?
INSTANCE_ID
CLUSTER_ID
SNAP_ID
Both A and C
A, B, and C
If the ASH buffer is filled in less than 30 minutes, which process is responsible for flushing it?
SMON
MMON
MMNL
PMON
AMON
Which are valid SCOPE settings for the SQL Tuning Advisor? (Choose all that apply.)
Full
Comprehensive
Detailed
Basic
Limited
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?
10
15
20
5
None of the above
Which of the following statements regarding the Automatic Tuning Optimizer (ATO) is incorrect?
The ATO generates more efficient execution plans than the query optimizer in normal mode.
The ATO is nothing more than the query optimizer in tuning mode.
The ATO can take a long time to process a SQL statement, especially when performing a comprehensive analysis.
The ATO does generate a SQL Profile when performing a limited analysis.
All the above statements are correct.
The AWR resides in which tablespace?
SYSTEM
TOOLS
SYSAUX
AWR
None of the above
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?
AUTO
CHOOSE
DETECT
AUTO_DEGREE
BEST_DEGREE
Which Oracle process updates the data dictionary with DML activity information gathered by the Automatic DML Monitoring feature?
SMON
PMON
MMNL
DMON
MMON
Which of the following views can be queried to display advisor findings?
V$ADVISOR_FINDINGS
DBA_ADV_FINDINGS
DBA_ADV_RECOMMENDATIONS
DBA_ADVISOR_FINDINGS
Findings can be viewed only through Enterprise Manager.
Which view shows the current AWR settings?
DBA_AWR_SETTINGS
DBA_AWR_CONFIG
DBA_HIST_WR_CONTROL
DBA_HIST_WR_SETTINGS
DBA_REPOSITORY
On an eight-CPU system with a Shared Pool size of 1GB, what size would the ASH buffer be set to?
8MB
16MB
50MB
32MB
32KB
__________ is a hash value that uniquely identifies a SQL statement in the database.
SQL_HASH
SQL_HASH_ID
SQL_ID
SID
SPID
Which package(s) can be used to interface with the SQL Tuning Advisor? (Choose all that apply.)
DBMS_ADVISOR
DBMS_SQL_TUNE
DBMS_SQLTUNE
DBMS_SQL_ADVISOR
DBMS_SQL_TUNE_ADV
On the Edit Thresholds screen in Oracle Enterprise Manager, what does it mean if the Select button is disabled for a specific metric?
The metric is disabled on the current instance.
The metric is stale.
The metric does not support multiple thresholds.
The threshold is locked and cannot be modified.
None of the above.