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

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

1 Answers  


how can you record information about current session?

1 Answers   Oracle,


Why would you call update statistics? : sql server DBA

1 Answers  


what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  


In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

1 Answers  


what is grd?

1 Answers   Oracle,


i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers   TCS,


What the different topologies in which replication can be configured? : sql server DBA

1 Answers  


What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1 Answers  


how can you generate profile of pl/sql applications to identify performance bottlenecks?

1 Answers   Oracle,


what is rebuild index??

2 Answers   IBM, Sapient,


Categories