Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 381:

  Which of the following are NOT fundamental tasks of the Support Workbench? (Choose all that apply.)

  A. View long-running SQL workloads

  B. View problem details

  C. Gather additional diagnostic information

  D. Create a Service Request

  E. Clean up incident data after upload to Oracle Support

  Correct Answer: AE

  The Enterprise Manager Support Workbench (Support Workbench) is a facility that enables you to investigate, report, and in some cases, repair problems (critical errors), all with an easy-to-use graphical interface. The Support Workbench provides a self-service means for you to gather first- failure diagnostic data, obtain a support request number, and upload diagnostic data to Oracle Support with a minimum of effort and in a very short time, thereby reducing time-to-resolution for problems. The Support Workbench also recommends and provides easy access to Oracle advisors that help you repair SQL-related problems, data corruption problems, and more.

• Question 382:

  View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident? Exhibit:

  

  A. The incident has been newly created and is in the process of collecting diagnostic information.

  B. The incident is now in the Done state and the ADR can select the incident to be purged.

  C. The DBA is working on the incident and prefers that the incident be kept in the ADR.

  D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support.

  Correct Answer: D

• Question 383:

  In which two aspects does hot patching differ from conventional patching? (Choose two.)

  A. It consumes more memory compared with conventional patching.

  B. It can be installed and uninstalled via OPatch unlike conventional patching.

  C. It takes more time to install or uninstall compared with conventional patching.

  D. It does not require down time to apply or remove unlike conventional patching.

  E. It is not persistent across instance startup and shutdown unlike conventional patching.

  Correct Answer: AD

• Question 384:

  You executed the following commands:

  SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false; SQL> EXECUTE

  DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH','false');

  SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH', 'CUSTOMERS');

  Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

  A. The statistics are stored in the pending statistics table in the data dictionary.

  B. The statistics are treated as the current statistics by the optimizer for all sessions.

  C. The statistics are treated as the current statistics by the optimizer for the current sessions only.

  D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.

  Correct Answer: A

• Question 385:

  You executed the following PL/SQL block successfully:

  

  The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis ____.

  A. with the CPU Usage finding if it is less than 90

  B. without the CPU Usage finding if it is less than 90

  C. with the CPU Usage finding for snapshots below 90

  D. with the CPU Usage finding for snapshots not between 150 and 162

  Correct Answer: B

• Question 386:

  Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository? (Choose all that apply.)

  A. BACKGROUND_DUMP_DEST

  B. FOREGROUND_DUMP_DEST

  C. CORE_DUMP_DEST

  D. USER_DUMP_DEST

  E. DIAGNOSTIC_DEST

  F. All of the above

  Correct Answer: ACD

• Question 387:

  Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST?

  A. The default value is the value of the environment variable $ORACLE_HOME; if $ORACLE_HOME isn't set, then the default is set to $ORACLE_BASE.

  B. The default value is the value of the environment variable $ORACLE_BASE; if $ORACLE_BASE isn't set, then it is set to $ORACLE_HOME.

  C. DIAGNOSTIC_DEST is always equal to $ORACLE_HOME.

  D. DIAGNOSTIC_DEST is always equal to $ORACLE_BASE.

  Correct Answer: B

  The answer is not exact correct.

  If the ORACLE_BASE is not set, the default location is $ORACLE_HOME/log

• Question 388:

  Which of these formats represents the correct hierarchy for the ADR?

  A. /rdbms/diag//

  B. /diag/rdbms//

  C. /diag/rdbms//

  D. None of the above

  Correct Answer: C

  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_type: rdbms 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: ADR_base/diag/rdbms/orclbi/orclbi/

  Similarly, the ADR home path for the Oracle ASM instance in a single-instance environment would be: ADR_base/diag/asm/+asm/+asm/

• Question 389:

  Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in Oracle Database 11g? (Choose two.)

  A. A single ADR can support multiple ADR homes for different database instances.

  B. The alert files are stored in XML file format in the TRACE directory of each ADR home.

  C. If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is set to $ORACLE_BASE.

  D. The BACKGROUND_DUMP_DEST initialization parameter overrides the DIAGNOSTIC_DEST initialization parameter for the location of the alert log file.

  Correct Answer: AC

  The ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows:

  If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE. If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log

  Within ADR base, there can be multiple ADR homes, where each ADR home is the root directory for all diagnostic data--traces, dumps, the alert log, and so on--for a particular instance of a particular Oracle product or component. For example, in an Oracle Real Application Clusters environment with Oracle ASM, h database instance, Oracle ASM instance, and listener has an ADR home.

• Question 390:

  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?

  A. The installation terminates with an error.

  B. The installation proceeds with the default value without warnings and errors.

  C. The installation proceeds with the default value but it would not be an OFA-compliant database.

  D. The installation proceeds with the default value but a message would be generated in the alert log file.

  Correct Answer: D