单选题You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）AMOUNT modeBRESTRICTED modeCOPEN modeDNOMOUNT mode

题目
单选题
You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）
A

 MOUNT mode

B

 RESTRICTED mode

C

 OPEN mode

D

 NOMOUNT mode

相似考题

1.You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups.Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)A. Reregistering the target database in recovery catalogB. Transporting the new tablespaces to the recovery catalog databaseC. Syncronizing the recovery catalog with the target database control fileD. Performing a fresh backup of the target database to include the new data files in the catalog database

2.You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）A、 Whole databaseB、 TablespacesC、 DatafilesD、 Archive logsE、 Redo logs

3.You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）A、 The log sequence for the database will restart from 1.B、 The log sequence number will be written to the control file.C、 The log sequence number will be written to the datafile headers.D、 The log sequence number will be written to the initialization parameter file.

4. In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.  Which method must you use to recover the lost data？（）  A、 Complete Recovery with online redo logB、 Complete Recovery with archived redo logC、 Tablespace Point-in-Time Recovery （TSPITR）D、 Incomplete Recovery with system change number （SCN）

更多“You are performing an incomplete recovery because certain im”相关问题

  • 第1题：

    You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.（）

    • A、 Reregistering the target database in recovery catalog
    • B、 Transporting the new tablespaces to the recovery catalog database
    • C、 Syncronizing the recovery catalog with the target database control file
    • D、 Performing a fresh backup of the target database to include the new data files in the catalog database

    正确答案:C,D

  • 第2题：

    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

  • 第3题：

    You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)

    • A、Reregistering the target database in recovery catalog
    • B、Transporting the new tablespaces to the recovery catalog database
    • C、Syncronizing the recovery catalog with the target database control file
    • D、Performing a fresh backup of the target database to include the new data files in the catalog database

    正确答案:C,D

  • 第4题：

    You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）

    • A、 user managed complete recovery
    • B、 user managed incomplete recovery
    • C、 RMAN-based complete recovery
    • D、 RMAN-based incomplete recovery

    正确答案:D

  • 第5题：

    You have performed an incomplete recovery because some important user’s schema is dropped and purged from the Recycle Bin. The current logs are sequenced 1005 and 1006. After performing the recovery， you issued the following statement：   SQL>ALTER DATABASE OPEN RESETLOGS；   What will be the resultant log sequence numbers？（）

    • A、 0 and 1
    • B、 1 and 2
    • C、 1005 and 1006
    • D、 1006 and 1007

    正确答案:B

  • 第6题：

    多选题
    You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)
    A

    Reregistering the target database in recovery catalog

    B

    Transporting the new tablespaces to the recovery catalog database

    C

    Syncronizing the recovery catalog with the target database control file

    D

    Performing a fresh backup of the target database to include the new data files in the catalog database


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

  • 第7题：

    单选题
    You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）
    A

     The log sequence for the database will restart from 1.

    B

     The log sequence number will be written to the control file.

    C

     The log sequence number will be written to the datafile headers.

    D

     The log sequence number will be written to the initialization parameter file.


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

  • 第8题：

    单选题
    You have performed an incomplete recovery because some important user’s schema is dropped and purged from the Recycle Bin. The current logs are sequenced 1005 and 1006. After performing the recovery， you issued the following statement：   SQL>ALTER DATABASE OPEN RESETLOGS；   What will be the resultant log sequence numbers？（）
    A

     0 and 1

    B

     1 and 2

    C

     1005 and 1006

    D

     1006 and 1007


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

  • 第9题：

    单选题
    Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available.What would you do in this scenario？（）
    A

     recovery cannot be performed because a backup was not performed after the last incomplete recovery

    B

     restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday

    C

     restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday

    D

     restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday


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

  • 第10题：

    单选题
    Because of a logical corruption in your production database， you wanted to perform Tablespace Point in Time Recovery （TSPITR）. But before you start the recovery，you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects.  Which option must you use to perform TSPITR and preserve the object？（）
    A

     Perform Export before TSPITR and Import after TSPITR

    B

     Move objects to another schema that has the same tablespace assigned

    C

     Perform Incomplete Recovery before TSPITR with the Log Sequence Number （LSN）

    D

     Perform Incomplete Recovery before TSPITR with the System Change Number （SCN）


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

  • 第11题：

    单选题
    You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）
    A

     MOUNT mode

    B

     RESTRICTED mode

    C

     OPEN mode

    D

     NOMOUNT mode


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

  • 第12题：

    多选题
    You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.（）
    A

    Reregistering the target database in recovery catalog

    B

    Transporting the new tablespaces to the recovery catalog database

    C

    Syncronizing the recovery catalog with the target database control file

    D

    Performing a fresh backup of the target database to include the new data files in the catalog database


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

  • 第13题：

    You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）

    • A、 The target database must be in the MOUNT mode to ensure restoration of the datafiles.
    • B、 You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.
    • C、 The control file must be recreated.
    • D、 The database must be opened with the RESETLOGS option.

    正确答案:C

  • 第14题：

    You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）

    • A、 UNTIL CANCEL
    • B、 UNTIL SCN
    • C、 UNTIL SEQUENCE
    • D、 UNTIL TIME

    正确答案:A

  • 第15题：

    You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）

    • A、 by using the Flashback Database feature
    • B、 by using RMAN incomplete recovery
    • C、 by performing a user-managed incomplete recovery
    • D、 by dropping and re-creating the index tablespace

    正确答案:D

  • 第16题：

    You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）

    • A、 MOUNT mode
    • B、 RESTRICTED mode
    • C、 OPEN mode
    • D、 NOMOUNT mode

    正确答案:A

  • 第17题：

    单选题
    You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（）  RMAN>RUN  {   SET UNTIL SEQUENCE  THREAD ；   RESTORE DATABASE；   RECOVER DATABASE；  }
    A

     NOMOUNT

    B

     MOUNT

    C

     OPEN

    D

     RESTRICTED


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

  • 第18题：

    单选题
    You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）
    A

     user managed complete recovery

    B

     user managed incomplete recovery

    C

     RMAN-based complete recovery

    D

     RMAN-based incomplete recovery


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

  • 第19题：

    单选题
    Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）
    A

    Perform Export before TSPITR and Import after TSPITR

    B

    Move objects to another schema that has the same tablespace assigned

    C

    Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)

    D

    Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)


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

  • 第20题：

    单选题
    You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）
    A

     Whole database

    B

     Tablespaces

    C

     Datafiles

    D

     Archive logs

    E

     Redo logs


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

  • 第21题：

    单选题
    You are maintaining your database in ARCHIVELOG mode. An important table， SCOTT.EMPLOYEE， is dropped and purged from the Recycle Bin on Monday at 2：00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9：00 P.M. on Sunday.  How will you recover the dropped table， SCOTT.EMPLOYEE？（）
    A

     by using the Flashback Table feature

    B

     by using the Flashback Database feature

    C

     by performing incomplete recovery using RMAN utility

    D

     by performing incomplete recovery using user-managed recovery


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

  • 第22题：

    单选题
    You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）
    A

     UNTIL CANCEL

    B

     UNTIL SCN

    C

     UNTIL SEQUENCE

    D

     UNTIL TIME


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

  • 第23题：

    单选题
    You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）
    A

     The target database must be in the MOUNT mode to ensure restoration of the datafiles.

    B

     You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.

    C

     The control file must be recreated.

    D

     The database must be opened with the RESETLOGS option.


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

  • 第24题：

    单选题
    Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）
    A

    recovery cannot be performed because a backup was not performed after the last incomplete recovery

    B

    restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday

    C

    restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday

    D

    restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday


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

相关内容