OCP CBT Question 585

Please solve the following question.

You are analyzing the `EMPLOYEES` table in the `HR` schema and notice that it has significant unused space due to numerous deletions and updates. You want to reclaim this space and reduce the high-water mark (HWM) for better performance and storage utilization. The table resides in an ASSM tablespace. Which sequence of actions is required to shrink the `EMPLOYEES` table segment?

sql-- Assume EMPLOYEES table exists and resides in an ASSM tablespace.-- The table is enabled for row movement.ALTER TABLE employees ENABLE ROW MOVEMENT;

ALTER TABLE employees SHRINK SPACE;

ALTER TABLE employees SHRINK SPACE CASCADE;

ALTER TABLE employees ENABLE ROW MOVEMENT; followed by ALTER TABLE employees SHRINK SPACE;

ANALYZE TABLE employees VALIDATE STRUCTURE CASCADE; followed by ALTER TABLE employees SHRINK SPACE COMPACT;