单选题Which RMAN backup command is used to create the block-change tracking file?()Aalter database create block change tracking fileBalter database enable block change fileCalter database enable block change tracking using file ,/ora01/opt/ block_change_trac

题目
单选题
Which RMAN backup command is used to create the block-change tracking file?()
A

 alter database create block change tracking file

B

 alter database enable block change file

C

 alter database enable block change tracking using file ,/ora01/opt/ block_change_tracking.fil

D

 alter system enable block change tracking using file ’/ora01/opt/block_ change_tracking.fil’

E

 alter system block change tracking on


相似考题
更多“Which RMAN backup command is used to create the block-change”相关问题
  • 第1题:

    What is the purpose of the catalog command?()  

    • A、 To review RMAN control file and recovery catalog metadata and ensure that its correct
    • B、 To delete RMAN backup-related metadata from the recovery catalog
    • C、 To create metadata in the control file and the recovery catalog related to backup set pieces 
    • D、 To create a report that lists database backups
    • E、 To rebuild the recovery catalog

    正确答案:C

  • 第2题:

    You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy:   CONFIGURE RETENTION POLICY TO REDUNDANCY 3;   Which statement is true?()  

    • A、 The command fails because you cannot configure a redundancy-based retention policy when backup  optimization is enabled
    • B、 Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up
    • C、 Backup optimization is permanently disabled
    • D、 Backup optimization is temporarily disabled because a redundancy-based retention policy is specified

    正确答案:B

  • 第3题:

    It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()

    • A、cannot be used in RMAN
    • B、by starting up the database again
    • C、by using the CATALOG command of RMAN
    • D、by using the RECOVER CATALOG command in RMAN
    • E、by re-creating the target control file to rebuild the RMAN repository

    正确答案:C

  • 第4题:

    You perform a backup using the following BACKUP command:   RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE;   Which statement is true of this command?()  

    • A、 A different procedure is required to restore a database from compressed backups
    • B、 The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed  backup sets and image copies.
    • C、 Using this command to create backups minimizes the bandwidth consumed
    • D、 Using this command to create backups improves the performance of the backup process

    正确答案:C

  • 第5题:

    单选题
    You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy:   CONFIGURE RETENTION POLICY TO REDUNDANCY 3;   Which statement is true?()
    A

     The command fails because you cannot configure a redundancy-based retention policy when backup  optimization is enabled

    B

     Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up

    C

     Backup optimization is permanently disabled

    D

     Backup optimization is temporarily disabled because a redundancy-based retention policy is specified


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

  • 第6题:

    多选题
    Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database.   RMAN> COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’;   Which two statements are true regarding the backup created using this command?()
    A

    The copy of the datafile created is stored in the RMAN repository.

    B

    The copy of the datafile created can be viewed using the LIST BACKUP command.

    C

    The copy of the datafile created using this COPY command can be placed only on the disk.

    D

    The copy of the datafile created is similar to the backup of the file created using the BACKUP command.

    E

    The copy of the datafile created can be used for recovering the database using the user-managed recovery method.


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

  • 第7题:

    单选题
    You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage?()
    A

     BACKUP AS BACKUPSET

    B

     BACKUP AS COPY

    C

     BACKUP AS COMPRESSED BACKUPSET

    D

     BACKUP INCREMENTAL LEVEL n CUMULATIVE


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

  • 第8题:

    单选题
    You configured the default backup device type as disk for RMAN backups. In your database,because of business requirements,you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.  What must you set using the RMAN CONFIGURE command to achieve this?()
    A

     MAXSETSIZE TO 2

    B

     DEVICE TYPE DISK PARALLELISM 2

    C

     RETENTION POLICY TO REDUNDANCY 2

    D

     DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2


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

  • 第9题:

    单选题
    You have used the CROSSCHECK BACKUP command to verify that the backups recorded in the RMAN repository actually exist.  Which command should you now use to check if any of the files were missing?()
    A

    LIST EXPIRED

    B

    DELETE EXPIRED

    C

    DELETE OBSOLETE

    D

    CHANGE UNCATALOG


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

  • 第10题:

    单选题
    Your company decided to start using RMAN in its backup strategy. Previously your company used operating system file copies. Which command is used to make RMAN aware of existing backups made by copying files at the operating system?()
    A

    CHANGE

    B

    RESYNC

    C

    CATALOG

    D

    CROSSCHECK


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

  • 第11题:

    单选题
    Which RMAN backup command is used to create the block-change tracking file?()
    A

     alter database create block change tracking file

    B

     alter database enable block change file

    C

     alter database enable block change tracking using file ,/ora01/opt/ block_change_tracking.fil

    D

     alter system enable block change tracking using file ’/ora01/opt/block_ change_tracking.fil’

    E

     alter system block change tracking on


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

  • 第12题:

    单选题
    You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace:   RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M;  Which statement is true about executing this command?()
    A

     The command generates an error.

    B

     The command backs up the tablespace and creates a backup set of size 200 MB

    C

     The command backs up the tablespace and creates two backup sets of size 100 MB each.

    D

     The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.


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

  • 第13题:

    Which RMAN backup command is used to create the block-change tracking file?()  

    • A、 alter database create block change tracking file
    • B、 alter database enable block change file
    • C、 alter database enable block change tracking using file ,/ora01/opt/ block_change_tracking.fil
    • D、 alter system enable block change tracking using file ’/ora01/opt/block_ change_tracking.fil’
    • E、 alter system block change tracking on

    正确答案:C

  • 第14题:

    You executed the following command in the Recovery Manager (RMAN):   RMAN> REPORT NEED BACKUP days 3;   What is the output of this command?()  

    • A、 A list of files that require a backup within 3 days
    • B、 A list of files requiring more than 3 days of archivelogs to apply
    • C、 A list of files that RMAN recommends be backed up only once in every three days,based on low volatility
    • D、 A list of files for which a backup as already been performed in the last three days and which is  required to be backed up again based on the high number of transactions performed on them

    正确答案:B

  • 第15题:

    You configured the default backup device type as disk for RMAN backups. In your database,because of business requirements,you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.  What must you set using the RMAN CONFIGURE command to achieve this?()  

    • A、 MAXSETSIZE TO 2
    • B、 DEVICE TYPE DISK PARALLELISM 2
    • C、 RETENTION POLICY TO REDUNDANCY 2
    • D、 DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2

    正确答案:C

  • 第16题:

    You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage?()

    • A、 BACKUP AS BACKUPSET
    • B、 BACKUP AS COPY
    • C、 BACKUP AS COMPRESSED BACKUPSET
    • D、 BACKUP INCREMENTAL LEVEL n CUMULATIVE

    正确答案:B

  • 第17题:

    多选题
    Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/ rman_change_track.f'; To perform incremental level 1 cumulative backup, you issued the following command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?()
    A

    The block change tracking data will be used only from the next incremental 0 backup.

    B

    The incremental backup will use change tracking data for accomplishing the backup.

    C

    The incremental backup will not use change tracking data for accomplishing the backup.

    D

    The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.


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

  • 第18题:

    单选题
    What is the purpose of the catalog command?()
    A

     To review RMAN control file and recovery catalog metadata and ensure that its correct

    B

     To delete RMAN backup-related metadata from the recovery catalog

    C

     To create metadata in the control file and the recovery catalog related to backup set pieces 

    D

     To create a report that lists database backups

    E

     To rebuild the recovery catalog


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

  • 第19题:

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


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

  • 第20题:

    多选题
    You issue this RMAN command:   RMAN> create script Level0Backup {   backup   incremental level 0   format ‘/u01/db01/backup/%d_%_Sp’   fileperset 5   (database include current controlfile);   sql ‘alter database archive log current’;   }  Which three statements are true about the Level0Backup script you just created?()
    A

    The script is stored only in the control file.

    B

    The script is stored only in the recover catalog.

    C

    The script can be executed only by using the RMAN RUN command.

    D

    The commands of the script can be displayed with the LIST command.

    E

    The commands of the script can be displayed with the PRINT command.

    F

    The commands of the script can be displayed with the REPORT command.


    正确答案: F,D
    解析: 暂无解析

  • 第21题:

    单选题
    You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?()
    A

    A different procedure is required to restore a database from compressed backups

    B

    The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.

    C

    Using this command to create backups minimizes the bandwidth consumed

    D

    Using this command to create backups improves the performance of the backup process


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

  • 第22题:

    单选题
    Which RMAN command is used to verify the status of a backup or copy, and also updates the repository when files have been deleted using operating system commands?()
    A

    CHANGE

    B

    RESYNC

    C

    CATALOG

    D

    CROSSCHECK


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

  • 第23题:

    单选题
    It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()
    A

    cannot be used in RMAN

    B

    by starting up the database again

    C

    by using the CATALOG command of RMAN

    D

    by using the RECOVER CATALOG command in RMAN

    E

    by re-creating the target control file to rebuild the RMAN repository


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

  • 第24题:

    单选题
    Which command is used to configure RMAN to perform a compressed backup for every backup executed?()
    A

     BACKUP AS COMPRESSED BACKUPSET DATABASE

    B

     BACKUP AS COMPRESSED COPY OF DATABASE

    C

     CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET

    D

     CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS 

    E

     BACKUP DATABASE COMPRESS


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