QUESTION 132- BIGFILE TABLESPACE/DEFAULT TABLESPACE

Examine these two statements:

SQL> CREATE BIGFILE TABLESPACE MRKT 

DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M

LOGGING  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

Tablespace created.

SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;

Database altered.

Which three are true about the MRKT tablespace? (Choose three.)

 

A. The MRKT tablespace is created as a smallfile tablespace, because the file size is less than the minimum required for bigfile files.

B. The MRKT tablespace may be dropped if it has no contents.

C. Users who were using the old default tablespace will have their default tablespaces changed to the  MRKT tablespace.

D. No more data files can be added to the tablespace.

E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the  MRKT tablespace.

Correct Answer: CDE