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 run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  


Explain how you would restore a database using RMAN to Point in Time?

1 Answers  


What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  


What does coalescing a tablespace do?

1 Answers  


what are the performance views in an oracle rac environment?

0 Answers   Oracle,






Datapump backup steps?

1 Answers  


If we issue alter database begin backup. What happens to database?

2 Answers  


What is a correlated sub-query? : sql server DBA

0 Answers  


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers   Oracle,


what is ora 600?

1 Answers  


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

0 Answers  


Give two examples of how you might determine the structure of the table DEPT.

2 Answers  


Categories