AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


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
Description 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
Update Date and Time 2017-08-10 04:49:47

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
Description 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
Update Date and Time 2017-08-10 04:50:53