Oracle Database 11g: Administration II
Question No: 421 – (Topic 13)
Which of these formats represents the correct hierarchy for the ADR?
None of the above
Answer: C Explanation:
The location of each ADR home is given by the following path, which starts at the ADR base directory:
diag/product_type/product_id/instance_id As an example,
product_id: DB_UNIQUE_NAME instance_id: SID
For example, for a database with a SID and database unique name both equal to orclbi, the ADR home would be in the following location:
Similarly, the ADR home path for the Oracle ASM instance in a single-instance environment would be:
ADR_base/diag/asm/ asm/ asm/
Question No: 422 – (Topic 13)
During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation.
How would this environment variable setting affect the installation?
The installation terminates with an error.
The installation proceeds with the default value without warnings and errors.
The installation proceeds with the default value but it would not be an OFA-compliant database.
The installation proceeds with the default value but a message would be generated in the alert log file.
Question No: 423 – (Topic 13)
View the Exhibit to examine the output for the V$DIAG_INFO view. Which statements are true regarding the location of diagnostic traces? (Choose all that apply.)
The path to the location of the background as well as the foreground process trace files is /u01/oracle/diag/ rdbms/orclbi/orclbi/trace.
The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.
The location of the trace file for the current session is
The location of the XML-formatted version of the alert log is
Question No: 424 – (Topic 13)
Which of the following is NOT an advantage of block media recovery (BMR)?
Datafiles remain offline while corrupt blocks are repaired.
Datafiles remain online while corrupt blocks are repaired.
A and C
Answer: B Explanation:
Overview of Block Media Recovery (link) Purpose of Block Media Recovery
You can use block media recovery to recover one or more corrupt data blocks within a data file. Block media recovery provides the following advantages over data file media recovery:
->Lowers the mean time to recover (MTTR) because only blocks needing recovery are restored and recovered
->Enables affected data files to remain online during recovery
Without block media recovery, if even a single block is corrupt, then you must take the data file offline and restore a backup of the data file. You must apply all redo generated for the data file after the backup was created. The entire file is unavailable until media recovery completes. With block media recovery, only the blocks actually being recovered are unavailable during the recovery.
Block media recovery is most useful for physical corruption problems that involve a small, well-known number of blocks. Block-level data loss usually results from intermittent, random I/O errors that do not cause widespread data loss, and memory corruptions that are written to disk. Block media recovery is not intended for cases where the extent of data loss or corruption is unknown and the entire data file requires recovery. In such cases, data file media recovery is the best solution.
Question No: 425 – (Topic 13)
View the Exhibit to examine the metrics with a threshold.
Which statement is true regarding the Number of Transactions (per second) metric?
Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.
The statistics for the metric values observed over the baseline time period are not examined to determine threshold values.
Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline.
The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero.
Question No: 426 – (Topic 13)
You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.
The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals:
SQLgt; EXECUTE DBMS_STATS.GATHER_TABLE_STATS(#39;SH#39;,#39;SALES#39;,GRANULARITY=gt;#39;GLOBAL#39;);
You need statistics to be collected more quickly. What can you do to achieve this?
Set DYNAMIC_SAMPLING to level 4.
Set the STATISTICS_LEVEL parameter to BASIC.
Set the INCREMENTAL value to TRUE for the partition table.
Increase the value of STALE_PERCENT for the partition table.
Answer: C Explanation:
Oracle will update the global table statistics by scanning only the partitions that have been changed instead of the entire table if the following conditions hold:
->INCREMENTAL value for the partitioned table is set to TRUE
->PUBLISH value for the partitioned table is set to TRUE;
->User specifies AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT and AUTO for GRANULARITY when gathering statistics on the table
If the INCREMENTAL value for the partitioned table was set to FALSE (default value), a full table scan is used to maintain the global statistics which is a much more resource intensive and time-consuming operation for large tables.
Question No: 427 – (Topic 13)
Which two statements are true regarding the SQL Repair Advisor? (Choose two.)
The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL
The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.
Answer: B,D Explanation:
You can run SQL Repair Advisor through the EM Support Workbench when an incident raised.
Or You run the SQL Repair Advisor by creating and executing a diagnostic task using the DBMS_SQLDIAG. CREATE_DIAGNOSIS_TASK and DBMS_SQLDIAG. respectively. The SQL Repair Advisor first reproduces the critical error and then tries to produce a workaround in the form of SQL patch.
Question No: 428 – (Topic 13)
Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion?
The database must be in read-write mode.
The database must have no external files.
The database must open in read-only mode.
The database must be mounted but not opened.
Question No: 429 – (Topic 13)
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
The ADR base keeps all diagnostic information in binary format
SQL*Plus provides the ADRI script, which can be used to work with ADR
The ADR can be used for problem diagnosis only when the database is open
The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
The ADR can be used for problem diagnosis even when the database instance is down
The ADR base is shared across multiple instances
Question No: 430 – (Topic 13)
In what view are you likely to see the following output?
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|