单选题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?（）
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.

相似考题

1.David ( ) on a new database at the moment.A. currently workB. is currently workingC. currently working

2.You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database.The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）A. Open the database in NORMAL modeB. Open the database in read-only modeC. Open the database in RESTRICTED modeD. Open the database with the RESETLOGS option

3. 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

4.You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）A. Mount the databaseB. Open the database in NORMAL modeC. Open the database in RESTRICTED modeD. Open the database with the RESETLOGS option

更多“The database is currently open and the temp03.dbf tempfile b”相关问题

  • 第1题：

    打开数据库abc的正确命令是（）

    • A、USE abc
    • B、USE DATABASE abc
    • C、OPEN abc
    • D、OPEN DATABASE abc

    正确答案:D

  • 第2题：

    Which command is used to open the database after an incomplete recovery？（）

    • A、 alter database open
    • B、 alter database open repairlog
    • C、 alter database open resetlogs
    • D、 alter database open resetlog
    • E、 alter database resetlogs open

    正确答案:C

  • 第3题：

    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.

    正确答案:E

  • 第4题：

    You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

    • A、Mount the database
    • B、Open the database in NORMAL mode
    • C、Open the database in RESTRICTED mode
    • D、Open the database with the RESETLOGS option

    正确答案:A

  • 第5题：

    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；

    正确答案:C

  • 第6题：

    Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）

    • A、 The queries that are currently executing will abort and an error message will be returned to the user.
    • B、 The queries that are currently executing will execute normally but future queries will not executed.
    • C、 Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.
    • D、 The currently executing and future queries will execute normally， but will be slower

    正确答案:D

  • 第7题：

    单选题
    You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）
    A

    The database would open normally.

    B

    The database would not open， and it would stop at mount stage.

    C

    The database would open after automatically performing instance recovery.

    D

    The database would not open， and you have to perform database recovery to open it.


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    Which command is used to open the database after an incomplete recovery？（）
    A

     alter database open

    B

     alter database open repairlog

    C

     alter database open resetlogs

    D

     alter database open resetlog

    E

     alter database resetlogs open


    正确答案： E
    解析： 暂无解析

  • 第9题：

    多选题
    Identify three valid methods of opening, pluggable databases (PDBs).（）
    A

    ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root

    B

    ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a pdb

    C

    ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed

    D

    ALTER DATABASE PDB OPEN issued from the root

    E

    ALTER DATABASE OPEN issued from that pdb 

    F

    ALTER PLUGGABLE DATABASE PDB OPEN issued from another pdb

    G

    ALTER PLUGGABLE DATABASE OPEN issued from that pdb


    正确答案： B,E
    解析： 暂无解析

  • 第10题：

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


    正确答案： A
    解析： 暂无解析

  • 第11题：

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


    正确答案： B
    解析： 暂无解析

  • 第12题：

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


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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

    正确答案:C

  • 第14题：

    In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file：  1.RESTORE CONTROLFILE；  2.RESTORE DATABASE；  3.ALTER DATABASE MOUNT；  4.SQL ALTER TABLESPACE temp ADD TEMPFILE  5.ALTER DATABASE OPEN RESETLOGS；  6.RECOVER DATABASE；  7.STARTUP NOMOUNT；  In what sequence would you use this process to perform the recovery？（）

    • A、 2， 7， 3， 5， 1， 6， 4
    • B、 2， 1， 7， 6， 3， 5， 4
    • C、 7， 1， 3， 2， 6， 5， 4
    • D、 7， 2， 3， 1， 4， 6， 5

    正确答案:C

  • 第15题：

    You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）

    • A、The database would open normally.
    • B、The database would not open， and it would stop at mount stage.
    • C、The database would open after automatically performing instance recovery.
    • D、The database would not open， and you have to perform database recovery to open it.

    正确答案:C

  • 第16题：

    Given the following RMAN commands，choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.（）   a. restore database  b. recover database  c. shutdown immediate  d. startup  e. restore archivelog all f. alter database open 

    • A、 a， b， c， d， e， f
    • B、 c， b， a， d， e， f
    • C、 c， b， a， d， f
    • D、 c， a， b， d
    • E、 c， a， e， b， d， f

    正确答案:E

  • 第17题：

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

    • A、  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；
    • B、  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
    • C、  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
    • D、  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

    正确答案:D

  • 第18题：

    Identify three valid methods of opening, pluggable databases (PDBs).（）

    • A、ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root
    • B、ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a pdb
    • C、ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed
    • D、ALTER DATABASE PDB OPEN issued from the root
    • E、ALTER DATABASE OPEN issued from that pdb 
    • F、ALTER PLUGGABLE DATABASE PDB OPEN issued from another pdb
    • G、ALTER PLUGGABLE DATABASE OPEN issued from that pdb

    正确答案:A,E,G

  • 第19题：

    单选题
    Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）
    A

     The queries that are currently executing will abort and an error message will be returned to the user.

    B

     The queries that are currently executing will execute normally but future queries will not executed.

    C

     Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.

    D

     The currently executing and future queries will execute normally， but will be slower


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file：  1.RESTORE CONTROLFILE；  2.RESTORE DATABASE；  3.ALTER DATABASE MOUNT；  4.SQL ALTER TABLESPACE temp ADD TEMPFILE  5.ALTER DATABASE OPEN RESETLOGS；  6.RECOVER DATABASE；  7.STARTUP NOMOUNT；  In what sequence would you use this process to perform the recovery？（）
    A

     2， 7， 3， 5， 1， 6， 4

    B

     2， 1， 7， 6， 3， 5， 4

    C

     7， 1， 3， 2， 6， 5， 4

    D

     7， 2， 3， 1， 4， 6， 5


    正确答案： A
    解析： 暂无解析

  • 第21题：

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


    正确答案： C
    解析： 暂无解析

  • 第22题：

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


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    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？（）
    A

      STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

    B

      STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；

    C

      STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；

    D

      STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；


    正确答案： A
    解析： 暂无解析

  • 第24题：

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


    正确答案： D
    解析： 暂无解析

相关内容