1Z0-052 · Question #220
You want the size of the tablespace to increase when it is full. Which option would you use?
The correct answer is G. enable AUTOEXTEND for at least one of the data files in the tablespace. Enabling AUTOEXTEND ON for a data file instructs Oracle to automatically expand that file when the tablespace runs out of free space, allowing the tablespace to grow without manual DBA intervention.
Question
You want the size of the tablespace to increase when it is full. Which option would you use?
Options
- Ause automatic extent allocation
- Bdisable threshold for the tablespace
- Cuse freelists to manage the free space
- Duse automatic segment space management
- Ecreate the tablespace as a bigfile tablespace
- Fuse the RESIZE clause while creating the tablespace
- Genable AUTOEXTEND for at least one of the data files in the tablespace
How the community answered
(38 responses)- A3% (1)
- D8% (3)
- E3% (1)
- G87% (33)
Why each option
Enabling AUTOEXTEND ON for a data file instructs Oracle to automatically expand that file when the tablespace runs out of free space, allowing the tablespace to grow without manual DBA intervention.
Automatic extent allocation (uniform size or system-managed) controls the size of extents granted to segments within the tablespace but does not increase the tablespace's total storage capacity when it is full.
Disabling space usage thresholds suppresses the alerts that Oracle sends when a tablespace reaches a fill percentage but does not add physical capacity or trigger any automatic growth.
Freelists are a legacy free-block tracking mechanism for segment inserts used in manual segment space management and have no relationship to tablespace-level sizing or auto-growth.
Automatic Segment Space Management (ASSM) replaces freelists with bitmaps to more efficiently manage free and used blocks within segments but does not affect the overall capacity or growth behavior of the tablespace.
Creating a tablespace as bigfile consolidates storage into a single large data file for manageability, but bigfile alone does not enable automatic growth - AUTOEXTEND must still be explicitly configured on the data file.
The RESIZE clause manually alters a data file to a specific new size in a one-time operation and does not configure any automatic growth behavior when the tablespace subsequently fills up.
AUTOEXTEND is a data file property set with AUTOEXTEND ON NEXT <size> MAXSIZE <limit> that causes Oracle to automatically increase the data file's size when a new extent cannot be allocated due to insufficient free space. At least one data file in the tablespace must have AUTOEXTEND enabled for the tablespace to grow dynamically, and the optional MAXSIZE clause caps how large the file can grow.
Concept tested: Oracle tablespace AUTOEXTEND data file auto-growth configuration
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-data-files-and-temp-files.html
Topics
Community Discussion
5
Prof. SaraJun 25, 2026G is your answer here, and the reasoning is straightforward once you see it. AUTOEXTEND tells Oracle to automatically grow a data file when the tablespace runs out of space, and because a tablespace is nothing more than a logical wrapper around one or more physical data files, enabling AUTOEXTEND on at least one of those files is what actually makes the tablespace grow. The other options address space management within existing allocated space, not the expansion of the tablespace itself. Automatic segment space management (D) controls how free space is tracked inside segments using bitmaps instead of freelists (C), and resizing (F) is a one-time manual operation, not an automatic growth mechanism. Remember the mnemonic AUTO GROWS FILES: AUTOEXTEND acts on the file level, and tablespace growth is a consequence of file growth.
Orla P.Jun 27, 2026The mnemonic is cute but worth anchoring to one extra detail: AUTOEXTEND on the file still needs a MAXSIZE ceiling set (or left UNLIMITED), because if MAXSIZE is hit the file stops growing and the tablespace is right back to throwing ORA-01653.
Brenda K.Jun 26, 2026G is the one, no debate. Setting AUTOEXTEND ON for a data file tells Oracle to grow that file automatically up to MAXSIZE when the tablespace runs out of room, which is exactly the behavior the question describes.
Orla P.Jun 26, 2026G is the one, AUTOEXTEND on a datafile lets the tablespace grow itself. Sat for 1Z0-052 back in 2011 and flagged this question thinking it was a trick, came back to it, remembered watching a dev's tablespace hit the ceiling in prod and the fix was always that one AUTOEXTEND flag on the file, not any of the space management options.
Brenda K.Jun 28, 2026Orla that real-world catch is dead-on, just clock-watch on this one because candidates often burn time second-guessing G when the wording "automatically extend" maps straight to AUTOEXTEND, so mark it and move on inside 45 seconds.