052-233(新增70题2018)

Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option.

Which statement is correct in this scenario?

A. The operation would fail if tbs_1 were a read-only tablespace.

B. The operation would fail if tbs_1 were a read/write tablespace.

C. The operation would fail if tbs_1 were the default tablespace for the database.

D. If the above operation were successful, media recovery would be required to bring the tablespace online.

E. If the above operation were successful, instance recovery would be required to bring the tablespace online.

Answer: D

如果成功就会执行D选项，也有不成功的可能，比如是默认临时表空间和系统表空间，undo表空间

• ALTER TABLESPACE
  

OFFLINE IMMEDIATE 

If you specify IMMEDIATE, then Oracle Database does not ensure that tablespace files are available and does not perform a checkpoint. You must perform media recovery on the tablespace before bringing it back online.

• Taking Tablespaces Offline

 

转载于:https://www.cnblogs.com/Babylon/p/8621976.html