单选题Why should you back up a duplicated tablespace after a TSPITR is complete？（）AThe tablespace cannot be duplicated or restored to any point in time after the duplication. BThe tablespace cannot be duplicated or restored to the point in time before the du

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

相似考题

1.When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）A、 The SYSTEM tablespace.B、 The UNDO tablespace.C、 All tablespaces with tables.D、 All tablespaces with indexes.E、 No tablespaces are automatically restored.

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

3. 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 TSPITRB、Move objects to another schema that has the same tablespace assignedC、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

4.Which command would correctly start a TSPITR of the USERS tablespace？（）  A、 recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary ，，c/oracle/auxiliaryB、 recover tablespace users time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary； time ，， 10/06/2008：22：42：00 auxiliary destination ，，c/oracle/auxiliaryC、 recover tablespace users to point-in.D、 recover tablespace users except time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliaryE、 recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary

参考答案和解析
正确答案： A
解析： 暂无解析
更多“单选题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 th”相关问题

  • 第1题：

    You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday.  Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task？（） 

    • A、 SYSTEM
    • B、 SYSAUX
    • C、 UNDO
    • D、 USERS
    • E、 TEMP
    • F、 This restore is not possible

    正确答案:A,B,C,D

  • 第2题：

    What RMAN command is used to execute a tablespace point-in-time recovery？（）

    • A、 recover
    • B、 duplicate
    • C、 restore
    • D、 copy
    • E、 None of the above

    正确答案:A

  • 第3题：

    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

  • 第4题：

    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.

    正确答案:B

  • 第5题：

    You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）

    • A、 restore the tablespace from the backup； there is no need to apply the redo information
    • B、 restore the full database to recover the data up to the point when you performed the backup
    • C、 restore the tablespace from the backup and then perform a recovery using the backup control file
    • D、 restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied

    正确答案: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题：

    单选题
    When running the tablespace point-in-time command   recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary destination ,,c:/oracle/auxiliary; you receive the following error:  RMAN-00571: ===========================================================  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS  =============== RMAN-00571:  ===========================================================  RMAN-03002: failure of recover command at 10/08/2008 16:00:30  RMAN-20202: Tablespace not found in the recovery catalog  RMAN-06019: could not translate tablespace name "USERS"   What is the likely cause of the error?（）
    A

     The database is in ARCHIVELOG mode.

    B

     There is not a current backup of the database available.

    C

     The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.

    D

     The USERS tablespace is not eligible for TSPITR because it has invalid objects.

    E

     The recover tablespace command is incorrect and generates the error.


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

  • 第9题：

    单选题
    What RMAN command is used to execute a tablespace point-in-time recovery？（）
    A

     recover

    B

     duplicate

    C

     restore

    D

     copy

    E

     None of the above


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

  • 第10题：

    单选题
    You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）
    A

     restore the tablespace from the backup； there is no need to apply the redo information

    B

     restore the full database to recover the data up to the point when you performed the backup

    C

     restore the tablespace from the backup and then perform a recovery using the backup control file

    D

     restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied


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

  • 第11题：

    多选题
    When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）
    A

    The SYSTEM tablespace.

    B

    The UNDO tablespace.

    C

    All tablespaces with tables.

    D

    All tablespaces with indexes.

    E

    No tablespaces are automatically restored.


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

  • 第12题：

    单选题
    You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use？（）
    A

     alter tablespace MY_DATA begin backup

    B

     alter tablespace MY_DATA start backup

    C

     alter tablespace MY_DATA backup begin

    D

     alter MY_DATA begin backup

    E

     You cannot back up individual tablespaces


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

  • 第13题：

    Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）

    • A、Until last commit
    • B、Until the time you perform recovery
    • C、Until the time the date file got corrupted
    • D、Until the point where the last transaction begun
    • E、You cannot recover the SYSTEMtablespaceand must re-create the database.

    正确答案:A

  • 第14题：

    Which command is used to begin a tablespace point-in-time recovery？（）  

    • A、 Restore tablespace
    • B、 Recover tablespace
    • C、 Tablespace recover
    • D、 Recover to time
    • E、 recover datafile

    正确答案:B

  • 第15题：

    You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）

    • A、 The index tablespace contains bitmap indexes.
    • B、 The index tablespace contains more than one data file.
    • C、 The index tablespace supports only complete recovery.
    • D、 The index tablespace is not a dictionary-managed tablespace.
    • E、 There is a dependency relationship between a table and its indexes.

    正确答案:E

  • 第16题：

    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

  • 第17题：

    You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use？（）  

    • A、 alter tablespace MY_DATA begin backup
    • B、 alter tablespace MY_DATA start backup
    • C、 alter tablespace MY_DATA backup begin
    • D、 alter MY_DATA begin backup
    • E、 You cannot back up individual tablespaces

    正确答案:A

  • 第18题：

    单选题
    You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）
    A

     The index tablespace contains bitmap indexes.

    B

     The index tablespace contains more than one data file.

    C

     The index tablespace supports only complete recovery.

    D

     The index tablespace is not a dictionary-managed tablespace.

    E

     There is a dependency relationship between a table and its indexes.


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

  • 第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）


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

  • 第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题：

    单选题
    Which command would correctly start a TSPITR of the USERS tablespace？（）
    A

     recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary ，，c/oracle/auxiliary

    B

     recover tablespace users time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary； time ，， 10/06/2008：22：42：00 auxiliary destination ，，c/oracle/auxiliary

    C

     recover tablespace users to point-in.

    D

     recover tablespace users except time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary

    E

     recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary


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

  • 第22题：

    单选题
    Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）
    A

    Until last commit

    B

    Until the time you perform recovery

    C

    Until the time the date file got corrupted

    D

    Until the point where the last transaction begun

    E

    You cannot recover the SYSTEMtablespaceand must re-create the database.


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

  • 第23题：

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


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

相关内容