Oracle
1Z0-064 · Question #27
1Z0-064 Question #27: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #27. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 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.