Oracle 11G OCP 1Z0-052 145

（145）Examine the commands executed in a DBA session:

CREATE BIGFILE TABLESPACE MRKT   DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING   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. 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）

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1224822/，如需轉載，請註明出處，否則將追究法律責任。