1Z0-054 · Question #6
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 A. because it can be used during peak hours B. because it avoids unnecessary cursor invalidation D. because you have long-running queries that might span the shrink operation. 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. 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
How the community answered
(24 responses)- A79% (19)
- C8% (2)
- E13% (3)
Community Discussion
No community discussion yet for this question.