This preview shows page 1. Sign up to view the full content.
Unformatted text preview: FAULT profile
D. The RESOURCE_LIMIT profile
Answer C is correct. The DEFAULT profile will be assigned to user automatically to the user if
none is defined.
A: At least one profile will be assigned to user when creating a user.
B: There is no SYSTEM profile in Oracle
D: There is no RESOURCE_LIMIT profile in Oracle.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 492-493
Chapter 10: Managing Database Use
Which data dictionary view could you query to display the number of extents allocated to the
B. DBA_FREE _SPACE
Answer A is correct. DBA_EXTENTS view can be used to display the number of extents
allocated to the EMPLOYEE table. DBA_EXTENTS view gives information about the number
Actualtests.com - The Power of Knowing 1Z0-023
of extents allocated to a table, the datafiles in which they are stored, and how large each extent
B: DBA_FREE_SPACE dat...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09