ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-063 All Questions

View all questions & answers for the 1z0-063 exam
Go to Exam

Exam 1z0-063 topic 1 question 113 discussion

Actual exam question from Oracle's 1z0-063
Question #: 113
Topic #: 1
[All 1z0-063 Questions]

For which two requirements would you use the Database Resource Manager?

  • A. limiting the CPU used per database call
  • B. specifying the maximum number of concurrent sessions allowed for a user
  • C. specifying the amount of private space a session can allocate in the shared pool of the SGA
  • D. limiting the degree of parallelism of operations performed by a user or group of users
  • E. specifying an idle time limit that applies to sessions that are idle and blocking other sessions
Show Suggested Answer Hide Answer
Suggested Answer: BE 🗳️
by edenzhang at April 21, 2020, 5:12 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
chitter
3 years, 1 month ago
https://vceguide.com/which-three-requirements-would-you-use-the-database-resource-manager/
upvoted 1 times
...
ErikJanssen
4 years, 2 months ago
I also agree on answer D and E. However answer A is also true because resource manager detects a session using exceeding CPU consumption (runaway quries, doc: https://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN-GUID). Answer B would apply to number of active sessions in a consumergroup before being queued, I believe.
upvoted 1 times
...
NorthKorean
5 years, 1 month ago
D,E confirmed
upvoted 1 times
...
edenzhang
5 years, 1 month ago
DE CORECT https://docs.oracle.com/cd/B28359_01/server.111/b28310/dbrm001.htm#ADMIN11843
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel