Unformatted text preview: led roles for the duration of this session.
E. It disables Scott's currently-enabled roles for the duration of this session.
Answer C is correct. Clause DEFAULT ROLE NONE of ALTER USER command makes all of
the roles granted to Scott nondefault roles.
A: All roles become nondefault, but they will not be revoked from Scott.
C: Command ALTER USER scott DEFAULT ROLES ALL make all of the roles granted to
Scott default roles.
D: A role can be enabled or disabled for use with SET ROLE, not ALTER USER command.
E: A role can be enabled or disabled for use with SET ROLE, not ALTER USER command.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 492-493
Chapter 10: Managing Database Use
You want to obtain information about all constraints on tables in the PROD user's schema,
Actualtests.com - The Power of Knowing 1Z0-023
including their status and what columns they invoke. You have access to all data dictionary
views, but you do not know the password for the PROD user. What two data dictionary
View Full Document
- Fall '09
- Oracle Database, Jason S. Couchman, DBA Certification Exam, Certification Exam Guide