Oracle Exam 1Z0-064 Topic 4 Question 4 Discussion

Actual exam question for Oracle's 1Z0-064 exam

Question #: 4
Topic #: 4

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 the UNDO tablespace.

You want to control the usage of the UNDO tablespace only for these user sessions.

How would you avoid the issue from repeating in future? (Choose the best answer.)

ACreate a profile for the users with the LOGICAL_READS_PER_SESSION and LOGICAL_READS_PER_CALL limits defined.

BCreate external roles to restrict the usage of the UNDO tablespace and assign them to the users.

CSet the threshold for UNDO tablespace usage for the users.

DImplement a Database Resource Manager plan by mapping the users to a resource consumer group with limits defined for UNDO tablespace usage.

Show Suggested Answer

Suggested Answer: D

by Loren at May 03, 2022, 01:28 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-064 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!