Which three options would you choose?

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

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.
specify extent allocation as Automatic

B.
set segment space management to Automatic

C.
use the RESIZE clause while creating the tablespace

D.
set PCTFREE and PCTUSED to 50

E.
create the tablespace as smallfile tablespace

F.
specify extent allocation as Uniform

G.
create the tablespace as bigfile tablespace



Leave a Reply 2

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


Hamza AHmed from Pakistan,karachi

Hamza AHmed from Pakistan,karachi

correct answers : B,E,F