Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / guest

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

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

1 Answers  

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  

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

0 Answers   Oracle,

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  

If CPU is very slow What can u do to speed up?

1 Answers  

how can you process messages in order asynchronously?

0 Answers   Oracle,

when does an alert gets signaled?

0 Answers   Oracle,

what is difference between user managed backup and rman backup?

1 Answers   CTS,

Explain materialized views and how they are used.

0 Answers  

why we use cursors

1 Answers  

What purpose does the model database server? : sql server DBA

0 Answers  

Hot backup procedure?

2 Answers  

For more DB Administration Interview Questions Click Here
Categories