Incorrect answers a optimal parameter needs to be

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: d, not just set to 500k size. B: This formula does not provide correct size for OPTIMAL parameter. C: This formula does not provide correct size for OPTIMAL parameter. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 374-375 Chapter 8: Managing Database Objects I QUESTION 126: A DBA grants User A the ALTER USER privilege with ADMIN OPTION. User A creates roles and grants the ALTER USER to User B. What will happen to the roles User A created, and also to User B's privileges, if you drop User A with CASCADE option? A. The roles will remain and User B will lose the ALTER USER privilege. B. The roles will remain and User B will not lose the ALTER USER privilege. C. The roles will be removed and User B will lose the ALTER USER privilege. D. The roles will be removed and User B will not lose the ALTER USER privilege. Answer: B Explanation: Answer B is correct. If you drop User A with CASCADE option, the roles will remain and User B will not lose the ALTER USER privilege. There are no cascading effects when revoking a system privile...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online