This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ng Database Objects II
You want to retrieve information about password expiration from the data dictionary.
Which view do you use?
Answer A is correct. DBA_USERS view shows all information about users. It contains
username, Oracle-generated ID number, encrypted password, default and temporary tablespace
information, and the user profile that specified in the ID creation statements or any alteration that
Actualtests.com - The Power of Knowing 1Z0-023
may be followed. GRACE_DATE column identifies the date by which the user must change the
password or the account will be locked.
B: DBA_ROLES view is used to show information about roles, not about password expiration.
C: There is no DBA_PASSWORDS view in Oracle.
D: There is no V$PW_EXPIRATION view in Oracle
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 470-471
Chapter 10: Managing Database Use
When creating a user, which profile is assigned automatically to the user if none is defined?
B. The SYSTEM profile
C. The DE...
View Full Document
- Fall '09