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


How will you estimate the space required by a non-clustered
tables?

Answers were Sorted based on User's Feedback



How will you estimate the space required by a non-clustered tables?..

Answer / orawhiz

Calculate the total header size
Calculate the available dataspace per data block
Calculate the combined column lengths of the average row
Calculate the total average row size.
Calculate the average number rows that can fit in a block
Calculate the number of blocks and bytes required for the table.

After arriving the calculation, add 10 % additional space
to calculate the initial extent size for a working table.

Is This Answer Correct ?    0 Yes 0 No

How will you estimate the space required by a non-clustered tables?..

Answer / anil joshi

depend how much data this table hold
and data is static or dynamic
then define the table size whenever created

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Architecture Interview Questions

What is an Oracle Rollback Segment?

0 Answers  


What is a Multi-threaded Server Configuration?

1 Answers  


How will you monitor the space allocation ?

3 Answers  


What is Database Buffers ?

4 Answers  


what is ORACLE MEMORY STRUCTURES

3 Answers  


What is PGA?

5 Answers  


How will you create multiple rollback segments in a database ?

1 Answers  


Teradata: How can we know the indexed column in a table?

0 Answers   CTS, HSBC,


When does LGWR write to the database?

3 Answers  


What do Redo Log Buffers contain?

2 Answers  


Name the ORACLE Background Process?

3 Answers  


How the log writer writes the data into database

4 Answers   Baidu, Satyam,


Categories
  • Oracle General Interview Questions Oracle General (1809)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)