itgle.com

The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？ （）A、data filesB、backup setsC、control filesD、archived redo log files

题目

The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files？ （）

  • A、data files
  • B、backup sets
  • C、control files
  • D、archived redo log files
相似考题

1.Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?（）A. Implement RMAN multiplexingB. Set the DEBUG ON in the RMAN scriptC. Specify the command ID in the RMAN scriptD. Use a tag with the RMAN BACKUP command

2.hich of the following RMAN structures can data from a datafile span?（）A、RMAN backup-set pieces spanning backup sets B、RMAN backup-set pieces within a given backup sets C、RMAN backups D、RMAN channels E、None of the above

3. In which scenario， will you issue the following command？（） RMAN> REPORT NEED BACKUP DAYS 7；A、 to configure RMAN to maintain backup information in the RMAN repository for seven daysB、 to configure RMAN to maintain backup information in the control file for at least seven daysC、 to display the list of files that have not been backed up for the last seven daysD、 to display the list of files that must be backed up within seven days

4.Examine the following RMAN script:RMAN> run {debug on;allocate channel c1 type disk;backup datafile 5;}Which statement describes the purpose of the script?()A. The data file is checked for physical corruption and backed up if found clean.B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

更多“The RMAN BACKUP̳”相关问题

  • 第1题：

    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

    正确答案:A,C

  • 第2题：

    You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command：  RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS；  When a backup is performed， what would be the status of this backup after seven days？（）

    • A、 The backup would be marked as invalid.
    • B、 The backup would be marked as obsolete.
    • C、 The backup would be removed from the media.
    • D、 The backup would be removed from the RMAN repository.

    正确答案:B

  • 第3题：

    You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）

    • A、 When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.
    • B、 When a structural change is made to the database， then a backup of the current control file is performed.
    • C、 When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.
    • D、 When a structural change is made to the database， then a backup of the alert log file will be performed.

    正确答案:D

  • 第4题：

    What type of backup is stored in a proprietary RMAN format？（）

    • A、 Backup set
    • B、 Image copy
    • C、 Backup section
    • D、 Backup group

    正确答案:A

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

    正确答案:D

  • 第6题：

    单选题
    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）
    A

    The backup status will be marked expired in RMAN recovery catalog.

    B

    The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.

    C

    The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl

    D

    The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.

    E

    The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.


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

  • 第7题：

    单选题
    You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）
    A

     When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.

    B

     When a structural change is made to the database， then a backup of the current control file is performed.

    C

     When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.

    D

     When a structural change is made to the database， then a backup of the alert log file will be performed.


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

  • 第8题：

    单选题
    In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET; RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT '/home/oracle/disk1/%U'; RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE disk FORMAT '/home/oracle/disk2/%U'; You issue the following RMAN command to backup the database: RMAN> RUN 2> { 3> ALLOCATE CHANNEL ch1 DEVICE TYPE disk; 4> BACKUP DATABASE; 5> } Which statement is true about the outcome?（）
    A

    Only one channel is allocated and the backup is created in the flash recovery area

    B

    Only one channel is allocated and the backup is created in the destination specified for channel 1

    C

    Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2

    D

    Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA


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

  • 第9题：

    多选题
    What is the purpose of the RMAN recovery catalog？（）
    A

    It must be used because all RMAN-related backup and recovery metadata information is contained in it.

    B

    It provides a convenient， optional， repository of backup- and recovery-related metadata.

    C

    It provides the ability to store RMAN scripts for global use by any database that has access to the repository.

    D

    It provides a means of storing all RMAN backup sets physically in an Oracle database server.

    E

    It provides the ability to store backup records for more than a year.


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

  • 第10题：

    单选题
    Consider the following scenario for your database: Which statement is true regarding the backup of the TOOLS tablespace?（）
    A

    The RMAN backup fails because the TOOLS tablespace is read-only

    B

    The RMAN skips the backup of the tablespace because backup optimization is enabled

    C

    The RMAN makes backup because optimization can be enabled only for backups to disk

    D

    The RMAN makes the backup because no backup of the tablespace exists within the seven day window


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

  • 第11题：

    单选题
    You issued the following commands to configure setting in RMAN; RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1; RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt; RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2; 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


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

  • 第12题：

    单选题
    When youre performing active database duplication，a backup of what kind is required？（）
    A

     A current RMAN backup-set backup is required.

    B

     No backup is required.

    C

     An RMAN image backup is required.

    D

     A manual backup is required.

    E

     A duplicate preparatory backup is required.


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

  • 第13题：

    Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?（）

    • A、The RMAN backup fails because the TOOLS tablespace is read-only
    • B、The RMAN skips the backup of the tablespace because backup optimization is enabled
    • C、The RMAN makes backup because optimization can be enabled only for backups to disk
    • D、The RMAN makes the backup because no backup of the tablespace exists within the seven day window

    正确答案:D

  • 第14题：

    When youre performing active database duplication，a backup of what kind is required？（）  

    • A、 A current RMAN backup-set backup is required.
    • B、 No backup is required.
    • C、 An RMAN image backup is required.
    • D、 A manual backup is required.
    • E、 A "duplicate" preparatory backup is required.

    正确答案:B

  • 第15题：

    Which of the following RMAN structures can data from a datafile span？（）

    • A、 RMAN backup-set pieces spanning backup sets
    • B、 RMAN backup-set pieces within a given backup set
    • C、 RMAN backups
    • D、 RMAN channels
    • E、 None of the above

    正确答案:B

  • 第16题：

    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）

    • A、The backup status will be marked expired in RMAN recovery catalog.
    • B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
    • C、The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl
    • D、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.
    • E、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.

    正确答案:C

  • 第17题：

    单选题
    In which scenario， will you issue the following command？（） RMAN> REPORT NEED BACKUP DAYS 7；
    A

     to configure RMAN to maintain backup information in the RMAN repository for seven days

    B

     to configure RMAN to maintain backup information in the control file for at least seven days

    C

     to display the list of files that have not been backed up for the last seven days

    D

     to display the list of files that must be backed up within seven days


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

  • 第18题：

    单选题
    View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions: RMAN> BACKUP DATABASE FILESPERSET 2; The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?（）
    A

    Because the progress is reported for each data file

    B

    Because the progress is reported for each backup set

    C

    Because other RMAN sessions have issued the same BACKUP command

    D

    Because new data files have been added to the database while the RMAN backup is in progress


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

  • 第19题：

    单选题
    Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?（）
    A

    The RMAN backup fails because the TOOLS tablespace is read-only

    B

    The RMAN skips the backup of the tablespace because backup optimization is enabled

    C

    The RMAN makes backup because optimization can be enabled only for backups to disk

    D

    The RMAN makes the backup because no backup of the tablespace exists within the seven day window


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

  • 第20题：

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


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

  • 第21题：

    单选题
    What type of backup is stored in a proprietary RMAN format？（）
    A

     Backup set

    B

     Image copy

    C

     Backup section

    D

     Backup group


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

  • 第22题：

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


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

  • 第23题：

    单选题
    Which of the following RMAN structures can data from a datafile span？（）
    A

     RMAN backup-set pieces spanning backup sets

    B

     RMAN backup-set pieces within a given backup set

    C

     RMAN backups

    D

     RMAN channels

    E

     None of the above


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

  • 第24题：

    单选题
    You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command：  RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;  When a backup is performed， what would be the status of this backup after seven days？（）
    A

    The backup would be marked as invalid.

    B

    The backup would be marked as obsolete.

    C

    The backup would be removed from the media.

    D

    The backup would be removed from the RMAN repository.


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

相关内容