niusouti.com

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

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

相似考题

1.You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）A、A backup of the target database when it is mountedB、A backup of online redo log files when the database is openC、A backup of only used data blocks in the file beingbeingbackup upD、A backup of online， read/write data files when the database is openE、A backup of only those data blocks that have changed since a previous backupF、A backup of online， read/write data files when the database is in the NOMOUNT state.

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

3.Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）A、 Backup of offline tablespaces.B、 Backup of read-only tablespaces.C、 Backup of system-critical tablespaces.D、 Backup of online， locally managed tablespaces.E、 Backup of read/write dictionary-managed tablespaces.

4.Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）A、You need to perform the restore and recover operations manually, because the backup was made manually. B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

更多“单选题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 ”相关问题

  • 第1题：

    Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）

    • A、backup of offline tablespaces
    • B、backup of read­only tablespaces
    • C、backup of system­critical tablespaces
    • D、backup of online， locally managed tablespaces
    • E、backup of read/write dictionary­managed tablespaces

    正确答案:A,B

  • 第2题：

    You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

    • A、 online redo log files
    • B、 alert log files
    • C、 control file
    • D、 datafiles associated with the SYSTEM tablespace

    正确答案:C

  • 第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 executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN> BACKUP TABLESPACE DETTBS；  Under which conditions would this command execute successfully？ （）

    • A、 The database is in NOMOUNT state.
    • B、 The database is in NOARCHIVELOG mode and the tablespace is online.
    • C、 The database is in NOARCHIVELOG mode and the tablespace is offline.
    • D、 The database is in ARCHIVELOG mode and the tablespace is offline.
    • E、 The database is in ARCHIVELOG mode and the tablespace is online.

    正确答案:C,D,E

  • 第5题：

    You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？ （）

    • A、SQL script
    • B、PL/SQL script
    • C、Operating System （OS） script
    • D、Enterprise Manager （EM） script
    • E、Recovery Manager （RMAN） script

    正确答案:E

  • 第6题：

    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

  • 第7题：

    多选题
    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）
    A

    A backup of the target database when it is mounted

    B

    A backup of online redo log files when the database is open

    C

    A backup of only used data blocks in the file beingbeingbackup up

    D

    A backup of online， read/write data files when the database is open

    E

    A backup of only those data blocks that have changed since a previous backup

    F

    A backup of online， read/write data files when the database is in the NOMOUNT state.


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

  • 第8题：

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

  • 第9题：

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


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

  • 第10题：

    单选题
    While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）
    A

    configure the database to run in ARCHIVELOG mode

    B

    configure the Flash Recovery Area to enable automatic database backup

    C

    schedule the database backup using DBMS_JOB package after creating the database

    D

    schedule the database backup using Recovery Manager （RMAN）commands after creating the database

    E

    schedule the database backup using Database Configuration Assistant （DBCA）while creating the database


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

  • 第11题：

    单选题
    Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）
    A

    You need to perform the restore and recover operations manually, because the backup was made manually. 

    B

    First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 

    C

    First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 

    D

    You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 


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

  • 第12题：

    单选题
    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup？（）
    A

     Database Datafiles

    B

     Database Control Files

    C

     Online redo logs

    D

     Archived redo logs

    E

     The database SPFILE

    F

     None of the above，all these files are backed up


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

  • 第13题：

    While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）

    • A、configure the database to run in ARCHIVELOG mode
    • B、configure the Flash Recovery Area to enable automatic database backup
    • C、schedule the database backup using DBMS_JOB package after creating the database
    • D、schedule the database backup using Recovery Manager （RMAN）commands after creating the database
    • E、schedule the database backup using Database Configuration Assistant （DBCA）while creating the database

    正确答案:E

  • 第14题：

    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

  • 第15题：

    In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE;  Which two operations do you need to perform after restoring the control file from backup？（）

    • A、shut down and restart the instance
    • B、add new tempfiles to the temporary tablespaces after recovery
    • C、perform a media recovery and open the database with the RESETLOGS option
    • D、perform a media recovery and bring the database to NOARCHIVELOG mode

    正确答案:B,C

  • 第16题：

    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）

    • A、Database Datafiles 
    • B、Database Control Files 
    • C、Online redo logs
    • D、Archived redo logs 
    • E、The database SPFILE 
    • F、None of the above, all these files are backed up. 

    正确答案:C

  • 第17题：

    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

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

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


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

  • 第20题：

    单选题
    You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）
    A

     online redo log files

    B

     alert log files

    C

     control file

    D

     datafiles associated with the SYSTEM tablespace


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

  • 第21题：

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


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

  • 第22题：

    多选题
    You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully？ （）
    A

    The database is in NOMOUNT state.

    B

    The database is in ARCHIVELOG mode and the tablespace is online.

    C

    The database is in ARCHIVELOG mode and the tablespace is offline.

    D

    The database is in NOARCHIVELOG mode and the tablespace is online.

    E

    The database is in NOARCHIVELOG mode and the tablespace is offline.


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

  • 第23题：

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

相关内容