Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization
parameter to a nonzero value?
A. The MTTR advisor wil be disabled.
B. Automatic checkpoint tuning will be enabled.
C. The value for the LOG_CHECKPIONT_INTERVAL initialization parameter wil be override
the value for FAST_START_MTTR_TARGET.
D. The time taken to recover the instance after the crash is always exactly the same as the
value given for the FAST_START_MTTR_TARGET initialization parameter.
Answer(s): B, C
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD.
The default format of which two data types would be affected by this setting?
C. INTERVAL YEAR TO MONTH
D. INTERVAL DAY TO SECOND
E. TIMESTAMP WITH LOCAL TIME ZONE
Answer(s): B, E
Which two statements are true regarding the functionality of the remap command in ASMCMD?
A. It repairs blocks that have read disk I/O errors.
B. It checks whether the alias metadata directory and the file directory are linked correctly.
C. It repairs blocks by always reading them from the mirror copy and writing them to the original
D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate
location on disk if the blocks on the original location cannot be read properly.
Answer(s): A, D
What happens when you run the SQL Tuning Advisor with limited scope?
A. Access path analysis is not performed for SQL statements.
B. SQL structure analysis is not performed for SQL statements.
C. SQL Profile recommendations are not generated for SQL statements.
D. Staleness and absence of statistics are not checked for the objects in the query supplied to
the SQL Tuning Advisor.