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.
There are 2 types of segment space management
1.Manual
2.Auto
In manual segment space management MANUAL,Oracle will use freelists to manage free space within segments in the tablespace. Free lists are lists of data blocks that have space available for inserting rows.
SEGMENT SPACE MANAGEMENT AUTO tells Oracle to use bitmaps to manage free space within a segment. The bitmap structure stores information that describes the amount of space in the blocks that are available.
for row inserts.
The extent management will be AUTOALLOCATE (extent sizes defined and managed by Oracle) because a default storage clause is not be specified.