OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043

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