You executed the following command to create a tablespace called SALES_DATA:
SQL> CREATE TABLESPACE sales_data
DATAFILE SIZE 100M
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES_DATA tablespace? (Choose two)
A.
The database automatically determines the extent-sizing policy for the tablespace.
B.
The segments are automatically shrunk when the contents are removed from them.
C.
The allocation of extents within the tablespace is managed through the dictionary tables.
D.
The space utilization description of the data blocks in segments is recorded in bitmap blocks.
E.
The space utilization description of the data blocks in segments is managed through free lists.
I think that C is correct and A is wrong.
http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_7003.htm#SQLRF55629
Sorry, the A and D are correct, C is wrong.
Create a locally managed tablespace by specifying LOCAL in the EXTENT MANAGEMENT clause of the CREATE TABLESPACE statement. This is the default for new permanent tablespaces, but you must specify the EXTENT MANAGEMENT LOCAL clause if you want to specify either the AUTOALLOCATE clause or the UNIFORM clause. You can have the database manage extents for you automatically with the AUTOALLOCATE clause (the default), or you can specify that the tablespace is managed with uniform extents of a specific size (UNIFORM).