Which three are true about the MRKT tablespace?

Examine these two statements:

Which three are true about the MRKT tablespace?

Examine these two statements:

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.



Leave a Reply 6

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


Sunil

Sunil

It should be B, C and D.

In a bigfile tablespace, there is only one datafile and you cannot add more datafiles.

Mahrukh Khan

Mahrukh Khan

Ans should be C,D and E. It’s not possible to drop default tablespace unless you specify new tablespace as a default tablespace

abc

abc

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>