SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE
‘/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT 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.)
A.
A user created without being assigned a defaulttablespace uses this tablespace.
B.
Segment space is managed by free lists in thetablespace.
C.
No more data files can be added to thetablespace.
D.
Thetablespace can be dropped with the current setting with segments present in it.
The answer is:
A.
A user created without being assigned a default tablespace uses this tablespace.
C.
No more data files can be added to the tablespace.