niusouti.com

单选题Which statement is true regarding RMAN components？（）A Each target database requires its own recover catalog. B RMAN scripts can be stored in the recovery catalog or the target control file. C A channel is a stream of data to a device type and correspon

题目
单选题
Which statement is true regarding RMAN components？（）
A

Each target database requires its own recover catalog. 

B

RMAN scripts can be stored in the recovery catalog or the target control file. 

C

A channel is a stream of data to a device type and corresponds to one server session. 

D

The RMAN executable interprets sever session commands and establishes connections to the target database.

相似考题

1. Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line？（） Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database. A、 rman target=/ catalog=/@rcatB、 rman target=/ catalog=rcat_own/rcat_ownC、 rman target=/ catalog=rcat_own/rcat_own@RCATD、 rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCATE、 You cannot connect to the target database and the recovery catalog at the same time.

2.Which statement is true regarding RMAN components？（）A、Each target database requires its own recover catalog. B、RMAN scripts can be stored in the recovery catalog or the target control file. C、A channel is a stream of data to a device type and corresponds to one server session. D、The RMAN executable interprets sever session commands and establishes connections to the target database.

3. You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not displayed in the correct order. Which displays the correct order？（） 1. Grant the appropriate privileges （CONNECT and RESOURCE） and roles  （RECOVERY_CATALOG_OWNER） to the user responsible for performing backup and recover operations.  2. Register the target database in the catalog.  3. Create the catalog using the RMAN command line interpreter.  4. Create a user and schema which will own the recovery catalog.  5. Create tablespace to hold the catalog in the database you have dedicated for your RMAN recovery catalog.  6. Connect to the target database using SYSDBA privileges.A、4，1，5，6，3，2B、4，3，1，5，6，2C、4，5，1，3，2，6D、5，4，1，3，2，6E、5，4，1，3，6，2

4.Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager （RMAN）.（）A、 You can use RMAN stored scripts.B、 Recovery is faster if data is stored in catalog in addition to the control file.C、 You can store backup Information of all registered databases in one place.D、 Database backups are automatically deleted when they are older than the specified time period.

更多“单选题Which statement is true regarding RMAN components？（）A Each target database requires its own recover catalog. B RMAN scripts can be stored in the recovery catalog or the target control file. C A channel is a stream of data to a device type and correspon”相关问题

  • 第1题：

    Which statement is true regarding virtual private catalogs?（）

    • A、A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
    • B、The virtual private catalog owner cannot create and modify the stored scripts.
    • C、The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
    • D、To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database

    正确答案:D

  • 第2题：

    You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）

    • A、RMAN would use the current operating system location to place the backup.
    • B、RMAN would use the control file of the target database to maintain the backup.
    • C、RMAN would use the recovery catalog of the target database to maintain the backup.
    • D、RMAN would use the control file of the target database to maintain the backup metadata. 
    • E、RMAN would use the recovery catalog of the target database to maintain the backup metadata.

    正确答案:D

  • 第3题：

    Examine the following scenario： The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host， using the Recovery Manager （RMAN） duplicate command as follows：   RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK；  DUPLICATE TARGET DATABASE TO auxdb； }   Which statement is true about the duplicate database in this scenario？（）  

    • A、 It contains data till the last backup
    • B、 It contains all data from target database until the current time
    • C、 It contains all data from only the committed transactions in the target database
    • D、 It contains all data except that which is used by the transactions in the current online redo file of target database

    正确答案:D

  • 第4题：

    Which two statements regarding the control file and Recover Manager are true？ （）

    • A、The control file can grow in size.
    • B、The control file can store RMAN scripts.
    • C、CONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN records.
    • D、The RMAN catalog can exist solely in the control file of the target database.

    正确答案:C,D

  • 第5题：

    单选题
    Which statement is true regarding RMAN components？（）
    A

    Each target database requires its own recover catalog. 

    B

    RMAN scripts can be stored in the recovery catalog or the target control file. 

    C

    A channel is a stream of data to a device type and corresponds to one server session. 

    D

    The RMAN executable interprets sever session commands and establishes connections to the target database.


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

  • 第6题：

    多选题
    Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line？（） Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database.
    A

    rman target=/ catalog=/@rcat

    B

    rman target=/ catalog=rcat_own/rcat_own

    C

    rman target=/ catalog=rcat_own/rcat_own@RCAT

    D

    rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCAT

    E

    You cannot connect to the target database and the recovery catalog at the same time.


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

  • 第7题：

    单选题
    Which statement about using RMAN stored scripts is true?（）
    A

    To create and execute an RMAN stored script, you must use a recovery catalog.

    B

    When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.

    C

    RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.

    D

    When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.


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

  • 第8题：

    单选题
    You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed？（）
    A

    back up the control file to trace

    B

    bring database to the MOUNT state

    C

    open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

    D

    set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog


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

  • 第9题：

    单选题
    Examine the following scenario： The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host， using the Recovery Manager （RMAN） duplicate command as follows：   RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK；  DUPLICATE TARGET DATABASE TO auxdb； }   Which statement is true about the duplicate database in this scenario？（）
    A

     It contains data till the last backup

    B

     It contains all data from target database until the current time

    C

     It contains all data from only the committed transactions in the target database

    D

     It contains all data except that which is used by the transactions in the current online redo file of target database


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

  • 第10题：

    单选题
    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（）
    A

     back up the control file to trace

    B

     bring database to the MOUNT state

    C

     open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

    D

     set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog


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

  • 第11题：

    单选题
    Which statement is true regarding virtual private catalogs？（）
    A

     A virtual private catalog owner can create a local stored script， and have read/write access to a global stored script.

    B

     The virtual private catalog owner cannot create and modify the stored scripts.

    C

     The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.

    D

     To perform most of the RMAN operations， the virtual catalog owner must have the SYSDBA or  SYSOPER privilege on the target database.


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

  • 第12题：

    多选题
    Which two RMAN commands initiate a resynchronization of the recovery catalog with the target database control file？（）
    A

    COPY

    B

    BACKUP

    C

    CHANGE

    D

    DELETE

    E

    CATALOG


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

  • 第13题：

    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（） 

    • A、back up the control file to trace
    • B、bring database to the MOUNT state
    • C、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database
    • D、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

    正确答案:C

  • 第14题：

    Which statement about using RMAN stored scripts is true？（）  

    • A、 To create and execute an RMAN stored script，you must use a recovery catalog.
    • B、 When executing a stored script and a command fails，the remainder of the script is executed，and a message is written to the alert log file.
    • C、 RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
    • D、 When you execute a stored script，it always executes using the persistent channel settings previously set with the CONFIGURE command.

    正确答案:A

  • 第15题：

    You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）

    • A、 rman TARGET / NOCATALOG
    • B、 rman TARGET sys/password
    • C、 rman TARGET sys/password AS SYSDBA
    • D、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

    正确答案:B

  • 第16题：

    Which two RMAN commands initiate a resynchronization of the recovery catalog with the target database control file？（）

    • A、COPY
    • B、BACKUP
    • C、CHANGE
    • D、DELETE
    • E、CATALOG

    正确答案:A,B,D

  • 第17题：

    单选题
    Which statement about using RMAN stored scripts is true？（）
    A

     To create and execute an RMAN stored script，you must use a recovery catalog.

    B

     When executing a stored script and a command fails，the remainder of the script is executed，and a message is written to the alert log file.

    C

     RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.

    D

     When you execute a stored script，it always executes using the persistent channel settings previously set with the CONFIGURE command.


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

  • 第18题：

    单选题
    You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： % rman target / What would be the effect of this command？（）
    A

     RMAN would use the current operating system location to place the backup.

    B

     RMAN would use the control file of the target database to maintain the backup.

    C

     RMAN would use the recovery catalog of the target database to maintain the backup.

    D

     RMAN would use the control file of the target database to maintain the backup metadata.

    E

     RMAN would use the recovery catalog of the target database to maintain the backup metadata.


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

  • 第19题：

    单选题
    RMAN automatically propagate information about the database structure， archived redo logs， backup sets， and data file copies into the recovery catalog from the target database’s control file. This information can also be propagated to the catalog manually by using the （）command.
    A

    LIST

    B

    SWITCH

    C

    VALIDATE

    D

    CONFIGURE

    E

    RESYNC CATALOG

    F

    UPGRADE CATALOG


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

  • 第20题：

    单选题
    You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）
    A

     rman TARGET / NOCATALOG

    B

     rman TARGET sys/password

    C

     rman TARGET sys/password AS SYSDBA

    D

     rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat


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

  • 第21题：

    单选题
    You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not displayed in the correct order. Which displays the correct order？（） 1. Grant the appropriate privileges （CONNECT and RESOURCE） and roles  （RECOVERY_CATALOG_OWNER） to the user responsible for performing backup and recover operations.  2. Register the target database in the catalog.  3. Create the catalog using the RMAN command line interpreter.  4. Create a user and schema which will own the recovery catalog.  5. Create tablespace to hold the catalog in the database you have dedicated for your RMAN recovery catalog.  6. Connect to the target database using SYSDBA privileges.
    A

    4，1，5，6，3，2

    B

    4，3，1，5，6，2

    C

    4，5，1，3，2，6

    D

    5，4，1，3，2，6

    E

    5，4，1，3，6，2


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

  • 第22题：

    多选题
    Which two statements regarding the control file and Recover Manager are true？ （）
    A

    The control file can grow in size.

    B

    The control file can store RMAN scripts.

    C

    CONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN records.

    D

    The RMAN catalog can exist solely in the control file of the target database.


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

  • 第23题：

    单选题
    Which statement is true regarding virtual private catalogs? （）
    A

    A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script. 

    B

    The virtual private catalog owner cannot create and modify the stored scripts. 

    C

    The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner. 

    D

    To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database. 


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

  • 第24题：

    多选题
    Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager （RMAN）.（）
    A

    You can use RMAN stored scripts.

    B

    Recovery is faster if data is stored in catalog in addition to the control file.

    C

    You can store backup Information of all registered databases in one place.

    D

    Database backups are automatically deleted when they are older than the specified time period.


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

相关内容