Multiple choice technology databases

In which oracle verion scheduling concept is introduced ?

  1. Oracle 8

  2. Oracle 7

  3. Oracle 10g

  4. Oracle 9i

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

Oracle Scheduler (DBMS_SCHEDULER) was introduced in Oracle 10g. Prior versions used DBMS_JOB which had limited functionality. Oracle 7 and 8 had no built-in scheduler, and Oracle 9i still used the older DBMS_JOB package.

AI explanation

Oracle's advanced job scheduling framework, DBMS_SCHEDULER, was introduced in Oracle Database 10g (Release 1), replacing/extending the older, much simpler DBMS_JOB package that existed since early Oracle versions (including Oracle 8, which had only DBMS_JOB — no schedules, programs, job classes, windows, or chains). The 'scheduling concept' referenced in the question — with schedules, programs, and jobs as distinct first-class objects — is specifically the DBMS_SCHEDULER architecture, a 10g innovation later enhanced in 10g Release 2 (event-based jobs, job chains). Oracle 8 predates this entirely, so 'Oracle 8' is factually incorrect as the answer; 'Oracle 10g' is correct.

Keep practicing — related questions