Which argument of the INSERT_FINDING_DIRECTIVE allows you to specify a particular finding type to exclude from the ADDM analysis report?
The finding argument
When using the INSERT_FINDING_DIRECTIVE procedure, what is the result of specifying NULL for the TASK_NAME argument?
The directive will be for all ADDM tasks that are created after the procedure call.
To which value should you set the MEMORY_TARGET initialization parameter?
The sum of the values of the SGA_TARGET and PGA_AGGREGATE target parameters
If MEMORY_TARGET is set to a 600M, SGA_TARGET is set to 320M, and PGA_AGGREGATE_TARGET is not set, to what value is PGA_AGGREGATE_TARGET set?
280M (MEMORY_TARGET - SGA_TARGET)
To what value does MEMORY_TARGET default if it is not set?
A zero value
When Automatic Memory Management is activated, which four SGA memory parameters are not tuned automatically, but can be modified without shutting down the instance?
DB_KEEP_CACHE_SIZE, DB_RECYCLE_CACHE_SIZE, DB_nK_CACHE_SIZE, and SGA_TARGET
If you gather statistics on a table using GATHER_TABLE_STATS, specifying a GRANULARITY value of AUTO, and the INCREMENTAL value for the partitioned table is set to TRUE, will the entire table be scanned?
No, only new partitions and modified partitions will be scanned.
What is the result of calling the CREATE_EXTENDED_STATS function of the DBMS_STATS package to create a column group?
A virtual hidden column is created in the table
When does the optimizer recognize current statistics?
Immediately after they are captured and stored in the data dictionary
If MEMORY_TARGET is set to a nonzero value, what does the SGA_TARGET parameter represent?
The minimum size of the SGA
Before gathering statistics for a table using GATHER_TABLE_STATS, which action should you take to ensure the statistics are stored in a pending state and not published?
Call the SET_TABLE_PREFS procedure of the DBMS_STATS package, passing it a PUBLISH option of FALSE.
What does the value of the MEMORY_TARGET initialization parameter represent?
The total amount of memory that can be allocated to SGA and PGA memory structures
If MEMORY_TARGET is not set, to what value does MEMORY_MAX_TARGET default?
A zero value
Which built-in package can you use to help manage ADDM?
The DBMS_ADDM package
Which procedure of the DBMS_ADDM package should you use to view an ADDM analysis report?
The GET_REPORT procedure
After gathering pending statistics, which initialization parameter can you set to TRUE to force the optimizer to use pending statistics instead of current statistics?
The OPTIMIZER_USE_PENDING_STATS initialization parameter
When generating multicolumn statistics, which function of the DBMS_STATS package do you use to create the column group?
The CREATE_EXTENDED_STATS function
When gathering statistics for a table in Oracle 11g, which type of statistics allow you to indicate to the optimizer the selectivity of a function used as a SELECT statement predicate?
Expression statistics
Which procedure of the DBMS_ADDM package should you use to schedule an ADDM analysis for a specific database?
The ANALYZE_DB procedure
When gathering statistics using the GATHER_TABLE_STATS procedure, to which value does the INCREMENTAL value of a partitioned table default?
FALSE
By default, when does the optimizer recognize pending statistics?
After they are published using the DBMS_STAT.PUBLISH_PENDING_STATS procedure
With Oracle 11g, which option for the GATHER_*_STATS procedures allows you to specify a percentage threshold at which statistics are considered stale?
The STALE_PERCENT option
With Oracle 11g, which option for the GATHER_TABLE_STATS procedure allows you to specify that statistics on partitioned tables should be gathered incrementally and avoid capturing statistics for partitions that have had few modifications?
The INCREMENTAL option
When Automatic Memory Management is activated, which two SGA memory parameters are static and cannot be modified without shutting down the instance?
LOG_BUFFER
SGA_MAX_SIZE
What is the result of using the SET_TABLE_PREFS procedure to set the PUBLISH option for a specific table to FALSE?
The next statistics captured for the table using GATHER_TABLE_STATS will be pending statistics.
In which location are pending statistics stored?
In the data dictionary
After testing gathered pending statistics, which procedure of the DBMS_STATS package can you use to publish the statistics as current statistics?
The PUBLISH_PENDING_STATS procedure
For what purpose would you use the INSERT_FINDING_DIRECTIVE procedure of the DBMS_ADDM package?
To limit ADDM reporting to specific finding types
For what purpose would you use the INSERT_SEGMENT_DIRECTIVE procedure of the DBMS_ADDM package?
To suppress ADDM reporting for a specific schema, segment, subsegment, or object
When gathering statistics in Oracle 11g, which type of statistics allow you to indicate to the optimizer that two table columns specified in a WHERE clause are highly correlated?
Multicolumn statistics
If you omit the PUBLISH option when calling the GATHER_TABLE_STATS procedure of the DBMS_STATS package, are the statistics captured pending or current by default?
Current
If MEMORY_MAX_TARGET is set to a value greater than zero, to what value can MEMORY_TARGET be increased?
The value of MEMORY_MAX_TARGET
If MEMORY_TARGET is set to a nonzero value, how does Oracle allocate memory to SGA and PGA structures?
It automatically resizes the SGA and PGA as needed.
Which parameter, when set, prevents the use of the MEMORY_TARGET and MEMORY_MAX_TARGET initialization parameters?
The LOCK_SGA parameter
In Oracle 11g, which two types of extended statistics can you gather?
Multicolumn and expression statistics
Which function of the DBMS_STATS package can you use to compare pending and current statistics?
The DIFF_TABLE_STATS function
Which status value must a task have to successfully create a directive for it using the INSERT_FINDING_DIRECTIVE procedure?
