试题详情
多项选择题 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
  • 关注下方微信公众号,在线模考后查看

热门试题