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...


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

How many packages we have in db

1 Answers   Tesco,


suppose you want to audit specific activities on sensitive data. How can you achieve that?

0 Answers   Oracle,


the process of adding a cpu in sql server is called..?

2 Answers   TCS,


When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  


How would you go about increasing the buffer cache hit ratio?

2 Answers  


Explain the concept of the DUAL table.

3 Answers  


i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,


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

0 Answers  


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

1 Answers   Oracle,


What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  


A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  


internal architecture

0 Answers   CSC,


Categories