niusouti.com

单选题In which of the following scenarios is a tablespace recovery required？（）Awhen recovering a lost read-only tablespace from a read-only tablespace backupBwhen recovering a lost read-only tablespace from a read-write tablespace backup when the database is

题目
单选题
In which of the following scenarios is a tablespace recovery required？（）
A

 when recovering a lost read-only tablespace from a read-only tablespace backup

B

 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG mode

C

 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  NOARCHIVELOG mode and the changes in the online redo log files have been overwritten

D

 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only

相似考题

1. You executed the following command to perform a backup of the USERS tablespace：  SQL> ALTER TABLESPACE users BEGIN BACKUP； ALTER TABLESPACE users BEGIN BACKUP *  ERROR at line 1：  ORA-01123： cannot start online backup； media recovery not enabled  What could be the reason for this error（）A、The MTTR Advisor is disabled.B、The database is in NOARCHIVELOG mode.C、The tablespace is already in backup mode.D、The Flash Recovery Area is not configured.

2. Given below is a list of scenarios： 1） A user terminates his session abnormally. 2） The connection between the server and the client application terminates because of a network failure. 3） A schema is accidentally dropped. 4） The tablespace is accidentally dropped from the database. 5） The hard disk gets corrupted and the data files in the disk are lost. 6） The database instance abnormally shuts down because of power failure.  Which scenarios require DBAintervention to perform recovery（）A、1， 3， and 6B、4， 5， and 6C、3， 4， and 5D、1， 2， and 6

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

4. You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully？ （）A、The database is in NOMOUNT state.B、The database is in ARCHIVELOG mode and the tablespace is online.C、The database is in ARCHIVELOG mode and the tablespace is offline.D、The database is in NOARCHIVELOG mode and the tablespace is online.E、The database is in NOARCHIVELOG mode and the tablespace is offline.

更多“In which of the following scenarios is a tablespace recovery”相关问题

  • 第1题：

    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

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

    In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command： CONFIGURE CONTROLFILE AUTOBACKUP ON； Which two events would cause the control file to be backed up automatically？ （）

    • A、 A tablespace is taken offline.
    • B、 The database instance is restarted.
    • C、 A new data file is added to an existing tablespace.
    • D、 A successful backup is recorded in the RMAN repository.
    • E、 The RMAN connection is disconnected from the target database.

    正确答案:C,D

  • 第4题：

    Which of the following statements is true regarding implementing a Flashback Table recovery？  （）

    • A、 An SCN is never used to perform a Flashback Table recovery.
    • B、 If a significant number of changes have been made to the table， row movement must be enabled.
    • C、 The tablespace must be offline before performing a Flashback Table recovery.
    • D、 Flashback Table recovery is completely dependent on the availability of undo data in the undo  tablespace.

    正确答案:D

  • 第5题：

    单选题
    Which of the following statements is true regarding implementing a Flashback Table recovery？  （）
    A

     An SCN is never used to perform a Flashback Table recovery.

    B

     If a significant number of changes have been made to the table， row movement must be enabled.

    C

     The tablespace must be offline before performing a Flashback Table recovery.

    D

     Flashback Table recovery is completely dependent on the availability of undo data in the undo  tablespace.


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

  • 第6题：

    多选题
    You execute the following command to change the status of the SALES tablespace：  SQL> ALTER TABLESPACE sales OFFLINE；  Which statements describe the effect of the command（）
    A

    The tablespace would require recovery to go back online.

    B

    A checkpoint is taken on all data files that are associated with the SALES tablespace.

    C

    The sessions that subsequently try to access the objects in the SALES tablespace receive an error.

    D

    The new status of the SALES tablespace is recorded in the control file when the database instance is closed.


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

  • 第7题：

    单选题
    You executed the following command to perform a backup of the USERS tablespace：SQL> ALTER TABLESPACE users BEGIN BACKUP；ALTER TABLESPACE users BEGIN BACKUP* ERROR at line 1： ORA-01123： cannot start online backup； media recovery not enabled What could be the reason for this error（）
    A

    The MTTR Advisor is disabled.

    B

    The database is in NOARCHIVELOG mode.

    C

    The tablespace is already in backup mode.

    D

    The Flash Recovery Area is not configured


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

  • 第8题：

    单选题
    Which option is best practice for creating a recovery catalog owner in the catalog database？（）
    A

     Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner

    B

     Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user

    C

     Creating a new tablespace，allocating this as the default， and granting UNLIMITED QUOTA on this tablespace to the user

    D

     Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user


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

  • 第9题：

    多选题
    You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）
    A

    The tablespace would require recovery to go back online.

    B

    A checkpoint is taken on all data files that are associated with the SALES tablespace.

    C

    The sessions that subsequently try to access the objects in the SALES tablespace receive an error

    D

    The new status of the SALES tablespace is recorded in the control file when the database instance isclosed


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

  • 第10题：

    多选题
    You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS；  Under which conditions would this command execute successfully？ （）
    A

    The database is in NOMOUNT state.

    B

    The database is in ARCHIVELOG mode and the tablespace is online.

    C

    The database is in ARCHIVELOG mode and the tablespace is offline.

    D

    The database is in NOARCHIVELOG mode and the tablespace is online.

    E

    The database is in NOARCHIVELOG mode and the tablespace is offline.


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

  • 第11题：

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

  • 第12题：

    多选题
    You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）
    A

    Restore the lost data file from the backup， and then flash back the database.

    B

    Restore the data file pertaining to index tablespace， and then recover the tablespace.

    C

    Restore all the data files， and then perform an incomplete recovery to get the tablespace back.

    D

    Restore all the data files， and then perform an incomplete recovery using the backup control file.

    E

    Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.


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

  • 第13题：

    Which of the following statement is incorrect regarding RMAN？（）

    • A、It detects corrupt blocks.
    • B、It performs only offline database backups.
    • C、It omits empty blocks during backups.
    • D、It performs tablespace point-in-time recovery （TSPITR）.

    正确答案:B

  • 第14题：

    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

  • 第15题：

    In which of the following scenarios is a tablespace recovery required？（）

    • A、 when recovering a lost read-only tablespace from a read-only tablespace backup
    • B、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG mode
    • C、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  NOARCHIVELOG mode and the changes in the online redo log files have been overwritten
    • D、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only

    正确答案:B

  • 第16题：

    To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）

    • A、The database will open, and the tablespace automatically comes out of the backup mode
    • B、The database will be mounted, and recovery must be performed on the USERS tablespace.
    • C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
    • D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

    正确答案:C

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


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

  • 第19题：

    单选题
    To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）
    A

    The database will open, and the tablespace automatically comes out of the backup mode.

    B

    The database will be mounted, and recovery must be performed on the USERS tablespace.

    C

    The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.

    D

    The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.


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

  • 第20题：

    单选题
    Which option is best practice for creating a recovery catalog owner in the catalog database?（）
    A

    Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner

    B

    Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user

    C

    Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user

    D

    Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user


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

  • 第21题：

    多选题
    For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）
    A

    RMAN image copies

    B

    RMAN database backups

    C

    RMAN tablespace backups

    D

    user­managed backups placed in the flash recovery area

    E

    user­managed backups that have been cataloged with RMAN

    F

    user­managed data file backups for which the full path name is specified


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

  • 第22题：

    单选题
    Which of the following statement is incorrect regarding RMAN？（）
    A

    It detects corrupt blocks.

    B

    It performs only offline database backups.

    C

    It omits empty blocks during backups.

    D

    It performs tablespace point-in-time recovery （TSPITR）.


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

  • 第23题：

    多选题
    In which of the scenarios will the DBA perform recovery（）
    A

    The alert log file is corrupted.

    B

    A tablespace is accidentally dropped.

    C

    One of the redo log members is corrupted.

    D

    A database user terminates the session abnormally.

    E

    The hard disk on which the data file is stored is corrupted.


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

  • 第24题：

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


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

相关内容