Oracle Database Administration from Zero to Hero - Practice - Shrinking Segments

The video tutorial covers the process of table fragmentation and shrinking in a database environment. It begins with creating a testing table and indexes, followed by fragmenting the table and examining space statistics. The tutorial demonstrates how to shrink the table, analyze the impact on space, and rebuild indexes for better space management. Advanced techniques like deep fragmentation and table movement are also discussed. The session concludes with a summary and cleanup steps.

What is the initial step in the practice of fragmenting and shrinking tables?

• Deleting existing tables

• Connecting to the database as an admin

• Creating a testing table and indexes

• Running a defragmentation script

What is the purpose of the script created in the second section?

• To backup the database

• To create new indexes

• To display space statistics on the CUST table and its indexes

• To delete unnecessary data

Which database management feature allows shrinking of objects?

• Manual Segment Space Management

• Dynamic Space Allocation

• Automatic Segment Space Management (ASSM)

• Global Space Management

What is the result of making the table fragmented?

• Increase in total number of blocks

• Decrease in total number of rows

• No change in table size

• Increase in index sizes

What is the main target of defragmentation?

• To increase free space to a large percentage

• To reduce the total number of blocks

• To delete all data

• To increase the number of indexes

What is the impact of rebuilding indexes compared to shrinking them?

• Rebuilding has no impact

• Rebuilding increases index size

• Rebuilding deletes indexes

• Rebuilding saves more index space

What additional practice is suggested for deep fragmenting a table?

• Running a backup script

• Moving the table to a different tablespace

• Creating more indexes

• Deleting the table