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.
again I have an issue with E
The use of a template is mandatory to create persistent lightweight jobs
what exactly is a “template”, does it mean a “program object” if this is the case then yes this answer is also correct, otherwise not.
i think it was in reference to job_template:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/schedadmin006.htm
The following example creates a set of lightweight jobs in one transaction:
DECLARE
newjob sys.job;
newjobarr sys.job_array;
BEGIN
— To create a lightweight job, the program must be enabled.
— The program action must be a PL/SQL block or stored procedure.
DBMS_SCHEDULER.ENABLE(‘PROG1’);
newjobarr := sys.job_array();
newjobarr.extend(5);
FOR i IN 1..5 LOOP
newjob := sys.job(job_name => ‘LWJOB’ || to_char(i),
job_style => ‘LIGHTWEIGHT’,
job_template => ‘PROG1’,
repeat_interval => ‘FREQ=MINUTELY;INTERVAL=3′,
start_date => systimestamp + interval ’10’ second,
enabled => TRUE
);
newjobarr(i) := newjob;
end loop;
DBMS_SCHEDULER.CREATE_JOBS(newjobarr, ‘TRANSACTIONAL’);
END;
/