1Z0-062 · Question #180
Which three statements are true about windows? (Choose three.)
The correct answer is A. Only one window can be open at any given time C. Windows work with job classes to control resource allocation E. Windows can automatically start job or change resource allocation among jobs for various time periods. This question tests understanding of Oracle Scheduler windows, their exclusivity, relationship to resource plans and job classes, and their purpose in automating time-based job management.
Question
Which three statements are true about windows? (Choose three.)
Options
- AOnly one window can be open at any given time
- BConsumer groups are associated with windows
- CWindows work with job classes to control resource allocation
- DThe database service name must be provided during windows creation
- EWindows can automatically start job or change resource allocation among jobs for various time periods.
How the community answered
(63 responses)- A94% (59)
- B2% (1)
- D5% (3)
Why each option
This question tests understanding of Oracle Scheduler windows, their exclusivity, relationship to resource plans and job classes, and their purpose in automating time-based job management.
Oracle Scheduler enforces that only one window can be open (active) at any given time - if a higher-priority window opens while another is active, the lower-priority window is closed automatically.
Consumer groups are not directly associated with windows - windows are associated with resource plans, and it is resource plans that contain and manage consumer group directives.
Windows work with job classes to control resource allocation by associating a resource plan with the window; job classes specify a resource consumer group, and the active window's resource plan governs how resources are distributed among those groups.
The database service name is not a required attribute when creating a Scheduler window - required attributes are only the window name, schedule or start/end time, duration, and optionally a resource plan.
Windows can automatically activate at scheduled times to start jobs assigned to that window or to switch the active resource plan, enabling dynamic resource allocation changes throughout the day without manual DBA intervention.
Concept tested: Oracle Scheduler windows behavior and resource management
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/oracle-scheduler-concepts.html#GUID-F6F9D9DD-9B4B-4F84-A3A3-2A2B1C3E2A5F
Topics
Community Discussion
No community discussion yet for this question.