QUESTION 132- BIGFILE TABLESPACE/DEFAULT TABLESPACE

Examine these two statements: SQL> 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 three are true about the MRKT tablespace? (Choose three.)   A. The MRKT tablespace is created as a smallfile tablespace, because the file size is less than the minimum required for bigfile files. B. The MRKT tablespace may be dropped if it has no contents. C. Users who were using the old default tablespace will have their default tablespaces changed to the  MRKT tablespace. D. No more data files can be added to the tablespace. E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the  MRKT tablespace. Correct Answer: CDE  
上一篇:如何正确的删除表空间数据文件


下一篇:ORACLE数据库创建表空间及用户,删除表空间及用户等操作