Multiple choice technology databases

Which package in plsql provides scheduling ?

  1. DBMS_SCHEDULER package

  2. DBMS_SCHEDULE package

  3. DBMS_JOB package

  4. Both A & C

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

Both DBMS_SCHEDULER (the modern scheduler from Oracle 10g) and DBMS_JOB (the older scheduling package still supported for backward compatibility) provide job scheduling functionality in PL/SQL. DBMS_SCHEDULE is not a valid package.

Keep practicing — related questions