You observe that queries are performing poorly on theSALES_RECORDStable in your
database. On investigation, you find that at the end of each day the contents of
theSALES_RECORDStable are moved to theSALES_HISTORYtable. The delete
operations cause the table to be sparsely populated. TheSALES_RECORDStable 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.
PerformEXPORT, DROP, andIMPORToperations on theSALES_RECORDStable.
B.
Shrink theSALES_RECORDStable by using theALTER
TABLE…SHRINKSPACEcommand.
C.
Move theSALES_RECORDStable to a different location by using theALTER
TABLE…MOVEcommand.
D.
Deallocate the space in theSALES_RECORDStable by using theALTER
TABLE…DEALLOCATE UNUSEDcommand.
E.
Move theSALES_RECORDStable to a tablespace by using manual segment space
management.
F.
Reorganize theSALES_RECORDStable online by using
theDBMS_REDEFINITIONpackage.
B,D
I’d say B,F
BD
DEALLOCATE UNUSED – it will only release unused blocks above the high level mark.
Please crosscheck
DBMS_REDEFINITION has a very long list of restrictions so cannot be a yes answer with the lack of sufficient information about the problem table structure! So E is wrong! Not, to mention, I just need to claim space, not trying to alter any of the table storage settings!
ACE do not make any sense here! Out of context within the problem definition and conditions!
B is wrong, because a table must be accessible 24×7. We can use ALTER TABLE…SHRINK SPACE only with COMPACT option
probably correct B,F
Note: Chose B because the other options are even worse:)
BD
B,D