Explain what partitioning is and what its benefit is.

Question Posted / guest

2 Answers
7529 Views
I also Faced
E-Mail Answers

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

internal architecture

0 Answers CSC,

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers CSC, Logica CMG,

Oracle 11g new features?

2 Answers

Datapump backup steps?

1 Answers

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers

what is meant by gateway

1 Answers IBM,

How to start SQL Server in minimal configuration mode?

1 Answers

What authentication modes does sql server support? : sql server DBA

0 Answers

How many memory layers are in the shared pool?

3 Answers

What is fill factor? : sql server DBA

0 Answers

why Datapump is faster than traditional export and import

4 Answers Mphasis,

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

2 Answers

For more DB Administration Interview Questions Click Here