单选题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 ru

题目

单选题

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?（）

Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles

Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS

Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile

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.

参考答案和解析

正确答案： A

解析：暂无解析

如果没有搜索结果，请直接联系老师获取答案。

更多相关问题

相关问题 1：

单选题What is the proper procedure to recover a lost tempfile?（）A Restore the backup copy of the tempfile from the backup media. B Re-create the tempfile with the create tempfile command. C Copy an existing tempfile from another database. D Re-create the tempfile with the create tablespace command. E Re-create the tempfile with the alter tablespace command.

点击查看答案
相关问题 2：

单选题After the recovery is complete， which command should you execute？（）A ALTER DATABASE OPEN；B ALTER DATABASE CLEAR LOGFILE；C ALTER DATABASE OPEN RESETLOGS；D ALTER DATABASE OPEN NORESETLOGS；

点击查看答案
相关问题 3：

单选题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 tempfilesB Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGSC Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfileD 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.

点击查看答案
相关问题 4：

单选题You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）A The instance would normally abort.B The instance would not be affected.C The instance would be invalid， so would have to be aborted.D The instance would remain open， but the LGWR process would fail.E The instance would remain open and would automatically create the missing file

点击查看答案
相关问题 5：

单选题You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）ASTARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；BSTARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；CSTARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；DSTARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；

点击查看答案
相关问题 6：

单选题RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A ’SQL ALTER DATABASE OPEN’；B SQL ALTER DATABASE ’OPEN’；C OPEN DATABASE；D DATABASE OPEN

点击查看答案
相关问题 7：

单选题What is the proper procedure to recover a lost tempfile？（）ARestore the backup copy of the tempfile from the backup media.BRe-create the tempfile with the create tempfile command.CCopy an existing tempfile from another database.DRe-create the tempfile with the create tablespace command.ERe-create the tempfile with the alter tablespace command.

点击查看答案

OCP 11G认证考试

单选题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 ru

题目

参考答案和解析

更多相关问题

相关问题 1：

相关问题 2：

相关问题 3：

相关问题 4：

相关问题 5：

相关问题 6：

相关问题 7：

相关内容