The optimizer statistics are collected automatically.
Only the timed operating system (OS) statistics and plan execution statistics are collected.
The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.
第1题:
Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future. What action would you take to achieve this task?()
第2题:
You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason, and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views, you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem?()
第3题:
In your running instance, some of the initialization parameters are set as shown below: SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET = 0 You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason?()
第4题:
You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?()
第5题:
Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action would you take to achieve this task?()
第6题:
In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What isthe impact of this setting()
第7题:
setting the STATISTICS_LEVEL parameter to TYPICAL
adding filters to the Automatic Database Diagnostic Monitor (ADDM)
enabling Automated Maintenance Task using Oracle Enterprise Manager
setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
第8题:
Set the STATISTICS_LEVEL initialization parameter to ALL.
Create a baseline on a pair of snapshots that have the statistics of the peakload period in the database.
Decrease the snapshot interval in the AWR to collect more number of snapshots during the peakload period.
Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid theautomatic purging of the snapshots.
第9题:
Optimizer statistics are collected automatically.
Only timed operating system (OS) statistics and plan execution statistics are collected.
The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
第10题:
The optimizer statistics are collected automatically.
Only the timed operating system (OS) statistics and plan execution statistics are collected.
The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.
第11题:
The STATISTICS_LEVEL initialization parameter is set to BASIC
The PGA_AGGREGATE_TARGET initialization parameter is set to zero.
The SGA_MAX_SIZE initialization parameter is set to less than 20 GB
The DB_CACHE_SIZE initialization parameter is set to less than 5 GB
The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.
第12题:
Optimizer statistics are collected automatically.
Only timed operating system (OS) statistics and plan execution statistics are collected.
The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
第13题:
In your database,the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?()
第14题:
Which setting enables the baselines by default in Oracle Database 11g?()
第15题:
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()
第16题:
Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?()
第17题:
in your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impactof this setting()
第18题:
Execute the query and view Active Session History (ASH) for information about the query.
Enable SQL trace for the query.
Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.
Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
第19题:
setting the STATISTICS_LEVEL parameter to TYPICAL
adding filters to the Automatic Database Diagnostic Monitor (ADDM)
enabling Automated Maintenance Task using Oracle Enterprise Manager
setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
第20题:
The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
第21题:
The advisory memory has been turned off.
The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.
第22题:
Set MEMORY_TARGET to zero
Set the STATISTICS_LEVEL parameter to BASIC
Set the WORKAREA_SIZE_POLICY parameter to MANUAL
Set the PGA_AGGREGATE_TARGET parameter to nonzero value
第23题:
The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
The optimizer can re optimize a query only once using cardinality feedback.
The optimizer enables monitoring for cardinality feedback after the first execution of a query.
The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.
第24题:
Every SQL statement in the STS is considered only once for execution.
The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.
The execution plan and execution statistics are computed for each SQL statement in the STS.
The effects of DDL and DML are considered to produce the execution plan and execution statistics.