Explain the difference between a data block, an extent and a
segment.

Answers were Sorted based on User's Feedback



Explain the difference between a data block, an extent and a segment...

Answer / wafa

data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings of contiguous data blocks are called extents. All the extents that an object takes when grouped together are considered the segment of the database object.

Is This Answer Correct ?    6 Yes 0 No

Explain the difference between a data block, an extent and a segment...

Answer / gaya

The oracle server manages the storage space in the datafiles
in units called oracle blocks or data blocks.

A segment is the space allocated for a specific logical
storage structure within a tablespace.

Space is allocated to a segment by extents.One or more
extents make up a segments.

Is This Answer Correct ?    6 Yes 7 No

Post New Answer

More DB Administration Interview Questions

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  


how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,


How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  


What is the difference between online backup & offline backup?

3 Answers   CSC,


What column differentiates the V$ views to the GV$ views and how?

3 Answers  


if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  


What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  


If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  


What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,


How can we know the exact updation date of a particular database?

2 Answers   Satyam,


what is the difference between db2start command and start database manager command?

1 Answers  


Categories