D it enables scotts currently disabled roles for the

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: led roles for the duration of this session. E. It disables Scott's currently-enabled roles for the duration of this session. Answer: C Explanation: Answer C is correct. Clause DEFAULT ROLE NONE of ALTER USER command makes all of the roles granted to Scott nondefault roles. Incorrect Answers: 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 QUESTION 99: 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 tables should...
View Full Document

Ask a homework question - tutors are online