1Z0-054 · Question #111
You observed that some of the queries are performing poorly on the SALES_RECORDS table in your database. On further investigation, you find that at the end of each day the contents of the…
The correct answer is B. Shrink the SALES_RECORDS table by using the ALTER TABLE...SHRINK SPACE command. See the full explanation below for the reasoning.
Question
You observed that some of the queries are performing poorly on the SALES_RECORDS table in your database. On further investigation, you find that at the end of each day the contents of the SALES_RECORDS table are transferred to the SALES table and deleted from the SALES_RECORDS table. The deleted operations cause the table to be sparsely populated. The SALES_RECORDS table has Automatic Segment Space Management (ASSM) and row movement enabled. The table is accessible in 24x7 mode. What is the most efficient method to improve the performance?
Options
- APerform EXPORT, DROP, and IMPORT operations on the SALES_RECORDS table sequentially.
- 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
How the community answered
(57 responses)- A2% (1)
- B81% (46)
- C5% (3)
- D12% (7)
Community Discussion
No community discussion yet for this question.