多选题When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）AThe SYSTEM tablespace.BThe UNDO tablespace.CAll tablespaces with tables.DAll tablespaces with indexes.ENo tablespaces are 

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

相似考题

1.In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）A、When the data file of the undo tablespace is autoextensibleB、When there are more than one undo tablespaces available in the databaseC、When the undo tablespace is of a fixed size and retention guarantee is not enabledD、When the undo tablespace is autoextensible and retention guarantee is not enabled

2. Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）A、the retention period to support flashbackB、the expected length of the longest-running queryC、the number of undo tablespaces in the databaseD、the size of the Flash Recovery Area for the database instance

3. Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）A、The retention period to support flashbackB、The expected length of the longest-running queryC、The number of undo tablespaces in the databaseD、The size of the Flash Recovery Area for the database instance

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

更多“多选题When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）AThe SYSTEM tablespace.BThe UNDO tablespace.CAll tablespaces with tables.DAll tablespaces with indexes.ENo tablespaces are ”相关问题

  • 第1题：

    Data files of which three tablespaces can be recovered by performing an openrecovery？（）

    • A、TEMP
    • B、UNDO
    • C、INDEX
    • D、SYSAUX
    • E、SYSTEM

    正确答案:A,C,D

  • 第2题：

    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

  • 第3题：

    Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）

    • A、 undo tablespace
    • B、 index tablespace
    • C、 read-only tablespace
    • D、 temporary tablespace

    正确答案:D

  • 第4题：

    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

  • 第5题：

    多选题
    Data files of which three tablespaces can be recovered by performing an open recovery？（）
    A

    TEMP

    B

    UNDO

    C

    INDEX

    D

    SYSAUX

    E

    SYSTEM


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

  • 第6题：

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


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

  • 第7题：

    多选题
    Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
    A

    The retention period to support flashback

    B

    The expected length of the longest-running query

    C

    The number of undo tablespaces in the database

    D

    The size of the Flash Recovery Area for the database instance


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

  • 第8题：

    多选题
    Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
    A

    the retention period to support flashback

    B

    the expected length of the longest-running query

    C

    the number of undo tablespaces in the database

    D

    the size of the Flash Recovery Area for the database instance


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

  • 第9题：

    多选题
    Which two statements are true regarding undo tablespaces（）
    A

    The database can have more than one undo tablespace.

    B

    The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.

    C

    Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.

    D

    An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.


    正确答案： C,B
    解析： A答案：可以有一个或多个undo表空间，A答案正确。 
    sys@TEST0924> select TABLESPACE_NAME，CONTENTS from dba_tablespaces； TABLESPACE_NAME CONTENTS ------------------------------ --------- SYSTEM PERMANENT SYSAUX PERMANENT UNDOTBS1 UNDO TEMP TEMPORARY USERS PERMANENT UNDOTBS2 UNDO 
    EXAMPLE PERMANENT LXTBS PERMANENT FLA_TBS1 PERMANENT FLA_TBS2 PERMANENT 10 rows selected. 
    B答案：UNDO_TABLESPACE只能用于自动undo段模式，B答案错误

  • 第10题：

    多选题
    Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）
    A

    Backup of offline tablespaces.

    B

    Backup of read-only tablespaces.

    C

    Backup of system-critical tablespaces.

    D

    Backup of online， locally managed tablespaces.

    E

    Backup of read/write dictionary-managed tablespaces.


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

  • 第11题：

    多选题
    Examine the following command that is used to duplicate a database on the same host: Which two statements describe the effect after the database is duplicated successfully? （）
    A

    The data files of the read-only tablespaces in the target database are not duplicated

    B

    The read-only tablespaces in the target database are still defined in new the database

    C

    The read-only tablespaces in the target database are changed to online after duplication

    D

    The data files of the read-only tablespaces in the target database get duplicated

    E

    The read-only tablespaces in the target database are not defined in the new database


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

  • 第12题：

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

  • 第13题：

    In which situation may the UNDO_RETENTION parameter be ignored， even if it is set to a value（）

    • A、when the data file of the undo tablespace is autoextensible
    • B、when there are more than one undo tablespaces available in the database
    • C、when the undo tablespace is of a fixed size and retention guarantee is not enabled
    • D、when the undo tablespace is autoextensible and retention guarantee is not enabled

    正确答案:C

  • 第14题：

    Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）

    • A、 Backup of offline tablespaces.
    • B、 Backup of read-only tablespaces.
    • C、 Backup of system-critical tablespaces.
    • D、 Backup of online， locally managed tablespaces.
    • E、 Backup of read/write dictionary-managed tablespaces.

    正确答案:A,B

  • 第15题：

    Which tablespaces are mandatory in an Oracle database for it to be operational（）

    • A、Undo tablespace
    • B、USERS tablespace
    • C、SYSAUX tablespace
    • D、SYSTEM tablespace
    • E、Temporary tablespace

    正确答案:C,D

  • 第16题：

    Data files of which three tablespaces can be recovered by performing an open recovery？（）

    • A、TEMP
    • B、UNDO
    • C、INDEX
    • D、SYSAUX
    • E、SYSTEM

    正确答案:A,C,D

  • 第17题：

    多选题
    In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command：  RMAN> RESTORE CONTROLFILE；  Which two operations do you need to perform after restoring the control file from backup？（）
    A

    shut down and restart the instance

    B

    add new tempfiles to the temporary tablespaces after recovery

    C

    perform a media recovery and open the database with the RESETLOGS option

    D

    perform a media recovery and bring the database to NOARCHIVELOG mode


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

  • 第18题：

    单选题
    Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）
    A

     undo tablespace

    B

     index tablespace

    C

     read-only tablespace

    D

     temporary tablespace


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

  • 第19题：

    多选题
    Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）
    A

    backup of offline tablespaces

    B

    backup of read­only tablespaces

    C

    backup of system­critical tablespaces

    D

    backup of online， locally managed tablespaces

    E

    backup of read/write dictionary­managed tablespaces


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

  • 第20题：

    单选题
    In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）
    A

    When the data file of the undo tablespace is autoextensible

    B

    When there are more than one undo tablespaces available in the database

    C

    When the undo tablespace is of a fixed size and retention guarantee is not enabled

    D

    When the undo tablespace is autoextensible and retention guarantee is not enabled


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

  • 第21题：

    多选题
    Which of the following are included in a transportable tablespace set？（）
    A

    The datafiles that make up a self-contained group of tablespaces required for copy

    B

    The system tablespace

    C

    An export of the tablespace metadata

    D

    The spfile

    E

    All of the above


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

  • 第22题：

    单选题
    In which situation may the UNDO_RETENTION parameter be ignored， even if it is set to a value（）
    A

    when the data file of the undo tablespace is autoextensible

    B

    when there are more than one undo tablespaces available in the database

    C

    when the undo tablespace is of a fixed size and retention guarantee is not enabled

    D

    when the undo tablespace is autoextensible and retention guarantee is not enabled


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

  • 第23题：

    多选题
    Data files of which three tablespaces can be recovered by performing an openrecovery？（）
    A

    TEMP

    B

    UNDO

    C

    INDEX

    D

    SYSAUX

    E

    SYSTEM


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

  • 第24题：

    多选题
    Examine the following command that is used to duplicate a database on the same host: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)
    A

    The data files of the read-only tablespaces in the target database are not duplicated

    B

    The read-only tablespaces in the target database are still defined in new the database

    C

    The read-only tablespaces in the target database are changed to online after duplication

    D

    The data files of the read-only tablespaces in the target database get duplicated

    E

    The read-only tablespaces in the target database are not defined in the new database


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

相关内容