Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 591:

  Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that apply.)

  A. ENABLE

  B. ENABLE_PROGRAM

  C. VALIDATE_PROGRAM

  D. SET_ATTRIBUTE

  E. SET_ENABLED

  Correct Answer: AD

  Refer to here.

  ENABLE Procedure, Enables a program, job, chain, window, or window group SET_ATTRIBUTE Procedure, Changes an attribute of a job, schedule, or other Scheduler object

• Question 592:

  A schedule defined entirely within the confines of a Scheduler job object is known as a (n) ________________.

  A. Fixed schedule

  B. Inline schedule

  C. Stored schedule

  D. Hard-coded schedule

  E. None of the above

  Correct Answer: B

  "A schedule defined within a job object is know as an inline schedule, where as an independent schedule object is referred to as a stored schedule. Inline schedules cannot be reference by any other objects. "

  http://www.datadisk.co.uk/html_docs/oracle/scheduler.htm

• Question 593:

  What is the default value for the ENABLED attribute of a job or program when it is created?

  A. TRUE

  B. FALSE

  C. There is no default. It must be defined at creation time.

  D. PENDING

  E. NULL

  Correct Answer: B

• Question 594:

  Which three statements are true regarding persistent lightweight jobs? (Choose three.)

  A. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.

  B. The user cannot set privileges on persistent lightweight jobs.

  C. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.

  D. Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.

  E. The use of a template is mandatory to create persistent lightweight jobs.

  Correct Answer: BCE

• Question 595:

  Which three components does the Scheduler use for managing tasks within the Oracle environment? (Choose three.)

  A. a job

  B. a program

  C. a schedule

  D. a PL/SQL procedure

  Correct Answer: ABC

  The Scheduler objects include:

  Programs Schedules Jobs Destinations Chains File Watchers Credentials Job Classes Windows Groups

• Question 596:

  Which three elements can a job chain process involve? (Choose three)

  A. an event

  B. a schedule

  C. a program

  D. another chain

  E. a lightweight job

  Correct Answer: BDE

  Don't really understand the answer so far.

  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

• Question 597:

  If two windows overlap, which window attribute will determine whether one should be chosen over the other?

  A. WINDOW_PRIORITY

  B. PRIORITY

  C. PRIORITY_LEVEL

  D. WINDOW_PRIORITY_LEVEL

  E. OVERLAP_RULE

  Correct Answer: A

• Question 598:

  How many different calendars does Oracle 11g support?

  A. 22

  B. 7

  C. 6

  D. 15

  E. 2

  Correct Answer: B

• Question 599:

  Which three statements are true about windows? (Choose three.)

  A. Only one window can be open at any given time

  B. Consumer groups are associated with windows

  C. Windows work with job classes to control resource allocation

  D. The database service name must be provided during windows creation

  E. Windows can automatically start job or change resource allocation among jobs for various time periods.

  Correct Answer: ACE

• Question 600:

  Which three statements are true about persistent configuration? (Choose three.)

  A. A user cannot set privileges on the persistent lightweight jobs

  B. Persistent lightweight jobs generate a large amount of metadata

  C. It is possible to create fully self-contained persistent lightweight jobs

  D. The use of a template is mandatory to create persistent lightweight jobs

  E. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time

  Correct Answer: ADE