This preview shows page 1. Sign up to view the full content.
Unformatted text preview: the role.
Answer B is correct. To revoke temporarily a role from a user, just disable the role.
A: Dropping table have nothing to do with revoking a role from a user.
C: By revoking the role from the user you will revoke it permanently, not temporarily.
D: You don't need to remove all privileges from the role to revoke temporarily a role from a
user, just disable role for user.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 492-493
Chapter 10: Managing Database Use
When creating rollback segments, what is considered the value for the OPTIMAL storage
C. Average undo size*4
D. This must be calculated by running the longest expected transaction and checking the size of
Actualtests.com - The Power of Knowing 1Z0-023
the rollback segment.
Answer D is correct. To calculate the OPTIMAL storage parameter you must use the longest
expected transaction, check the size of the rollback segment and use it for OPTIMAL parameter.
A: OPTIMAL parameter needs to be calculate...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09