nerdexam
Oracle

1Z0-064 · Question #39

1Z0-064 Question #39: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #39. The question stem and answer options stay visible for context.

Question

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.)

Options

  • Alimiting the amount of time that a session is idle and blocking other sessions of the ERP
  • Blimiting the amount of undo generated by operations performed by sessions created by the ERP
  • Ccreating two resource plans with resource limits defined for the workload generated by the
  • Dallocating a lower percentage of CPU to sessions used by the REPORTING application than to
  • Elimiting the physical I/O performed by the sessions or users of the ERP application that are

Unlock 1Z0-064 to see the answer

You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 1Z0-064 Practice