Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 581:

  You notice that a job in a chain has not completed on a nonconstrained RAC database.

  Which of these are valid reasons why that might occur?

  A. The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.

  B. The job affinity is to a service and one node in that service is unavailable.

  C. The job affinity is to an instance and that instance is unavailable.

  D. There is no service affinity.

  E. None of the above.

  Correct Answer: C

• Question 582:

  Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.)

  A. It creates jobs without considering the priorities associated with them.

  B. It translates tasks into jobs for execution by the scheduler.

  C. It determines the list of jobs that must be created for each maintenance window.

  D. It is spawned by the MMON background process at the start of the maintenance window.

  E. It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.

  Correct Answer: BCD

  AutoTask Overview

  Oracle 11g added a new component to the Oracle automated task infrastructure, that began in Oracle 10g, called AutoTask. AutoTask provides a central component that is responsible for management of scheduled maintenance tasks.

  AutoTask Architecture

  AutoTask builds on much of the existing architecture of Oracle 10g. The AutoTask architecture consists of the following components:

  AutoTask Background Process (ABP) - APB is spawned by MMON and is responsible for managing the AutoTask features. It coordinates the AutoTask clients and the scheduler. It also maintains AutoTask related history that can be seen in

  the DBA_AUTOTASK_TASK view. AutoTask Clients - Automated maintenance tasks that are scheduled by AutoTask. Oracle 11g includes clients for statistics gathering, the Segment Advisor, and the Automatic SQL Tuning Advisor.

  The AutoTask Maintenance Windows - Individual maintenance windows exist for different days of the week.

  These windows can be modified as required.

  Resource Manager - A resource plan is enabled that is designed to limit the amount of resources that the AutoTask tasks can consume. This resource plan can be modified as required. OEM - You can manage the start time and duration of

  the various AutoTask maintenance windows and add or remove maintenance tasks with OEM. You can also use OEM to enable or disable maintenance tasks.

  The Scheduler - AutoTask operations rely heavily on the Scheduler. The AutoTask architecture uses scheduler windows and the scheduler infrastructure to execute AutoTask tasks.

• Question 583:

  Which two statements are true about a job chain? (Choose two.)

  A. A job chain can contain a nested chain of jobs.

  B. The jobs in a job chain cannot have more than one dependency.

  C. A job of the CHAIN type can be run using event-based or time-based schedules.

  D. The jobs in a job chain can be executed only by using the events generated by the Scheduler

  Correct Answer: AC

  Defining Chain Steps

  After creating a chain object, you define one or more chain steps. Each step can point to one of the following:

  A Scheduler program object (program)

  Another chain (a nested chain)

  An event schedule, inline event, or file watcher

  You define a step that points to a program or nested chain by using the DEFINE_CHAIN_STEP procedure.

  An example is the following, which adds two steps tomy_chain1:

  

• Question 584:

  What is the danger associated with stopping a running job by using the STOP_JOB procedure?

  A. The job will need to be reenabled before it will execute again.

  B. The job may hold locks on objects referenced within it.

  C. All jobs within the job group will also be stopped.

  D. The job may leave data in an inconsistent state.

  E. There is no danger in using the STOP_JOB procedure.

  Correct Answer: D

• Question 585:

  If a job references a schedule that has been disabled, what will be the result?

  A. The job will be automatically disabled.

  B. The job will never execute.

  C. The job will attempt to execute but will fail.

  D. The job will inherit the DEFAULT_SCHEDULE schedule.

  E. A schedule object cannot be disabled.

  Correct Answer: E

• Question 586:

  Which two statements correctly describe the relationship among the Scheduler components: job, program, and schedule? (Choose two)

  A. A job is specified as part of a program definition

  B. A program can be used in the definition of multiple jobs

  C. A program and job can be specified as part of a schedule definition

  D. A program and schedule can be specified as part of a job definition

  Correct Answer: BD

  Programs

  A program object (program) describes what is to be run by the Scheduler. A program includes:

  An action: For example, the name of a stored procedure, the name of an executable found in the operating system file system (an "external executable"), or the text of a PL/SQL anonymous block.

  A type: STORED_PROCEDURE, PLSQL_BLOCK, or EXTERNAL, where EXTERNAL indicates an external executable.

  Number of arguments: The number of arguments that the stored procedure or external executable accepts.

  A program is a separate entity from a job. A job runs at a certain time or because a certain event occurred, and invokes a certain program. You can create jobs that point to existing program objects, which means that different jobs can use the

  same program and run the program at different times and with different settings. With the right privileges, different users can use the same program without having to redefine it.

  Therefore, you can create program libraries, where users can select from a list of existing programs.

  If a stored procedure or external executable referenced by the program accepts arguments, you define these arguments in a separate step after creating the program. You can optionally define a default value for each argument.

  Oracle Scheduler

  Program objects (programs) contain metadata about the command that the Scheduler will run, including default values for any arguments. Schedule objects (schedules) contain information about run date and time and recurrence patterns.

  Job objects (jobs) associate a program with a schedule. To define what is executed and when, you assign relationships among programs, schedules, and jobs.

  A job is the combination of a schedule and a program, along with any additional arguments required by the program.

• Question 587:

  Which of the following tasks is not performed by the job coordinator?

  A. Update job log when a job completes

  B. Spawn and remove job slaves

  C. Write/read job info to/from memory cache

  D. Query job table

  E. Pass job information to job slaves

  Correct Answer: A

• Question 588:

  Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?

  A. PLSQL_BLOCK

  B. JAVA_STORED_PROCEDURE

  C. STORED_PROCEDURE

  D. EXECUTABLE

  E. None of the above are invalid settings.

  Correct Answer: B

  job_type

  Job action type ('PLSQL_BLOCK', 'STORED_PROCEDURE', 'EXECUTABLE', or 'CHAIN')

• Question 589:

  Which of the following Scheduler elements encourage object reuse? (Choose all that apply.)

  A. Schedule objects

  B. Program arguments

  C. Job classes

  D. Job arguments

  E. All of the above

  Correct Answer: ABD

  Don't really get the exact source of answer, just keep it in memory with common sense.

• Question 590:

  When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?

  A. SET_JOB_ARGUMENT_VALUE

  B. SET_JOB_VALUE_ANYDATA

  C. SET_JOB_ANYDATA_VALUE

  D. SET_SPECIAL_JOB_VALUE

  E. SET_JOB_ANYTYPE_VALUE

  Correct Answer: C