Which RMAN backup command is used to create the block-change tracking file？（）  A、 alter database create block change tracking fileB、 alter database enable block change fileC、 alter database enable block change tracking using file ，/ora01/opt/ block_change

题目

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
相似考题

1.Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?()A. Provide a password for the encryptionB. Set up an Oracle wallet for the encryptionC. No setup is required as it is a default encryption methodD. Both Oracle wallet and password must be set up for the encryption

2.For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）A、RMAN image copiesB、RMAN database backupsC、RMAN tablespace backupsD、user­managed backups placed in the flash recovery areaE、user­managed backups that have been cataloged with RMANF、user­managed data file backups for which the full path name is specified

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

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

更多“Which RMAN backup”相关问题

  • 第1题：

    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

    正确答案:C

  • 第2题：

    You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?（）

    • A、RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE
    • B、RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE
    • C、RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE 
    • D、RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE

    正确答案:A

  • 第3题：

    When you are allowing RMAN to backup your archived redo log files，how does RMAN know which archived redo logs to back up from your archive log destination？（）

    • A、RMAN keeps a list of archive logs in a text file.
    • B、The DBA must manually tell RMAN which archive logs to backup.
    • C、RMAN has access to target control file and/or catalog information.
    • D、RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.

    正确答案:C

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

    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

  • 第7题：

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

  • 第8题：

    单选题
    Examine the following RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?（）
    A

    Provide a password for the encryption

    B

    Set up an Oracle wallet for the encryption

    C

    No setup is required as it is a default encryption method

    D

    Both Oracle wallet and password must be set up for the encryption


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

  • 第9题：

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

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

    单选题
    As A DBA， which of the following methods can you use to make a backup of your table？（）
    A

    Recover Manager （RMAN） utility

    B

    Import utility

    C

    Export utility

    D

    O/S backup command


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

  • 第12题：

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

  • 第13题：

    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

    正确答案:C

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    Examine the following RMAN command：   RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON； RMAN> BACKUP DATABASE PLUS ARCHIVELOG；   Which prerequisite must be met before accomplishing the backup？（）

    • A、 Provide a password for the encryption
    • B、 Set up an Oracle wallet for the encryption
    • C、 No setup is required as it is a default encryption method
    • D、 Both Oracle wallet and password must be set up for the encryption

    正确答案:B

  • 第17题：

    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

  • 第18题：

    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

  • 第19题：

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

  • 第20题：

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

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

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


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

  • 第23题：

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

  • 第24题：

    多选题
    Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）
    A

    control file

    B

    all datafiles

    C

    password file

    D

    online redo log file

    E

    archive redo log file

    F

    server parameter file

    G

    only the SYSTEM datafile


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

相关内容