Which three statements regarding the bigfile tablespace (BFT) are correct? (Choose three)
A.
BFT can be dictionary managed.
B.
A BFT always contains a single file.
C.
BFT is supported for locally managed tablespaces.
D.
In BFT, the maximum file size ranges from 8 TB to 128 TB.
E.
BFT, when uses with Oracle Managed Files (OMF), provides complete data file transparency.
Explanation:
D: When the tablespace block size is 2k, then the maximum tablespace size will be 8 TB. When the tablespace block size is 32k, then the maximum tablespace size will be 128 TB.