Couchman p 439 440 chapter 9 managing database

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: ng Database Objects II QUESTION 100: You want to retrieve information about password expiration from the data dictionary. Which view do you use? A. DBA_USERS B. DBA_ROLES C. DBA_PASSWORDS D. V$PW_EXPIRATION Answer: A Explanation: 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. Incorrect Answers: 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 QUESTION 101: When creating a user, which profile is assigned automatically to the user if none is defined? A. None B. The SYSTEM profile C. The DE...
View Full Document

Ask a homework question - tutors are online