Examine the commands executed in a DBA session:SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO; Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT; Database altered. Which two statements are trueregarding the MRKT tablespace()
- A、No more data files can be added to the tablespace.
- B、Segment space is managed by free lists in the tablespace.
- C、A user created without being assigned a default tablespace uses this tablespace.
- D、The tablespace can be dropped with the current setting with segments present in it
正确答案:A,C
答案解析:有
微信扫一扫手机做题