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 functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

How would you determine who has added a row to a table?

4 Answers  

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

What is dbcc? : sql server DBA

0 Answers  

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  




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

2 Answers  

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

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

3 Answers  

For more DB Administration Interview Questions Click Here
Categories