103. You want to create a tablespace with the following specifications:
1. The tablespace extends automatically.
2. Used and free extents should be managed by bitmaps.
3. Default PCTUSED attribute is set to 60.
4. All the extents would be of size 1 MB.
Which three options would you choose to create the tablespace? (Choose three.)
A. tablespace with AUTOEXTEND enabled
B. tablespace with dictionary-managed extents
C. tablespace with a uniform extent allocation of 1 MB
D. tablespace with segment space management as manual
E. tablespace with segment space management as automatic
104. 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
Answer: ACD
Answer: BEF
我对tablespace with segment space management as manual和set segment space management to Automatic有疑问!请大家帮着讲下!