This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ge related to DDL operations, regardless of whether the privilege was granted with
or without the ADMIN OPTION. Cascading effects can be observed when revoking a system
privilege related to a DML operation. For example, if SELECT ANY TABLE is granted to a
user, and if that user has created any procedures, then all procedures contained in the user's
schema must be reauthorized before they can be used again (after the revoke).
A: User B will lose the ALTER USER privilege.
C: The roles will remain and User B will not lose the ALTER USER privilege.
D: The roles will remain.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 485-489
Chapter 10: Managing Database Use
What are three examples of system privileges? (Choose three) Actualtests.com - The Power of Knowing 1Z0-023
D. CREATE TABLE
E. ALTER ANY INDEX
F. CREATE SESSION
Answer: D, E, F
Answers D, E and F are correct. CREATE TABLE, ALTER ANY INDEX, CREATE SESSION
are system privil...
View Full Document
- Fall '09