1z0-062 Exam QuestionsBrowse all questions from this exam

1z0-062 Exam - Question 21


Which two statements are true about extents? (Choose two.)

Show Answer
Correct Answer: BC

Data blocks in an extent are logically contiguous but can be non-contiguous on disk, meaning they are logically linked but physically might be scattered. The blocks of a newly allocated extent, although free, may have been used before, indicating that the space might have been previously used and is now available again. These characteristics fit the typical behavior of extents in databases.

Discussion

2 comments
Sign in to comment
khan
Apr 7, 2019

Answer BC https://docs.oracle.com/database/121/CNCPT/logical.htm#CNCPT1063 Deallocation of Extents: In general, the extents of a user segment do not return to the tablespace unless you drop the object using a DROP statement. For example, if you delete all rows in a table, then the database does not reclaim the data blocks for use by other objects in the tablespace. You can also drop the segment using the DBMS_SPACE_ADMIN package.

_Cobra_
Apr 26, 2022

B & C is correct