Oracle
1Z0-054 · Question #6
1Z0-054 Question #6: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #6. 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. You decided to use the ALTER TABLE...SHRINK SPACE COMPACT command to shrink the table. Why would you choose this method? (Choose all that apply.)
Options
- Abecause it can be used during peak hours
- Bbecause it avoids unnecessary cursor invalidation
- Cbecause it adjusts the high-water mark (HWM) immediately
- Dbecause you have long-running queries that might span the shrink operation
- Ebecause it does not allow any data manipulation language (DML) operations, thereby making the
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.