Which two statements are true about the SALES_DATA tablespace?

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.)

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 space utilization description of the data blocks in segments is recorded in bitmap blocks

B.
The segments are automatically shrunk when the contents are removed from them

C.
The space utilization description of the data blocks in segments is managed through free lists

D.
The allocation of extents within the tablespace is managed through the dictionary tables

E.
The database automatically determines the extent-sizing policy for the tablespace



Leave a Reply 1

Your email address will not be published. Required fields are marked *


networkmanagers

networkmanagers

Correct answer is AE