052-202(新增70题2018)

You want the size of the tablespace to increase when it is full.
Which option would you use?
A. use automatic extent allocation
B. disable threshold for the tablespace
C. use freelists to manage the free space
D. use automatic segment space management
E. create the tablespace as a bigfile tablespace
F. use the RESIZE clause while creating the tablespace
G. enable AUTOEXTEND for at least one of the data files in the tablespace
Answer: G

 "Enabling and Disabling Automatic Extension for a Data File"

Enabling and Disabling Automatic Extension for a Data File

You can create data files or alter existing data files so that they automatically increase in size when more space is needed in the database. The file size increases in specified increments up to a specified maximum.