Question 1 of 30
A database administrator notices that a frequently accessed table is experiencing performance issues due to fragmentation. The table has many small extents, which were created as data was inserted and deleted over time. What is the most effective approach for the administrator to optimize the storage structure of this table?
Reorganize the table to consolidate extents and reduce fragmentation.
Increase the block size for the table to allow for larger data storage.
Create additional indexes on the table to improve data retrieval speed.
Partition the table into smaller segments to enhance performance.

Preparing for Oracle Database Administration I? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free