In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this?
A.
Setting a metric threshold
B.
Implementing Database Resource Manager
C.
Enabling resumable timeout for user sessions
D.
Decreasing the value of the IDLE_TIME resource limit in the default profile
B is the answer.
https://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN027
Limit the amount of time that a session can be idle. This can be further defined to mean only sessions that are blocking other sessions.
Idle Time Limit
You can specify an amount of time that a session can be idle, after which it is terminated. You can also specify a more stringent idle time limit that applies to sessions that are idle and blocking other sessions
It cannot be D because not all the users have the default profil as their profil.
A user can have an other profile as his default profil. So it won't have effect on that user.
So i think the answer is B
This section is not available anymore. Please use the main Exam Page.1z0-062 Exam Questions
Log in to ExamTopics
Sign in:
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.
khan
Highly Voted 6 years, 2 months agoSADIO
Highly Voted 3 years, 8 months agoPhoenix22
Most Recent 5 years, 3 months agosoniat
4 years, 4 months agoMamlouk_Med
6 years, 4 months agordnkrkmz
6 years, 5 months ago