When creating a tablespace,the ____ option allows creation of very large permanent or temporary tablespaces,with a single very large datafile.
A) EXTRAFILE
B) LARGEFILE
C) BIGFILE
D) HUGEFILE

Question

Quizplus · Accepted Answer

The option to create very large permanent or temporary tablespaces with a single very large datafile is the BIGFILE option. This allows for simplified management and improved performance for large database environments. The other options (EXTRAFILE, LARGEFILE, and HUGEFILE) are not valid options for creating a tablespace in Oracle databases.

When Creating a Tablespace,the ____ Option Allows Creation of Very