Question 1 of 30
In a scenario where a company is experiencing performance issues due to multiple applications competing for database resources, the database administrator decides to implement the Database Resource Manager (DBRM). The administrator needs to prioritize a critical online transaction processing (OLTP) application over a less critical reporting application. Which approach should the administrator take to ensure that the OLTP application receives the necessary resources during peak usage times?
Create a resource plan that allocates a higher percentage of CPU and I/O resources to the OLTP consumer group while limiting the resources available to the reporting consumer group.
Set a fixed resource allocation for both applications to ensure they receive equal resources regardless of their priority.
Implement a time-based resource plan that only prioritizes the OLTP application during off-peak hours.
Use a workload management tool that randomly assigns resources to applications without considering their priority levels.

Preparing for Oracle Autonomous Database Cloud 2024 Professional? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free