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

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,


How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  


How to make a replica of existing oracle server to another server?

3 Answers  


Explain CREATE DATABASE syntax?

2 Answers  


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,


What view would you use to determine free space in a tablespace?

3 Answers  


How to start SQL Server in minimal configuration mode?

1 Answers  


how to restore files with rman?

0 Answers  


What are the commands used in dcl? : sql server DBA

0 Answers  


what is the use of ocr?

0 Answers   Oracle,


currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  


What are the recovery models for a database? : sql server DBA

0 Answers  


Categories