New Features for Administrators - Question 074

You created a database by using the Database Configuration Assistant. What must you do to access a user account in the sample schemas?

A. Create the user account and unlock the account.

B. Create the user account and define a password.

C. Unlock the user account and define a password.

D. Set the 07_DICTIONARY_ACCESSIBILITY parameter to TRUE.

Answer: D

Explanation:

To access a user account in the sample schemas you need to set the 07_DICTIONARY_ACCESSIBILITY parameter to TRUE. This enables anyone who had the ANY privilege to use this privilege on the Data Dictionary.

Incorrect Answers

A: You don’t need to create the user account and unlock the account.

B: You don’t need to create the user account and define a password.

C: You don’t need to unlock the user account and define a password.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 8-9

Chapter 1: Security Enhancements

Oracle 9i New Features, Robert Freeman, p. 146-147

Chapter 5: Miscellaneous Oracle9i Features and Enhancements