Which three are true about the MRKT tablespace?
A.
The MRKT tablespace is created as a small file tablespace, because the file size is less than
the minimum required for big file 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.
Explanation:
incorrect:
Not A: To create a bigfile tablespace, specify the BIGFILE keyword of the CREATE TABLESPACE
statement (CREATE BIGFILE TABLESPACE …). Oracle Database automatically creates a locally
managed tablespace with automatic segment space management.
You can specify SIZE in kilobytes (K), megabytes (M), gigabytes (G), or terabytes (T).
Not D: Although automatic segment space management is the default for all new permanent,
locally managed tablespaces, you can explicitly enable it with the SEGMENT SPACE
MANAGEMENT AUTO clause.
It should be B, C and D.
In a bigfile tablespace, there is only one datafile and you cannot add more datafiles.
Ans should be C,D and E. It’s not possible to drop default tablespace unless you specify new tablespace as a default tablespace
B not correct as you cannot drop default tablespace
E is correct Rowids of Rows that belong to BFTs do not contain the relative file number.
http://www.dba-oracle.com/t_bigfile_tablespace_tips.htm
I think CDE
Answer is : CDE
SQL> create bigfile tablespace mrkt datafile ‘/oradata/CDB1/bogftbs01.dbf’ size 10M ;
Tablespace created.
SQL> alter database default tablespace mrkt;
Database altered.
SQL> drop tablespace mrkt ;
drop tablespace mrkt
*
ERROR at line 1:
ORA-12919: Can not drop the default permanent tablespace
SQL> alter tablespace mrkt add datafile ‘/oradata/CDB1/bigftbs02.dbf’ size 10M;
alter tablespace mrkt add datafile ‘/oradata/CDB1/bigftbs02.dbf’ size 10M
*
ERROR at line 1:
ORA-32771: cannot add file to bigfile tablespace
SQL> alter database default tablespace users;
Database altered.
SQL> drop tablespace mrkt including contents and datafiles
2 /
Tablespace dropped.
SQL>
CDE
CDE