1Z0-064 · Question #27
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…
The correct answer is B. Shrink the SALES_RECORDS table by using the ALTER TABLE...SHRINK SPACE command. D. Deallocate the space in the SALES_RECORDS table by using the ALTER. See the full explanation below for the reasoning.
Question
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 24x7. Which two tasks would you recommend to improve the performance? (Choose two.)
Options
- APerform EXPORT, DROP, and IMPORT operations on the SALES_RECORDS table.
- BShrink the SALES_RECORDS table by using the ALTER TABLE...SHRINK SPACE command.
- CMove the SALES_RECORDS table to a different location by using the ALTER TABLE...MOVE
- DDeallocate the space in the SALES_RECORDS table by using the ALTER
- EMove the SALES_RECORDS table to a tablespace by using manual segment space
- FReorganize the SALES_RECORDS table online by using the DBMS_REDEFINITION package.
How the community answered
(17 responses)- A6% (1)
- B76% (13)
- C12% (2)
- E6% (1)
Community Discussion
No community discussion yet for this question.