12.12. Review Questions

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

    1. SET_JOB_ARGUMENT_VALUE

    2. SET_JOB_VALUE_ANYDATA

    3. SET_JOB_ANYDATA_VALUE

    4. SET_SPECIAL_JOB_VALUE

    5. SET_JOB_ANYTYPE_VALUE

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

    1. ENABLE

    2. ENABLE_PROGRAM

    3. VALIDATE_PROGRAM

    4. SET_ATTRIBUTE

    5. SET_ENABLED

  3. Which of the following is not a valid calendaring syntax element?

    1. FREQ

    2. BYHOUR

    3. RUNDATE

    4. INTERVAL

    5. BYMINUTE

  4. Which Scheduler view(s) can be queried to see which jobs are currently executing? (Choose all that apply.)

    1. DBA_SCHEDULER_JOB_RUN_DETAILS

    2. DBA_SCHEDULER_RUNNING_JOBS

    3. DBA_SCHEDULER_CURRENT_JOBS

    4. DBA_SCHEDULER_JOBS

    5. DBA_SCHEDULER_EXECUTING_JOBS

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

    1. Fixed schedule

    2. Inline schedule

    3. Stored schedule

    4. Hard-coded schedule

    5. None of the above

  6. Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? (Choose all that apply.)

    1. SET_ATTRIBUTE_NULL

    2. ALTER_JOB

    3. ALTER_JOB_PARAMETERS

    4. ALTER

    5. SET_ATTRIBUTE

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

    1. TRUE

    2. FALSE

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

    4. PENDING

    5. NULL

  8. To set the history retention period for either window logging or job logging individually, which two parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?

    1. LOG_HISTORY

    2. JOB_LOG_RETENTION

    3. WINDOW_LOG_RETENTION

    4. WHICH_LOG

    5. LOG_NAME

  9. Consider the following code snippet: begin

    begin
dbms_scheduler.run_job('COLA_JOB',TRUE);
end;

    If this code were executed, which of the following statements would be true? (Choose all that apply.)

    1. The COLA_JOB job would be executed asynchronously.

    2. The COLA_JOB job would be executed synchronously.

    3. The COLA_JOB job would run in the user's current session.

    4. The COLA_JOB job would run with the FORCE option.

    5. The user could continue to issue SQL statements in the session while the COLA_JOB job was executing.

  10. Which of the following calendaring syntax expressions would evaluate to the last day of every month?

    1. FREQ = MONTHLY; BYMONTHDAY = 31

    2. FREQ = MONTHLY; BYMONTHDAY = −1

    3. FREQ = DAILY; BYDAY = −1

    4. FREQ = MONTHLY; BYDAY = 31

    5. FREQ = DAILY; BYMONTHDAY = LAST_DAY

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

    1. Update job log when a job completes

    2. Spawn and remove job slaves

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

    4. Query job table

    5. Pass job information to job slaves

  12. Which of the following objects can be directly referenced by a window object? (Choose all that apply.)

    1. Schedule object

    2. Program object

    3. Job object

    4. Resource plan

    5. Resource Consumer Group

  13. Which DBMS_SCHEDULER procedure is available for testing repeat intervals produced by calendaring syntax expressions?

    1. EVALUATE_REPEAT_INTERVAL

    2. VALIDATE_CALENDAR_EXPRESSION

    3. EVALUATE_CALENDAR_STRING

    4. VALIDATE_CALENDAR_STRING

    5. EVALUATE_INTERVAL_EXPRESSION

  14. 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?

    1. PLSQL_BLOCK

    2. JAVA_STORED_PROCEDURE

    3. STORED_PROCEDURE

    4. EXECUTABLE

    5. None of the above are invalid settings.

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

    1. Schedule objects

    2. Program arguments

    3. Job classes

    4. Job arguments

    5. All of the above

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

    1. The job will need to be re-enabled before it will execute again.

    2. The job may hold locks on objects referenced within the job.

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

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

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

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

    1. The job will be automatically disabled.

    2. The job will never execute.

    3. The job will attempt to execute, but will fail.

    4. The job will inherit the DEFAULT_SCHEDULE schedule.

    5. A schedule object cannot be disabled.

  18. When a job exceeds the date specified in its END_DATE attribute, which of the following will happen? (Choose all that apply.)

    1. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE.

    2. The job will be disabled if the value of the AUTO_DROP attribute is FALSE.

    3. The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE.

    4. All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUE.

    5. The STATE column of the job table will be set to COMPLETED for the job.

  19. Which view can you query to see information on Scheduler windows?

    1. DBA_WINDOWS

    2. DBA_SCHEDULER_WINDOWS

    3. DBA_WINDOW_OBJECTS

    4. DBA_SCHEDULER_WINDOW_OBJECTS

    5. DBA_ALL_SCHEDULER_WINDOWS

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

    1. WINDOW_PRIORITY

    2. PRIORITY

    3. PRIORITY_LEVEL

    4. WINDOW_PRIORITY_LEVEL

    5. OVERLAP_RULE

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset