Identify four uses of the Oracle Scheduler. (Choose four.)
A.
Enables you to set idle time limits for a resource plan.
B.
Enables you to schedule job execution based on time.
C.
Enables you to execute jobs in a clustered environment.
D.
Enables you to assign priorities to the consumer groups.
E.
Enables you to map a consumer group to an Oracle user.
F.
Enables you to create a job that makes use of saved programs and schedules.
G.
Enables you to periodically execute operating system script files located on the same server as the database.
Explanation:
A – FALSE. Isn’t a Oracle scheduler capability.
B – TRUE. Schedule job execution based on time or events. The most basic capability of a job scheduler is the ability to schedule a job to run at a particular date and time or when a particular event occurs.
C – TRUE. Execute and manage jobs in a clustered environment. A cluster is a set of database instances that cooperates to perform the same task. Oracle Real Application
Clusters (RAC) provides scalability and reliability without any change to your applications. The Scheduler fully supports execution of jobs in such a clustered environment. To balance the load on your system and for better performance, you can also specify the database service where you want a job to run. D – FALSE. The Scheduler activity is logged and information such as the status of the job and the
last run time of the job can be easily tracked, this way the DBA would track wich particular JOB time and statistics , not consumer groups.
E – FALSE. See D
F – TRUE. For example, consider the situation where a patch needs to be applied to a database that is in production. To minimize disruptions, this task will need to be performed during non-peak hours. This can be easily accomplished using the Scheduler. Instead of having IT personnel manually carry out this task during non-peak hours, you can instead create a job and schedule it to run at a specified time using the Scheduler.
G – TRUE. Application developers can create programs and program libraries that end users can use to create or monitor their own jobs. In addition to typical database jobs, you can schedule and monitor jobs that run as part of an application suite. REF.: Oracle(r) 10g Administrator Guide, 26-1 and 26-2