Which two statements are true regarding the MRKT tablespace?

SQL> CREATE BIGFILE TABLESPACE MRKT2DATAFILE ‘/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING3EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;Tablespace created.SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;Database altered.Which two statements are true regarding the MRKT tablespace? (Choose two.)

Question:

Which two statements are true regarding the MRKT tablespace?

Options:

No more data files can be added to the tablespace.

Segment space is managed by free lists in the tablespace.

A user created without being assigned a default tablespace uses this tablespace.

The tablespace can be dropped with the current setting with segments present in it.

Correct Answer

The Correct Answer for this Question is

No more data files can be added to the tablespace.
A user created without being assigned a default tablespace uses this tablespace.