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.

相关问题推荐

• You want to set the following initialization parameters for your database instance: LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch' LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY' Identify the statement that correctly describes this setting.（）

  A、The MANDATORY location must be a flash recovery area.

  B、The optional destinations may not use the flash recovery area.

  C、This setting is not allowed because the first destination is not set as MANDATORY.

  D、The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

  查看答案

• Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（）

  A、The shrink operation touches every block in the BOOKING table

  B、The high-water mark (HWM) for the BOOKING table is shifted from its original position

  C、The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table

  D、The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation

  查看答案

• If a log file becomes corrupted， it may cause the database to stall. How would you correct such a situation？（）  

  A、 Recover the online redo log from backup.

  B、 Delete and re-create the log file.

  C、 Use the alter database clear logfile command to clear the log file.

  D、 Shut down the database and restart it.

  E、 Shut down the database and then mount it. Clear the log file with the alter database clear logfile command and then restart the database with alter database open resetlogs.

  查看答案

• You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space.  You can use Segment Advisor to （）

  A、 identify the segments that you should shrink

  B、 modify the storage parameters for the tablespace

  C、 automatically shrink the segments with unused space

  D、 check the alerts generated for the tablespace that is running low on space

  查看答案

• Which two are the prerequisites to enable Flashback Data Archive？（）

  A

   Database must be running in archivelog mode.

  B

   Automatic undo management must be enabled.

  C

   Undo retention guarantee must be enabled.

  D

   The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management （ASSM）.

  查看答案