多选题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 exten
题目
多选题
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?()
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