Revoke the role from the user d remove all privileges

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: the role. Answer: B Explanation: Answer B is correct. To revoke temporarily a role from a user, just disable the role. Incorrect Answers: 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 QUESTION 125: When creating rollback segments, what is considered the value for the OPTIMAL storage parameter? A. 500k B. 10*MINEXTENTS 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 Explanation: 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. Incorrect Answers: A: OPTIMAL parameter needs to be calculate...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online