试题详情
单项选择题Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）

A、 DROP TABLESPACE temp1；

B、 DROP TABLESPACE temp1 INCLUDING CONTENTS；

C、 DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；

D、 DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；

  • C

  • 关注下方微信公众号，在线模考后查看

热门试题