📚 Practice Mode

Database Stored Procedures, Triggers, and Job Scheduling

Learn at your own pace with hints and detailed explanations

1 / 20
Multiple Choice

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
Change Mode