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 database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

Explain CREATE DATABASE syntax?

2 Answers  

What is the difference between LMT & DLT?

1 Answers   CTS,

How do you resize a data file?

2 Answers  

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

why we use cursors

1 Answers  

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

For more DB Administration Interview Questions Click Here
Categories