Which two tasks would you recommend to improve the perf…

You observe that queries are performing poorly on the SALES_RECORDS table in your database. On
investigation, you find that at the end of each day the contents of the SALES_RECORDS table are moved to the
SALES_HISTORY table. The delete operations cause the table to be sparsely populated.
The SALES_RECORDS table is created in a tablespace using Automatic Segment Space Management (ASSM)
and row movement is enabled. The table must be accessible 24×7.
Which two tasks would you recommend to improve the performance? (Choose two.)

You observe that queries are performing poorly on the SALES_RECORDS table in your database. On
investigation, you find that at the end of each day the contents of the SALES_RECORDS table are moved to the
SALES_HISTORY table. The delete operations cause the table to be sparsely populated.
The SALES_RECORDS table is created in a tablespace using Automatic Segment Space Management (ASSM)
and row movement is enabled. The table must be accessible 24×7.
Which two tasks would you recommend to improve the performance? (Choose two.)

A.
Perform EXPORT, DROP, and IMPORT operations on the SALES_RECORDS table.

B.
Shrink the SALES_RECORDS table by using the ALTER TABLE…SHRINK SPACE command.

C.
Move the SALES_RECORDS table to a different location by using the ALTER TABLE…MOVE command.

D.
Deallocate the space in the SALES_RECORDS table by using the ALTER TABLE…DEALLOCATE UNUSED
command.

E.
Move the SALES_RECORDS table to a tablespace by using manual segment space management.

F.
Reorganize the SALES_RECORDS table online by using the DBMS_REDEFINITION package.



Leave a Reply 0

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