Exam 1z0-064 topic 1 question 1 discussion

Actual exam question from Oracle's 1z0-064

Question #: 1
Topic #: 1

Your database supports a mixed workload. The ERP application creates short sessions and performs small, random I/Os; the REPORTING application executes long-running DSS queries.
You want to set a priority for the workload generated by the ERP application and optimize resource usage for them.
Which three objectives can be achieved by the Resource Manager? (Choose three.)

A. limiting the amount of time that a session is idle and blocking other sessions of the ERP application
B. limiting the amount of undo generated by operations performed by sessions created by the ERP application
C. creating two resource plans with resource limits defined for the workload generated by the applications and automatically changing resource plans based on the workload
D. allocating a lower percentage of CPU to sessions used by the REPORTING application than to those used by the ERP application
E. limiting the physical I/O performed by the sessions or users of the ERP application that are connected to the database

Show Suggested Answer

Suggested Answer: BDE 🗳️

by adz07 at Jan. 31, 2024, 6:58 p.m.

Comments

Submit Cancel

adz07

1 year ago

Selected Answer: ACD

i think ACD makes sense. all options are possible via resource manager, but if you are setting priority for ERP app, then limiting undo and physical IO of ERP app/users doesn't meet the goal (B, E) https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-resources-with-oracle-database-resource-manager.html#GUID-040A4CC4-B8B3-40F8-9984-FA79D46521BB

upvoted 1 times

...

Exam 1z0-064 All Questions

View all questions & answers for the 1z0-064 exam

Exam 1z0-064 topic 1 question 1 discussion

Comments

adz07

SY0-701