You executed the following command to create a tablespace called SALES_DATA:SQL> CREATE TABLESPACE sales_dataDATAFILE SI
Posted: Wed Jun 07, 2023 6:12 am
You executed the following command to create a tablespace called SALES_DATA:SQL> CREATE TABLESPACE sales_dataDATAFILE 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.
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.