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.
The correct answer should be C, D, and E.
– A is incorrect because there is no minimum file size requirement for bigfile files.
– B is incorrect because MRKT can only be dropped when another tablespace is specified as the default tablespace of the database.