A none b the system profile c the default profile d

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: FAULT profile D. The RESOURCE_LIMIT profile Answer: C Explanation: Answer C is correct. The DEFAULT profile will be assigned to user automatically to the user if none is defined. Incorrect Answers: 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 QUESTION 102: Which data dictionary view could you query to display the number of extents allocated to the employee table? A. DBA_EXTENTS B. DBA_FREE _SPACE C. USER_TABLES D. DBA_TABLES E. DBA_TABLESPACES Answer: A Explanation: 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 is. Incorrect Answers: B: DBA_FREE_SPACE dat...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online