You are creating a locally managed tablespace to meet the following requirements:
All the extents should be of the same size.
The data should be spread across two data files.
A bitmap should be used to record the free space within the allocated extents.
Which three options would you choose? (Choose three.)
A.
set PCTFREE and PCTUSED to 50
B.
specify extent allocation as Uniform
C.
specify extent allocation as Automatic
D.
create the tablespace as bigfile tablespace
E.
create the tablespace as smallfile tablespace
F.
set segment space management to Automatic
G.
use the RESIZE clause while creating the tablespace
UNIFORM – specifies that the extent allocation in the tablespace is in a fixed uniform size
Traditional smallfile tablespaces, in contrast, can contain multiple datafiles, but the files cannot be as large.
Automatic free space management is only available in locally managed tablespaces. It uses bitmaps to describe the space usage of each block is within a segment.
The bitmap is stored in separate blocks known as bitmapped blocks (BMBS). This relieves the contention on the segment header that occurs with freelists.
IF file was small, then tablespace could have many of them. So SmallFile