Which task would you perform to reduce this overhead?

As a database administrator you spend a lot of time observing and setting various storage
parameter values for your application tables in order to gain performance benefits. Which
task would you perform to reduce this overhead?

As a database administrator you spend a lot of time observing and setting various storage
parameter values for your application tables in order to gain performance benefits. Which
task would you perform to reduce this overhead?

A.
Move the application tables to a tablespace with less space usage.

B.
Distribute the application tables across multiple tablespaces depending on usage.

C.
Export and Import the application tables a regular interval.

D.
Coalesce the application tables at a regular interval.

E.
Move the application tables to automatic segment space management tablespace.

F.
Drop and recreate the application tables at a regular interval.



Leave a Reply 1

Your email address will not be published. Required fields are marked *