Nobody owns a role in oracle incorrect answers a sys

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: t. Nobody owns a role in Oracle. Incorrect Answers: A: SYS user does not own any role in Oracle. C: SYSTEM user does not own any role in Oracle. D: The creator does not own a role he/she created. E: The grantee does not own a role he/she have been granted. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 490-495 Chapter 10: Managing Database Use QUESTION 13: Which class of segments is most likely to cause the fragmentation in permanent tablespace? A. Index segments. B. Rollback segments. C. User data segments. D. Temporary segments. E. Data dictionary segments. Answer: D Explanation: Answer D is correct. Temporary segments are used to handle sort operations that manipulate too much data to be sorted in memory. Oracle automatically allocates the space when needed. Once the sort operation is finished, Oracle again automatically deallocates the space. The lifespan of segments and extents in the TEMPORARY tablespace is incredibly short. Thus, by definition of usage and lifespan, the TEMPORARY tablespace will have the highest amount of fragmentation of any tablespace on your databas...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online