Oracle
1Z0-054 · Question #111
1Z0-054 Question #111: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #111. The question stem and answer options stay visible for context.
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
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.