Multiple choice technology databases

What code modificaiton should be made to run the below code ? begin dbms_scheduler.create_job ( job_name => 'RUN_SHELL1', schedule_name => 'DEMO_SCHEDULE', job_type => 'EXECUTABLES', job_action => '/home/test/run_script.sh', enabled => true, comments => 'Run shell-script' ); end; /

  1. No change is required,job can be scheduled.

  2. Enabled option should be set to False.

  3. Job type should be changed to Executable

  4. Job type should be changed to Executable Block

  5. None
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Oracle DBMS_SCHEDULER, the parameter job_type must be 'EXECUTABLE' (singular) to run shell scripts. Using 'EXECUTABLES' (plural) is a syntax error, making changing the job type to 'Executable' the necessary modification.

Keep practicing — related questions