Using oracle scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every friday. You want both the jobs to use a single resource plan, weekend_plan. Which task must have already been performed to enable you to achieve this objective?

A program must have been created with the WEEKEND_PLAN resource plan

A window must have been created with the WEEKEND_PLAN resource plan

A job class must have been created with the WEEKEND_PLAN resource plan

A window group must have been created with the WEEKEND_PLAN resource plan

Using oracle scheduler you have scheduled two jobs, JOB_A and JOB_B, t

1.	Using oracle scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every friday. You want both the jobs to use a single resource plan, weekend_plan. Which task must have already been performed to enable you to achieve this objective?
A.	A window must have been created with the WEEKEND_PLAN resource plan
B.	A program must have been created with the WEEKEND_PLAN resource plan
C.	A job class must have been created with the WEEKEND_PLAN resource plan
D.	A window group must have been created with the WEEKEND_PLAN resource plan
Answer» B. A program must have been created with the WEEKEND_PLAN resource plan

Discussion

No Comment Found

Related MCQs

In defining Application Services for Oracle Database 10g which Services describe applications, application functions, and data ranges as either functional services or data-dependent services?
In viewing information about the SGA which view Displays information about the amount of SGA memory available for future dynamic SGA resize operations?
Which is the correct parameter used for CREATE_PROGRAM?
What is used to execute STARTUP and SHUTDOWN commands while starting up a database?
Which attribute enables you to control the amount of logging in the Scheduler performs for setting the scheduler attribute?
In the platform-specific default location, Oracle Database locates your initialization parameter file by examining filenames in which of the following order?
What kind of an eventis raised when the Scheduler reacts to the event by starting a job and you can even create a schedule that references an event instead of containing date, time, and recurrence information?
Based on the existing program which way is used to CREATE_JOB?BEGINDBMS_SCHEDULER.CREATE_JOB (job_name => 'my_new_job3',program_name => 'my_saved_program1',schedule_name => 'my_saved_schedule1');END;
When a job is picked for processing, select the correct order in which job executes.1. Starts a database session as the owner of the job, starts a transaction, and then starts executing the job.2. Gathers all the metadata needed to run the job. As an example, arguments of the program and privilege information.3. Once the job is complete, the slave commits and ends the transaction.4. Closes the session
Which is the location of the Oracle Database that can store and manage files related to backup and recovery?

Using oracle scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every friday. You want both the jobs to use a single resource plan, weekend_plan. Which task must have already been performed to enable you to achieve this objective?

Discussion

No Comment Found

Related MCQs

Reply to Comment