The database is currently open and the

The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）

A Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles
B Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS
C Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile
D Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.

参考答案

参考解析：

分类：OCP 11G认证考试题库

The project maintains a current and approved set of requirements over the life of the project by doing the following: .(73)all changes to the...

2、The Oracle Database 11g database is r

The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recov...

3、Your database is open and the LISTENER

Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl > STOPWh...

4、With a （） load the voltage and current

With a （） load the voltage and current are in phase.Apure resistanceBcapacitiveCinductiveDNone of the above

5、You opened the encryption wallet and

You opened the encryption wallet and then issued the following command:Then you closed the wallet. Later, you issued the following command to c...

6、The part of a fuse that melts and open

The part of a fuse that melts and opens the circuit is made of （）.Acopper and antimonyBsteel and babbittCaluminum or beryllium alloyDzinc or an alloy of tin and lead

编辑推荐

木排架的组立有哪些方法？..

企业与零售客户是卷烟供应链中两个位置相邻、地位等同的经营.....

空调系统最好的载冷剂是（）。..

什么叫二级设盲？什么叫二级揭盲？..

反射器的光学性能在入射角（）范围内应保持稳定，安装角度须.....

受体部位..