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

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-053.html

Oracle Database 11g: Administration II

Question No: 431 – (Topic 13)

What view might you use to try to determine how long a particular backup will take?

  1. V$SESSION_EVENT

  2. V$SESSION

  3. V$WAITS

  4. V$WAITSTAT

  5. V$SESSION_LONGOPS

Answer: E

Question No: 432 – (Topic 13)

Which two statements are true regarding the starting of the database instance using the following command? (Choose two.)

SQLgt;STARTUP UPGRADE

  1. It enables all system triggers.

  2. It allows only SYSDBA connections.

  3. It ensures that all job queues remain active during the upgrade process.

  4. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.

Answer: B,D

Question No: 433 – (Topic 13)

Choose the correct order to package and upload data for an incident to Oracle Support.

  1. Schedule, create new package, view manifest, view contents

  2. Create new package, view manifest, view contents, schedule

  3. Schedule, create new package, view contents, view manifest

  4. Create new package, view contents, view manifest, schedule

  5. None of the above.

Answer: D Explanation:

Ensurepass 2018 PDF and VCE

C:\Users\albo\Desktop\1-1.jpg

Question No: 434 – (Topic 13)

View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks. You executed the following commands:

SQLgt; VAR tname VARCHAR2(60); SQLgt; BEGIN

:tname := #39;my_instance_analysis_mode_task#39;; DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE(:tname,#39;Sg_directive#39;,#39;SCOTT#39;); END;

Which statement describes the consequence? Exhibit:

Ensurepass 2018 PDF and VCE

  1. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.

  2. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.

  3. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.

  4. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.

Answer: C Explanation:

sys@TEST1107gt; VAR tname VARCHAR2(60);

sys@TEST1107gt; BEGIN :tname := #39;my_instance_analysis_mode_task#39;;

  1. DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE(:tname,#39;Sg_directive#39;,#39;SCOTT#39;);

  2. END;

4 /

PL/SQL procedure successfully completed.

sys@TEST1107gt; SELECT DBMS_ADVISOR.GET_TASK_REPORT(:tname, #39;TEXT#39;, #39;ALL#39;) FROM

DUAL; ERROR:

ORA-13631: The most recent execution of task my_instance_analysis_mode_task contains no results.

ORA-06512: at quot;SYS.PRVT_ADVISORquot;, line 3189 ORA-06512: at quot;SYS.DBMS_ADVISORquot;, line 590

ORA-06512: at line 1 no rows selected

Question No: 435 – (Topic 13)

Which of the following tasks does the tool Incident Packaging Service (IPS) perform?

  1. Cleans up the ADR by deleting files not associated with an incident uploaded to Oracle Support.

  2. Identifies all files associated with a critical error and adds them to a zip file to be sent to Oracle Support.

  3. Automatically opens a Service Request with Oracle Support for each critical error and sends all relevant files.

  4. Displays a high-level view of critical errors on the database home page.

Answer: B Explanation:

Incident packaging service (IPS) and incident packages

The IPS enables you to automatically and easily gather the diagnostic data-traces, dumps, health check reports, and more-pertaining to a critical error and package the data

into a zip file for transmission to Oracle Support. Because all diagnostic data relating to a critical error are tagged with that error#39;s incident number, you do not have to search through trace files and other files to determine the files that are required for analysis; the incident packaging service identifies the required files automatically and adds them to the zip file.

Before creating the zip file, the IPS first collects diagnostic data into an intermediate logical structure called an incident package (package). Packages are stored in the Automatic Diagnostic Repository. If you choose to, you can access this intermediate logical structure, view and modify its contents, add or remove additional diagnostic data at any time, and when you are ready, create the zip file from the package. After these steps are completed, the zip file is ready to be uploaded to Oracle Support.

Question No: 436 – (Topic 13)

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

Exhibit:

Ensurepass 2018 PDF and VCE

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

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

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

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

Answer: D

Question No: 437 – (Topic 13)

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

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

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

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

    $ORACLE_BASE.

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

Answer: A,C 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

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, each database instance, Oracle ASM instance, and listener has an ADR home.

Question No: 438 – (Topic 13)

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

  1. The default value is the value of the environment variable $ORACLE_HOME; if

    $ORACLE_HOME isn#39;t set, then the default is set to $ORACLE_BASE.

  2. The default value is the value of the environment variable $ORACLE_BASE; if

    $ORACLE_BASE isn#39;t set, then it is set to $ORACLE_HOME.

  3. DIAGNOSTIC_DEST is always equal to $ORACLE_HOME.

  4. DIAGNOSTIC_DEST is always equal to $ORACLE_BASE.

Answer: B Explanation:

The answer is not exact correct.

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

Question No: 439 – (Topic 13)

Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g? (Choose all that apply.)

  1. Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository (ADR).

  2. The problem key is the same as the incident number.

  3. The database sends an incident alert to the Oracle Enterprise Manager Database Home page.

  4. Every problem has a problem key, which is a text string that describes the problem.

  5. The database makes an entry into the alert log file when problems and incidents occur.

Answer: C,D,E Explanation: Reference at here

Fault Diagnosability Infrastructure Overview

The fault diagnosability infrastructure aids in preventing, detecting, diagnosing, and resolving problems. The problems that are targeted in particular are critical errors such as those caused by code bugs, metadata corruption, and customer data corruption.

When a critical error occurs, it is assigned an incident number, and diagnostic data for the error (such as trace files) are immediately captured and tagged with this number. The data is then stored in the Automatic Diagnostic Repository (ADR)-a file-based repository

outside the database-where it can later be retrieved by incident number and analyzed. About Incidents and Problems

A problem is a critical error in a database instance, Oracle Automatic Storage Management (Oracle ASM) instance, or other Oracle product or component. Critical errors manifest as internal errors, such as ORA- 00600, or other severe errors, such as ORA-07445 (operating system exception) or ORA-04031 (out of memory in the shared pool). Problems are tracked in the ADR. Each problem has a problem key, which is a text string that describes the problem. It includes an error code (such as ORA 600) and in some cases, one or more error parameters.

An incident is a single occurrence of a problem. When a problem (critical error) occurs multiple times, an incident is created for each occurrence. Incidents are timestamped and tracked in the Automatic Diagnostic Repository (ADR). Each incident is identified by a numeric incident ID, which is unique within the ADR. When an incident occurs, the database:

->Makes an entry in the alert log.

->Sends an incident alert to Oracle Enterprise Manager (Enterprise Manager).

->Gathers first-failure diagnostic data about the incident in the form of dump files (incident dumps).

->Tags the incident dumps with the incident ID.

->Stores the incident dumps in an ADR subdirectory created for that incident.

Question No: 440 – (Topic 13)

Examine the following values of the initialization parameters in the database having the SID ORCL:

BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST=

The environment variables have the following value:

ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1

What is the location of the Automatic Diagnostic Repository (ADR) home?

  1. /u01/app/oracle/product/11.1.0/db_1

  2. /u01/app/oracle

  3. $ORACLE_HOME/bdump

  4. $ORACLE_HOME/log

Answer: B Explanation:

The Automatic Diagnostic Repository (ADR) is a directory structure that is stored outside of the database. It is therefore available for problem diagnosis when the database is down.

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.

Ensurepass 2018 PDF and VCE

C:\Users\albo\Desktop\1-1.jpg

100% Ensurepass Free Download!
Download Free Demo:1z0-053 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-053 Dumps

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

Leave a Reply

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