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

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

相似考题

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.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 recoveryB、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 ThursdayC、restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on TuesdayD、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

3.In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）A、flash back the databaseB、perform point-in-time recoveryC、perform a full database recoveryD、drop and re-create the tablespaceE、use Recovery Manager （RMAN） to recover the database

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

更多“单选题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 num”相关问题

  • 第1题：

    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

  • 第2题：

    Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）

    • A、 The target database must be in NOARCHIVELOG mode.
    • B、 No backup is required of the database before you perform a TSPITR.
    • C、 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.
    • D、 If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.
    • E、 If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.

    正确答案:A,B

  • 第3题：

    You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）

    • A、 ONLINE
    • B、 REVERSE
    • C、 PARALLEL
    • D、 COMPRESS
    • E、 NOLOGGING
    • F、 COMPUTE STATISTICS

    正确答案:C,E

  • 第4题：

    You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario？（）

    • A、 You must ensure that the SALES database is mounted or open.
    • B、 You must restore a backup control file to perform a block media recovery.
    • C、 You must take the tools01.dbf data file offline before you start a block media recovery.
    • D、 You must put the database in NOARCHIVELOG mode to perform a block media recovery.
    • E、 You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.

    正确答案:A,E

  • 第5题：

    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

  • 第6题：

    单选题
    In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）
    A

    flash back the database

    B

    perform point-in-time recovery

    C

    perform a full database recovery

    D

    drop and re-create the tablespace

    E

    use Recovery Manager （RMAN） to recover the database


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

  • 第7题：

    单选题
    Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS  which statement is true？（）
    A

     You cannot perform the TSPITR with the constraints enabled.

    B

     You must perform the TSPITR recovery of both tablespaces for it to be successful.

    C

     You can perform TSPITR only on the USERS tablespace.

    D

     RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it  automatically.

    E

     The TSPITR will only be successful if the constraint is enabled.


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

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    多选题
    You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）
    A

    ONLINE

    B

    REVERSE

    C

    PARALLEL

    D

    COMPRESS

    E

    NOLOGGING

    F

    COMPUTE STATISTICS


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

  • 第10题：

    单选题
    Why should you back up a duplicated tablespace after a TSPITR is complete？（）
    A

     The tablespace cannot be duplicated or restored to any point in time after the duplication. 

    B

     The tablespace cannot be duplicated or restored to the point in time before the duplication. 

    C

     The entire database cannot be restored after a TSPITR， so a backup is required.

    D

     You cannot bring the tablespace online until its been backed up.

    E

     There is no requirement to do so， as RMAN will back up the tablespace after the TSPITR.


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

  • 第11题：

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

    B

     Complete Recovery with archived redo log

    C

     Tablespace Point-in-Time Recovery （TSPITR）

    D

     Incomplete Recovery with system change number （SCN）


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

  • 第12题：

    多选题
    You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario？（）
    A

    You must ensure that the SALES database is mounted or open.

    B

    You must restore a backup control file to perform a block media recovery.

    C

    You must take the tools01.dbf data file offline before you start a block media recovery.

    D

    You must put the database in NOARCHIVELOG mode to perform a block media recovery.

    E

    You can perform only a complete media recovery of individual blocks； point-in-time recovery of  individual data blocks is not supported.


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

  • 第13题：

    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 log
    • B、Complete Recovery with archived redo log
    • C、Tablespace Point-in-Time Recovery (TSPITR)
    • D、Incomplete Recovery with system change number (SCN)

    正确答案:C

  • 第14题：

    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 mode
    • B、Open the database in read-only mode
    • C、Open the database in RESTRICTED mode
    • D、Open the database with the RESETLOGS option

    正确答案:D

  • 第15题：

    An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace：   1. You log on to Enterprise Manager as SYSDBA.    2. You select the maintenance screen.    3. You choose Perform Recovery option on the maintenance screen.    4. You choose Whole Database in the Object Type drop-down list Perform Recovery： Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery： Type screen.    6. You provide the Host Credentials for a database user. on the Perform Recovery： Type screen.    7. You click the continue button.    An information screen appears saying that the database is unavailable. What is this information screen？（）

    • A、Recovery Manager
    • B、Recovery Window
    • C、Recovery Wizard
    • D、Enterprise Manager Home Page

    正确答案:C

  • 第16题：

    Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery？（）

    • A、You find that one of the redo log members in each redo log group is lost.
    • B、You find that a data file that belongs to the USERS tablespace is damaged.
    • C、You find that a data file that belongs to the SYSTEM tablespace is damaged.
    • D、You find that the current redo log group is damaged and is not available for recovery.
    • E、You realized while performing a recovery that an archived redo log file needed for recovery is lost.

    正确答案:D,E

  • 第17题：

    Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS  which statement is true？（）  

    • A、 You cannot perform the TSPITR with the constraints enabled.
    • B、 You must perform the TSPITR recovery of both tablespaces for it to be successful.
    • C、 You can perform TSPITR only on the USERS tablespace.
    • D、 RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it  automatically.
    • E、 The TSPITR will only be successful if the constraint is enabled.

    正确答案:B

  • 第18题：

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


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

  • 第19题：

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

    B

    Complete Recovery with archived redo log

    C

    Tablespace Point-in-Time Recovery (TSPITR)

    D

    Incomplete Recovery with system change number (SCN)


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

  • 第20题：

    多选题
    Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）
    A

    The target database must be in NOARCHIVELOG mode.

    B

    No backup is required of the database before you perform a TSPITR.

    C

    You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.

    D

    If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.

    E

    If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.


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

  • 第21题：

    单选题
    An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace：   1. You log on to Enterprise Manager as SYSDBA.    2. You select the maintenance screen.    3. You choose Perform Recovery option on the maintenance screen.    4. You choose Whole Database in the Object Type drop-down list Perform Recovery： Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery： Type screen.    6. You provide the Host Credentials for a database user. on the Perform Recovery： Type screen.    7. You click the continue button.    An information screen appears saying that the database is unavailable. What is this information screen？（）
    A

    Recovery Manager

    B

    Recovery Window

    C

    Recovery Wizard

    D

    Enterprise Manager Home Page


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

  • 第22题：

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

    B

    Open the database in read-only mode

    C

    Open the database in RESTRICTED mode

    D

    Open the database with the RESETLOGS option


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

  • 第23题：

    单选题
    To perform a database point-in-time recovery using RMAN， after database restoration， you must ensure that the database is in which of the following states？（）
    A

    OPEN

    B

    MOUNT

    C

    NOMOUNT

    D

    CLOSE


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

相关内容