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
Which clause CANNOT be used with a CREATE PROFILE command?
Answer A is correct. It is not possible to use ACCOUNT_LOCK_TIME with a CREATE
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
- Fall '09
- Oracle Database, Jason S. Couchman, DBA Certification Exam, Certification Exam Guide