Which of the following is the most probable use of an extent?

Options
- Stores user data within the database
- Stores rollback information used when data must be rolled back
- Minimize the amount of wasted (empty) storage
- both a and c

CORRECT ANSWER : Minimize the amount of wasted (empty) storage

Discussion Board
Extents

The most probable use of an extent is to minimize the amount of wasted (empty) space.

Extents : They are the building blocks of segments; in turn, they consist of data blocks. An extent is used to minimize the amount of wasted (empty) storage. As more and more data is entered into tablespaces in your database, the extents used to store that data can grow or shrink as necessary. In this manner, many tablespaces can share the same storage space without preallocating the divisions between those tablespaces.

Segment : It has four types of segment they are:

1. Rollback segment : It stores rollback information used when data must be rolled back.
2. Data segment : It stores user data within the database.
3. Index segment : Stores indexes.
4. Temporary segment : Created when a SQL statement needs a temporary work area; these segments are destroyed when the SQL statement is finished. These segments are used during various database operations, such as sorts.

Prajakta Pandit 02-16-2017 10:46 PM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲