[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-053 Dumps with VCE and PDF 441-450

2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: Administration II

Question No: 441 – (Topic 13)

You executed the following PL/SQL block successfully:

Ensurepass 2018 PDF and VCE

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


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

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

  3. with the CPU Usage finding for snapshots below 90

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

Answer: B

Question No: 442 – (Topic 13)

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.)






  6. All of the above

Answer: A,C,D

Question No: 443 – (Topic 13)

The environmental variable ORACLE_BASE is set. You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). View the Exhibit and note the various parameters set in your database.

What will be the location of the ADR base? Exhibit:

Ensurepass 2018 PDF and VCE

  1. It is set to ORACLE_BASE.

  2. It is set to ORACLE_HOME/log.

  3. It is set to /u01/app/oracle/admin/orcl/adump.

  4. It is set to /u01/app/oracle/flash_recovery_area.

Answer: A Explanation:

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


Question No: 444 – (Topic 13)

Which statement is true for enabling Enterprise Manager Support Workbench in Oracle

Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?

  1. The database must be running in ARCHIVELOG mode.

  2. No special setup is required, and the feature is enabled by default.

  3. The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.

  4. The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.

  5. Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.

Answer: E

Question No: 445 – (Topic 13)

An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?

  1. TEST_TBS is a small file tablespace.

  2. TEST_TBS is a bigfile tablespace (BFT).

  3. TEST_TBS is the default temporary tablespace.

  4. TEST_TBS is a dictionary-managed tablespace.

Answer: D

Question No: 446 – (Topic 13)

Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

  1. failures because a data file is renamed by error

  2. failures when no standby database is configured

  3. failures that require no archive logs to be applied for recovery

  4. failures due to loss of connectivity-for example, an unplugged disk cable

Answer: A,D

Question No: 447 – (Topic 13)

Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.)

  1. ADR diagnostic files

  2. all the optimizer statistics

  3. initialization parameter settings

  4. PL/SQL functions, procedures, and packages

  5. the table and index definitions and actual data

Answer: B,C,D Explanation:

The information gathered by SQL Test Case Builder includes:

->the query being executed,

->table and index definitions (but not the actual data),

->PL/SQL functions, procedures, and packages,

->optimizer statistics,

->and initialization parameter settings.

Question No: 448 – (Topic 13)

Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.)

  1. Generate reports on data failure such as data file failures.

  2. You can track the Service Request (SR) and implement repairs.

  3. You can package and upload diagnostic data to Oracle Support.

  4. You can manually run health checks to gather diagnostic data for a problem.

Answer: B,C,D

Question No: 449 – (Topic 13)

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

  1. It consumes more memory compared with conventional patching.

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

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

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

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

Answer: A,D

Question No: 450 – (Topic 13)

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

  1. View long-running SQL workloads

  2. View problem details

  3. Gather additional diagnostic information

  4. Create a Service Request

  5. Clean up incident data after upload to Oracle Support

Answer: A,E Explanation:

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.

100% Free Download!
Download Free Demo:1z0-053 Demo PDF
100% Pass Guaranteed!
Download 2018 EnsurePass 1z0-053 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 EnsurePass IT Certification PDF and VCE

Leave a Comment


Your email address will not be published. Required fields are marked *