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 what partitioning is and what its benefit is.

Question Posted / guest

Answers were Sorted based on User's Feedback



Explain what partitioning is and what its benefit is...

Answer / guest

Partitioning is a method of taking large tables and indexes
and then splitting them into smaller and more manageable
pieces.


Regards
Abhinav Phadnis

Is This Answer Correct ?    3 Yes 0 No

Explain what partitioning is and what its benefit is...

Answer / ramesh

And the Advantage are
1.Maintaincace :-Can Take Partioned tables's tablespace
offline for recovery
while other partitions are still avialable to users
Hence the Avialability

2.Performace :As the Objects are plcaed in Diffrent
Tablespaces of Diffrent Servers/locations

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More DB Administration Interview Questions

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

what is asm?

0 Answers   Oracle,

what is the use of home directory???

1 Answers   HP,

Name a tablespace automatically created when you create a database.

5 Answers  

Name two files used for network connection to a database.

5 Answers  

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

What happens on checkpoint? : sql server DBA

0 Answers  

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers  

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

1 Answers  

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

What does coalescing a tablespace do?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories