Which three statements regarding the bigfile tablespace (BFT) are correct?

Which three statements regarding the bigfile tablespace (BFT) are correct? (Choose three)

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.



Leave a Reply 1

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


networkmanagers

networkmanagers

I choose BCD