Tag: databases

Questions Related to databases

which is invalid funcion of scheduler ?

technology databases

  1. drop_job

  2. copy_job

  3. kill_job

  4. stop_job

  5. None

Show answer
Correct Option: C

what should be program type of a program that is of 'STORED PROCEDURE' ?

technology databases

  1. PLSQL_BLOCK

  2. EXECUTABLE

  3. STORED_PROCEDURE

  4. STORED_PROCEDURE_EXECUTABLE

  5. STORED_EXECUTABLE

Show answer
Correct Option: C

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; /

technology databases

  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

Show answer
Correct Option: C

In which oracle verion scheduling concept is introduced ?

technology databases

  1. Oracle 8

  2. Oracle 7

  3. Oracle 10g

  4. Oracle 9i

  5. None

Show answer
Correct Option: A

what is the view that provides the job history ?

technology databases

  1. all_scheduler_job_log_

  2. dba_scheduler_job_logs

  3. users_scheduler_job_log

  4. all the above

  5. None

Show answer
Correct Option: E

Which package in plsql provides scheduling ?

technology databases

  1. DBMS_SCHEDULER package

  2. DBMS_SCHEDULE package

  3. DBMS_JOB package

  4. Both A & C

  5. None

Show answer
Correct Option: D

Which are not valid views under concept of scheduling ?

technology databases

  1. All_scheduler_program_args

  2. dba_scheduler_job_run_details

  3. dba_scheduler_running_jobs

  4. dba_scheduler_program_args

  5. All the above

Show answer
Correct Option: E

what is the view that provides all schedules ?

technology databases

  1. all_scheduler_schedules

  2. all_scheduler_schedule

  3. all_schedule_schedules

  4. all the above

  5. None

Show answer
Correct Option: A

To run a job every Tuesday at 11:24 What could use in the following ?
technology databases

  1. FREQ=DAILY; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;

  2. FREQ=WEEKLY; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;

  3. FREQ=YEARLY; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;

  4. FREQ=YEAR; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;

  5. A,B and C options

Show answer
Correct Option: E

What funcion is used to kill a job scheduled in scheduler?

technology databases

  1. kill

  2. kill_job

  3. stop_job

  4. stop

  5. None

Show answer
Correct Option: C