多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题