Oracle Exam 1Z0-067 Topic 11 Question 12 Discussion

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

Question #: 12
Topic #: 11

You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If the quota for these users is exceed during execution of a data manipulation language (DML) statement, the operation should abort and return an error. However, queries should still be allowed, even if users have exceeded the undo space limitation.

How would you achieve this?

AImplement a Database Resource Manager plan

BImplement a profile for these users

CDecrease the number of Interested Transaction List (ITL) slots for the segments on which these users perform transactions

DSpecify the maximum amount of quota a user can be allocated in the undo tablespace

Show Suggested Answer

Suggested Answer: A

by Kayleigh at May 08, 2022, 07:11 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-067 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!