niusouti.com

You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command? （）A、After two days, a backup will be marked obsoleteB、After two days, a backu

题目

You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command? （）

  • A、After two days, a backup will be marked obsolete
  • B、After two days, a backup will be deleted from the media
  • C、If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.
  • D、If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.
相似考题

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.How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）  A、 Issue the grant command from the SYS user （or equivalent） of the target database.B、 Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E、 Issue the grant command from RMAN when connected to the target database.

3. 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 fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile

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

更多“You issue the following RMAN co”相关问题

  • 第1题：

    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

  • 第2题：

    You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command：       RMAN>BACKUP DATABASE；  At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）

    • A、 Start the database in the MOUNT stage.
    • B、 Back up the control file to trace.
    • C、 Set the DBID
    • D、 Issue the RECOVER DATABASE command.

    正确答案:C

  • 第3题：

    You issue the following command on the RMAN prompt.   RMAN> REPORT NEED BACKUP DAYS = 5 DATABASE；   Which statement is true about executing this command？（）

    • A、 It will display a list of files that need incremental backup.
    • B、 It will display a list of files that need backup after five days.
    • C、 It will display a list of files that were backed up in the last five days.
    • D、 It will display a list of files that have not been backed up in the last five days.
    • E、 It will apply the current retention policy to determine the files that need to be backed up.

    正确答案:D

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


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

  • 第5题：

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

  • 第6题：

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

  • 第7题：

    单选题
    Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN > BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?（）
    A

    Place the root container in ARHCHIVELOG mode.

    B

    Take the user data tablespace offline.

    C

    Place the root container in the nomount stage.

    D

    Ensure that HR_PDB is open.


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

  • 第8题：

    单选题
    You issue the following command：   RMAN>CONFIGURE BACKUP OPTIMIZATION ON；   What is the result of this command on your backups？（）
    A

     An incremental backup strategy will be used automatically.

    B

     Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.

    C

     RMAN will configure itself for maximum performance at the cost of CPU.

    D

     RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.

    E

     RMAN will automatically compress backups.


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

  • 第9题：

    单选题
    Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the  database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands：        RMAN>RESTORE DATABASE；        RMAN>RECOVER DATABASE；   After successfully executing these RMAN commands， you issue the following statement using SQL*Plus：        SQL>ALTER DATABASE OPEN；   You receive the following errors when attempting to open the database：        ORA-01157： cannot identify/lock data file 10 see DBWR trace file        ORA-01110： data file 10： ’D:///USERS.DBF’   What is the cause of these errors？（）
    A

     The USERS.DBF datafile is corrupted and cannot be restored by RMAN.

    B

     The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.

    C

     The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.

    D

     The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.


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

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

    多选题
    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
    A

    when you change the name of a datafile

    B

    when you drop a table from the database

    C

    when you take an export of the database

    D

    when you back up the database using OS utilities

    E

    when you issue an ALTER SYSTEM SWITCH LOGFILE statement

    F

    when you issue a BACKUP command from inside the RMAN run block


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

  • 第12题：

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

  • 第13题：

    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

    • A、 when you change the name of a datafile
    • B、 when you drop a table from the database
    • C、 when you take an export of the database
    • D、 when you back up the database using OS utilities
    • E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
    • F、 when you issue a BACKUP command from inside the RMAN run block

    正确答案:A,E,F

  • 第14题：

    You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）

    • A、 target database
    • B、 auxiliary database
    • C、 third-party database
    • D、 recovery catalog database

    正确答案:C

  • 第15题：

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

  • 第16题：

    单选题
    You issue the following RMAN command to set a retention policy on a database：   RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2；   What will be the outcome of issuing this command？（）
    A

     After two days，a backup will be marked obsolete

    B

     After two days，a backup will be deleted from the media

    C

     If the RMAN repository has records of two or more recent backups of a file，then older backups will be deleted from the media.

    D

     If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete.


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

  • 第17题：

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

  • 第18题：

    单选题
    How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）
    A

     Issue the grant command from the SYS user （or equivalent） of the target database.

    B

     Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.

    C

     Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.

    D

     Issue the grant command from RMAN when connected to the recovery catalog-owning schema.

    E

     Issue the grant command from RMAN when connected to the target database.


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

  • 第19题：

    单选题
    You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message：   SQL> startup ORA-01078： failure in processing system parameters LRM-00109：  could not open parameter file ，  C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN，   how would you respond to this error？（）
    A

     Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.

    B

     Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.

    C

     Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.

    D

     Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.

    E

     Issue the restore spfile from autobackup command from the RMAN prompt.


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

  • 第20题：

    单选题
    You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?（）
    A

    After two days, a backup will be marked obsolete

    B

    After two days, a backup will be deleted from the media

    C

    If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.

    D

    If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.


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

  • 第21题：

    单选题
    You enable block change tracking. You issue the following command：   BACKUP INCREMENTAL LEVEL 0 DATABASE；   The next day，you issue the following command：   BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE；   Which statement about the use of the change tracking file is true？（）
    A

     RMAN reads the block change tracking file only when it performs the incremental level 0 backup.

    B

     RMAN reads the block change tracking file when it performs both incremental backups.

    C

     RMAN reads the block change tracking file only when it performs the incremental level 1 backup.

    D

     RMAN does not read the block change tracking file when it performs either incremental backup.


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

  • 第22题：

    单选题
    You are creating a recovery catalog for use with RMAN. You have issued these commands： SQL> CREATE TABLESPACE rman_ts DATAFILE  ’/DISK1/rman_ts01.dbf’ 2> SIZE 20M 3> DEFAULT STORAGE （initial 100K next 100K pctincrease 0）； SQL> CREATE USER rman_db01 IDENTIFIED BY rman_db01 2> DEFAULT TABLESPACE rman_ts 3> QUOTA unlimited ON rman_ts；  Which command should you issue next？（）
    A

    RESYNC CATALOG；

    B

    REGISTER DATABASE；

    C

    CREATE CATALOG TABLESPACE rman_ts；

    D

    GRANT recovery_catalog_owner TO rman_db01；


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

  • 第23题：

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

  • 第24题：

    单选题
    You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）
    A

     target database

    B

     auxiliary database

    C

     third-party database

    D

     recovery catalog database


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

相关内容