• Description:Oracle 9i 1z0-030 New Features for Administrators
• Passing Score:75%
• Practice Test - Number of questions:125 questions
• Simulation Test - Number of questions:125 questions
• Simulation Test Duration:41 minutes
• Has explanations:Yes

After changing the PCTFREE value of the automatic space management table EMPLOYEES, which task can you perform in order for your change to take affect immediately?

Answer(s)

1. Execute a full table scan of the EMPLOYEES table.
2. Execute the command ANALYZE TABLE employees COMPUTE STATISTICS.
3. Execute the command DBMS_STATS.GATHER_TABLE_STATISTICS on the EMPLOYEES table.
4. Execute the DBMS_REPAIR.SEGMENT_FIX_STATUS procedure on the EMPLOYEES table.

Execute the DBMS_REPAIR.SEGMENT_FIX_STATUS procedure on the EMPLOYEES table.