READ Free Dumps For Oracle- 1z0-023
| Question ID 8761 | Which class of segments is most likely to cause the fragmentation in permanent tablespace?
|
| Option A | Index segments.
|
| Option B | Rollback segments.
|
| Option C | User data segments.
|
| Option D | Temporary segments.
|
| Option E | Data dictionary segments.
|
| Correct Answer | D |
Explanation Explanation/Reference: 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 database. Incorrect Answers: A: Index segments do not cause extensive fragmentation B: Rollback segments as temporary segments will experience high to very high fragmentation. This is true in the ROLLBACK tablespace because rollback segments have potentially a very short lifespan, and Oracle can allocate and deallocate extents as necessitated by long-running transactions. But lifespan of segments and extents in the TEMPORARY tablespace is much shorter, so fragmentation for temporary segments are higher. C: Data segments do not cause big fragmentation E: Data dictionary segments are not changed very often, they have long lifespan, so they can not cause fragmentation. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 354 Chapter 7: Managing the Physical Database Structure
| Question ID 8762 | Which data dictionary view shows the available free space in a certain tablespace?
|
| Option A | DBA_EXTENTS
|
| Option B | V$FREESPACE
|
| Option C | DBA_FREE_SPACE
|
| Option D | DBA_TABLESPACE
|
| Option E | DBA_FREE_EXTENTS
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct. DBA_FREE_SPACE view shows free space in a certain tablespace. Incorrect Answers: A: DBA_EXTENTS view gives information about the number of extents allocated to a table, the datafiles in which they are stored, and how large each extent is. B: V$FREESPACE view does not exist in Oracle. D: DBA_TABLESPACE view shows information about tablespaces, but it does not contain information about free space in the tablespace. E: DBA_FREE_EXTENTS view does not exist in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 401 Chapter 8: Managing Database Objects I