Which of the following helps the DBA to manage the tablespace as a single unit without taking into account the structure and size of the underlying datafiles?

Answer: D

Explanation: Answer option D is correct. A bigfile tablespace is a new type of tablespace introduced in Oracle 10g. It is also available in Oracle 11g. here can be only one file in a bigfile tablespace . The size of a bigfile tablespace file can be a aximum of 128 TB (terabytes) for a 32K block tablespace and 32 TB for an 8K block tablespace . dministrators must ensure that sufficient free disk space is available for a bigfile tablespace file o that it can be expanded whenever required. For the same reason, Oracle recommends that one make use of bigfile tablespace with Automatic Storage Management ASM), Oracle Managed Files (OMF), logical volumes that are dynamically extensible, or a logical olume manager that supports RAID. The biggest advantage of using a bigfile tablespace is that it s capable of running file alteration operations with no file name specification. bigfile tablespace must be created as locally managed, with automatic segment space anagement. This is the default and hence need not be specified in the DDL statement CREATE IGFILE TABLESPACE. On specifying either EXTENT MANAGEMENT DICTIONARY or EGMENT SPACE ANAGEMENT MANUAL, Oracle will report an error. o create a bigfile tablespace named btbs of 80G, the llowing DDL will be used: REATE BIGFILE TABLESPACE btbs ATAFILE '/or01/odata/orcl10g/btbs01.dbf' IZE 80G ote: The SIZE can be specified in kilobytes (K), megabytes (M), gigabytes (G), or terabytes (T). o determine whether a tablespace is a bigfile or not, the administrator can query any one of the following views: DBA_TABLESPACES USER_TABLESPACES V$TABLESPACE These all comprise a column known as BIGFILE that stipulates whether a tablespace is a bigfile or not.