Incorrect answers b dbafreespace data dictionary view

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: a dictionary view identifies the location and the amount of free space, by tablespace name, file ID, starting block ID, bytes, and blocks. C: USER_TABLES view is used to show information about tables in user schema only. D: DBA_TABLES view is used to show information about all tables in the database, but it will not show the number of extents allocated to the EMPLOYEE table. E: DBA_TABLESPACERS view provides information about tablespaces, not extents or tables. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 352-353 Chapter 7: Managing the Physical Database Structure QUESTION 103: Which clause CANNOT be used with a CREATE PROFILE command? A. ACCOUNT_LOCK_TIME B. PASSWORD_LIFE_TIME C. PASSWORD_CHANGE_NEW D. FAILED_LOGIN_ATTEMPTS Answer: A. Explanation: Answer A is correct. It is not possible to use ACCOUNT_LOCK_TIME with a CREATE PROFILE command. Incorrect Answers: A: You can set PASSWORD_LIFE_TIME during creation profile. This parameter shows number of days a password will remain active. Default is 60. C: PASSWORD_CHANGE_NEW ca...
View Full Document

Ask a homework question - tutors are online