Examine the command:
SQL> CREATE TABLESPACE test1
DATAFILE ‘/u01/app/oracle/oradata/orc1/test01.dbf’ SIZE 5M
AUTOEXTEND ON UNIFORM;
Which statement is true? (Choose the best answer)
A.
The data file, TEST01.DBF, can be auto extended to a maximum size of 5M.
B.
The tablespace, TEST1, can contain a maximum of one data file.
C.
Allocated and free extents are tracked using bitmaps.
D.
Segment free space is tracked in the data dictionary.
Explanation:
C
uniform means extent management local instead of dictionary.
C
Lab result:
SQL> CREATE TABLESPACE test1
2 DATAFILE ‘/u01/app/oracle/oradata/orcl/test01.dbf’ SIZE 5M
3 AUTOEXTEND ON UNIFORM;
Tablespace created.
SQL> select tablespace_name, bigfile from dba_tablespaces
2 where tablespace_name=’TEST1′;
TABLESPACE BIGFILE
———- ———-
TEST1 NO
We created a smallfile tablespace, which can contain multiple data files
Database Administrator’s Guide
http://docs.oracle.com/database/121/ADMIN/tspaces.htm#ADMIN-GUID-5C916922-25BD-4140-A76D-08F3C0E68426
AUTOEXTEND ON are not only applied to smallfile tablespaces
……
Additionally, you can enable automatic file extension (AUTOEXTEND) to data files and bigfile tablespaces.
Database Administrator’s Guide
http://docs.oracle.com/database/121/ADMIN/tspaces.htm#ADMIN12490
so C is the Best answer