what is the view that provides all schedules ?
-
all_scheduler_schedules
-
all_scheduler_schedule
-
all_schedule_schedules
-
all the above
-
None
ALL_SCHEDULER_SCHEDULES is the correct view that provides all schedules accessible to the current user in Oracle Scheduler. Option B incorrectly uses singular 'schedule', and option C uses 'all_schedule_schedules' which is not a valid view name. Option D is incorrect since only option A is valid.
ALL_SCHEDULER_SCHEDULES is the actual Oracle data dictionary view that lists all schedule objects (created via DBMS_SCHEDULER.CREATE_SCHEDULE) accessible to the current user, including schedule name, start/end dates, and repeat interval. The other options are misspelled or non-existent view names (Oracle's naming convention is consistently ALL_SCHEDULER_*, not ALL_SCHEDULE_* or singular SCHEDULE), so only the properly named view is valid.