For your database some users complain about not being able to execute transactions. Upon
investigation, you find that the problem is caused by some users performing long- running
transactions that consume huge amounts of space in theUNDOtablespace. You want to
control the usage of theUNDOtablespace only for these user sessions. How would you avoid
the issue from repeating in future?(Choose the best answer.)
A.
Create a profile for the users with
theLOGICAL_READS_PER_SESSIONandLOGICAL_READS_PER_CALLlimits defined.
B.
Create external roles to restrict the usage of theUNDOtablespace and assign them to the
users.
C.
Set the threshold forUNDOtablespace usage for the users.
D.
Implement a Database Resource Manager plan by mapping the users to a resource
consumer group with limits defined forUNDOtablespace usage.
agree
Is this dump valid?
yes, it is, passed the exam lately
failed the exam after following the answers giving in this comment.
though the exam had new questions but more than 50% of the question is from this dump.
pls VASYA did u use the answers this comment.
I answered every question in this dump in the comments… the same answers I used in my exam.. but a few answers are wrong, I know
pls i need your help, i want to retake the exam and will very much appreciate it if u could send me a dump with correct answers. my email is [email protected] thanks!! VASYA.
Pls i really want to clear this exam. Contact me so we can chat much better will highly appreciate it.
I don’t have any dump,
All the questions are here in this site.
My answers you can find in comments.
I can hardly say more in email.
Of course this dump is the last step in exam preparation… first you have to carefully go through the followings guides
E55047-04
E49058-07
And I also cleared 1z0-054 and 1z0-117 a couple of years ago…
Hi , i failed on the exam to.
Its exactly that you say …. the exam had new questions but 50% is heare
But some questions has wrong answere
Have you passed exam.Comments are very contradictory here.
I can confirm this dump is 100% valid, I took the exam few days ago and had questions only from this dump, manly I used answers that are in this dump
Hello, Dave!
Did you use the answers from the dump or from the comments?
Thank you!
Did you use the answers from the dump or comments?
You can use the Oracle Database Resource Manager to establish user quotas for undo space. The Database Resource Manager directive UNDO_POOL allows DBAs to limit the amount of undo space consumed by a group of users (resource consumer group).
You can specify an undo pool for each consumer group. An undo pool controls the amount of total undo that can be generated by a consumer group. When the total undo generated by a consumer group exceeds its undo limit, the current UPDATE transaction generating the undo is terminated. No other members of the consumer group can perform further updates until undo space is freed from the pool.
When no UNDO_POOL directive is explicitly defined, users are allowed unlimited undo space.