多选题In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）AAfter the COPY command.BAfter adding a data file in the target database.CAfter adding a tablespace in the target datab

题目
多选题
In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）
A

After the COPY command.

B

After adding a data file in the target database.

C

After adding a tablespace in the target database.

D

After adding a tablespace in the catalog database.

E

After dropping a data file in the catalog database.

F

After running SQL Loader to load a large amount of data.

相似考题

1. 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 offlineB、the database instance is restartedC、a new data file is added to an existing tablespaceD、a successful backup is recorded in the RMAN repositoryE、the RMAN connection is disconnected from the target database

2. You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)A、The backup piece size will be limited to 300 MBB、The RMAN uses multiplexing to perform backupC、The operation is accomplished using the default channel availableD、The RMAN parallelizes the backup although the parallelism is not set for a channel

3. You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M；  Which statement is true about this command（）A、The command must be issued in MOUNT state.B、The command succeeds only if the data file is offline.C、The command must be issued when the database is in the archivelog mode.D、The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.

4.In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）A、After the COPY command.B、After adding a data file in the target database.C、After adding a tablespace in the target database.D、After adding a tablespace in the catalog database.E、After dropping a data file in the catalog database.F、After running SQL Loader to load a large amount of data.

更多“多选题In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）AAfter the COPY command.BAfter adding a data file in the target database.CAfter adding a tablespace in the target datab”相关问题

  • 第1题：

    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

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

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

    When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON， RMAN automatically performs a control file autobackup in which three situations？（）

    • A、At the end of every RUN block. 
    • B、After every SET CONTROLFILE AUTOBACKUP FORMAT command. 
    • C、After every BACKUP or COPY command issued at the RMAN prompt. 
    • D、At the end of every RUN block if the last command in the block was either BACKUP or COPY. 
    • E、Whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY. 
    • F、After every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command.

    正确答案:C,D,E

  • 第5题：

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


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

  • 第6题：

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

  • 第7题：

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

  • 第8题：

    多选题
    In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）
    A

    After the COPY command.

    B

    After adding a data file in the target database.

    C

    After adding a tablespace in the target database.

    D

    After adding a tablespace in the catalog database.

    E

    After dropping a data file in the catalog database.

    F

    After running SQL Loader to load a large amount of data.


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

  • 第9题：

    多选题
    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?（）
    A

    Creating the control file for the duplicate database

    B

    Restoring the target data files to the duplicate database

    C

    Performing complete recovery using all available backups

    D

    Generating a new, unique DBID for the duplicate database

    E

    Copying the online redo log files from the target database to the duplicate database


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

  • 第10题：

    多选题
    The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task， you issued the following command：  SQL> ALTER TABLESPACE hi_data BEGIN BACKUP；   Which two statements are true in this scenario？（）
    A

    No transaction on the tablespace is allowed but you can perform queries.

    B

    The tablespace will automatically come out of backup mode when the file copy is complete.

    C

    The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.

    D

    The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.


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

  • 第11题：

    多选题
    You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)
    A

    The backup piece size will be limited to 300 MB

    B

    The RMAN uses multiplexing to perform backup

    C

    The operation is accomplished using the default channel available

    D

    The RMAN parallelizes the backup although the parallelism is not set for a channel


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

  • 第12题：

    多选题
    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)
    A

    Creating the control file for the duplicate database

    B

    Restoring the target data files to the duplicate database

    C

    Performing complete recovery using all available backups

    D

    Generating a new, unique DBID for the duplicate database

    E

    Copying the online redo log files from the target database to the duplicate database


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

  • 第13题：

    If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）

    • A、 The next time you back up the database when you are also connected to the recovery catalog and the target database
    • B、 The next time you are connected to the target database and the recovery catalog database and issue the resync command
    • C、 The next time you connect RMAN to just the recovery catalog
    • D、 The next time you connect to the recovery catalog and the target database with RMAN
    • E、 Connecting to the recovery catalog and issuing the resync all databases command

    正确答案:A,B

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

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

  • 第18题：

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

  • 第19题：

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


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

  • 第20题：

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


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

  • 第21题：

    单选题
    You issued the following commands to configure setting in RMAN; Then you issued the following command to take the backup: RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?（）
    A

    The backup will terminate because the FORMAT clause was not configured for the channel

    B

    It backs up two copies of data files to tape and disk, and two copies of archived log file on tape

    C

    It backs up the data files and archived log files to disk, making two copies of each data file and archived log file

    D

    It backs up the data files and archived log files to tape, making two copies of each data file and archived log file


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

  • 第22题：

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

  • 第23题：

    多选题
    If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）
    A

    The next time you back up the database when you are also connected to the recovery catalog and the target database

    B

    The next time you are connected to the target database and the recovery catalog database and issue the resync command

    C

    The next time you connect RMAN to just the recovery catalog

    D

    The next time you connect to the recovery catalog and the target database with RMAN

    E

    Connecting to the recovery catalog and issuing the resync all databases command


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

  • 第24题：

    多选题
    When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON， RMAN automatically performs a control file autobackup in which three situations？（）
    A

    At the end of every RUN block.

    B

    After every SET CONTROLFILE AUTOBACKUP FORMAT command.

    C

    After every BACKUP or COPY command issued at the RMAN prompt.

    D

    At the end of every RUN block if the last command in the block was either BACKUP or COPY.

    E

    Whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY.

    F

    After every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command.


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

相关内容