单选题Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning，media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.  What would you do in this sit

题目
单选题
Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning，media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.  What would you do in this situation？（）
A

recover using Oracle Flashback Database technology

B

restore the data files from backup and perform a complete recovery

C

restore only the corrupted data file and perform tablespace recovery

D

restore the data files from backup and perform cancel-based recovery

E

restore the entire database from the most recent backup and start the instance and open the database

相似考题

1. Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）A、Take the USERS tablespace offline and re-create the lost data file.B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online

2.You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）A、 until Thursday morningB、 until that point in time when the database is openedC、 until that point in time when the recovery is performedD、 until last Sunday’s backupE、 until that point in time when the table is dropped and purgedF、 until Wednesday evening

3. You are the network administrator for All servers run Windows Server 2003. You are creating a backup schedule for the main file server. You need to create a schedule so that backup jobs are completed in the shortest amount of time possible. What should you do?（）A、Schedule a normal backup every Sunday. Schedule incremental backups every Monday through Saturday.B、Schedule a normal backup every Sunday. Schedule differential backups every Monday through Saturday.C、Schedule a copy backup every day.D、Schedule a normal backup every day.

4. A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）A、flash back all the tables in the data file， one by oneB、restore the data file to a new location and perform a media recoveryC、flash back the database; there is no need to restore the data fileD、restore the data file from the most recent backup and flash back the database

更多“单选题Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning，media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.  What would you do in this sit”相关问题

  • 第1题：

    Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5：  ’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following： The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file， and all the archived logs are accessible.   Which option would you choose？（）

    • A、flash back the corrupted blocks
    • B、use the DBMS_REPAIR package
    • C、use the RMAN TSPITR command
    • D、use the RMAN BLOCKRECOVER command
    • E、use the RESTORE DATABASE and RECOVER DATABASE commands
    • F、investigate the time at which the corruption occurred and perform a point-in-time recovery

    正确答案:D

  • 第2题：

    You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51）  ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following：  The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file and all the archived logs are accessible.  Which option would you choose？（）

    • A、 flash back the corrupted blocks
    • B、 use the DBMS_REPAIR package
    • C、 use the RMAN TSPITR command
    • D、 use the RMAN BLOCKRECOVER command
    • E、 use the RESTORE DATABASE and RECOVER DATABASE commands
    • F、 investigate the time at which the corruption occurred and perform a point-in-time recovery

    正确答案:D

  • 第3题：

    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file（）

    • A、Take the USERS tablespace offline and re-create the lost data file.
    • B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
    • C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
    • D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.

    正确答案:C

  • 第4题：

    Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation？（）

    • A、recover using Oracle Flashback Database technology
    • B、restore the data files from backup and perform a complete recovery
    • C、restore only the corrupted data file and perform tablespace recovery
    • D、restore the data files from backup and perform cancel­based recovery
    • E、restore the entire database from the most recent backup and start the instance and open the database

    正确答案:E

  • 第5题：

    单选题
    You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51）  ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following：  The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file and all the archived logs are accessible.  Which option would you choose？（）
    A

     flash back the corrupted blocks

    B

     use the DBMS_REPAIR package

    C

     use the RMAN TSPITR command

    D

     use the RMAN BLOCKRECOVER command

    E

     use the RESTORE DATABASE and RECOVER DATABASE commands

    F

     investigate the time at which the corruption occurred and perform a point-in-time recovery


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

  • 第6题：

    单选题
    You are a database administrator for your company. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do？（）
    A

    Decrease the amount of time between transaction log backups.

    B

    Configure the database to use the simple recovery model.

    C

    Configure the RECOVERY INTERVAL option to be a smaller value.

    D

    Run DBCC SHRINKFILE on the transaction log file.


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

  • 第7题：

    单选题
    Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation？（）
    A

    recover using Oracle Flashback Database technology

    B

    restore the data files from backup and perform a complete recovery

    C

    restore only the corrupted data file and perform tablespace recovery

    D

    restore the data files from backup and perform cancel­based recovery

    E

    restore the entire database from the most recent backup and start the instance and open the database


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

  • 第8题：

    多选题
    You are managing an Oracle Database 11g database. The database is open， and you plan to  performRecovery Manager （RMAN） backups.  Which three statements are true about these backups（）
    A

    The backups would be consistent.

    B

    The backups would be inconsistent.

    C

    The backups would be possible only if the database is running in ARCHIVELOG mode.

    D

    The backups would be possible only if the database is running in NOARCHIVELOG mode.

    E

    The backups need to be restored and the database has to be recovered in case of a media failure.


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

  • 第9题：

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file（）
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.

    C

    Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.

    D

    Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.


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

  • 第10题：

    单选题
    Your database operates in ARCHIVELOG mode and user/x7fmanaged consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an archivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8：30 a.m. With reference to this scenario， what would you do to recover the database？（）
    A

    restore all the data files from last Sunday’s backup， and then perform a time­based recovery

    B

    restore all the data files from last Sunday’s backup， and then perform a cancel­based recovery

    C

    restore all the data files from last Sunday’s backup， and then perform a change­based recovery

    D

    restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery


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

  • 第11题：

    单选题
    You are the network administrator for All servers run Windows Server 2003. You are creating a backup schedule for the main file server. You need to create a schedule so that backup jobs are completed in the shortest amount of time possible. What should you do?（）
    A

    Schedule a normal backup every Sunday. Schedule incremental backups every Monday through Saturday.

    B

    Schedule a normal backup every Sunday. Schedule differential backups every Monday through Saturday.

    C

    Schedule a copy backup every day.

    D

    Schedule a normal backup every day.


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

  • 第12题：

    单选题
    You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user/x7fmanaged consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged.  With reference to this scenario， up to what point in time can the data be recovered？（）
    A

    until Thursday morning

    B

    until last Sunday’s backup

    C

    until Wednesday evening

    D

    until that point in time when the database is opened

    E

    until that point in time when the recovery is performed

    F

    until that point in time when the table is dropped and purged


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

  • 第13题：

    Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning，media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.  What would you do in this situation？（）

    • A、recover using Oracle Flashback Database technology
    • B、restore the data files from backup and perform a complete recovery
    • C、restore only the corrupted data file and perform tablespace recovery
    • D、restore the data files from backup and perform cancel-based recovery
    • E、restore the entire database from the most recent backup and start the instance and open the database

    正确答案:E

  • 第14题：

    You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups.  Which three statements are true about these backups（）

    • A、The backups would be consistent.
    • B、The backups would be inconsistent.
    • C、The backups would be possible only if the database is running in ARCHIVELOG mode.
    • D、The backups would be possible only if the database is running in NOARCHIVELOG mode.
    • E、The backups need to be restored and the database has to be recovered in case of a media failure

    正确答案:B,C,E

  • 第15题：

    You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario？（）

    • A、 You must ensure that the SALES database is mounted or open.
    • B、 You must restore a backup control file to perform a block media recovery.
    • C、 You must take the tools01.dbf data file offline before you start a block media recovery.
    • D、 You must put the database in NOARCHIVELOG mode to perform a block media recovery.
    • E、 You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.

    正确答案:A,E

  • 第16题：

    You are managing an Oracle Database 11g database. The database is open， and you plan to  performRecovery Manager （RMAN） backups.  Which three statements are true about these backups（）

    • A、The backups would be consistent. 
    • B、The backups would be inconsistent.
    • C、The backups would be possible only if the database is running in ARCHIVELOG mode.
    • D、The backups would be possible only if the database is running in NOARCHIVELOG mode.
    • E、The backups need to be restored and the database has to be recovered in case of a media failure.

    正确答案:B,C,E

  • 第17题：

    单选题
    You are a database administrator for your company. A database on one of the company’s SQL Server 2005 computers stores transaction information for the company’s Web-based order system. The database is configured to use the full recovery model. Your company receives very few orders between the hours of 19：00 and 04：00. Your maximum acceptable risk for data loss is one hour. Database backups must be performed as quickly as possible. You need to develop a maintenance plan to manage this risk. What should you do？（）
    A

    Configure a Back Up Database task to do a full backup of the database every hour.Configure a Check Database Integrity task to run every hour.

    B

    Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a third Back Up Database task to do transaction log backups every hour.

    C

    Configure a Back Up Database task to do a full backup of the database every day at 19：00.Configure a second Back Up Database task to do differential backups at 09：00 and 14：00.Configure a Check Database Integrity task to run every hour.

    D

    Configure a Back Up Database task to do a full backup at 09：00 and 14：00.Configure a second Back Up Database task to do transaction log backups every hour.


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

  • 第18题：

    单选题
    Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51） ORA/x7f01110： data file 5： ’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following： The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file， and all the archived logs are accessible. Which option would you choose？（）
    A

    flash back the corrupted blocks

    B

    use the DBMS_REPAIR package

    C

    use the RMAN TSPITR command

    D

    use the RMAN BLOCKRECOVER command

    E

    use the RESTORE DATABASE and RECOVER DATABASE commands

    F

    investigate the time at which the corruption occurred and perform a point­in­time recovery


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

  • 第19题：

    单选题
    You are operating your database in NOARCHIVELOG mode. Your most recent backup includes a copy of all of the data files and the control files taken when the current log sequence number was 45. You experience disk failure on the drive on which your SYSTEM tablespace data files are stored. At the time of the failure， the current log sequence number is 98. Which files should you restore to recover from the loss of the SYSTEM tablespace data files？（）
    A

    Only the data files.

    B

    All of the data files and the control files.

    C

    Only the data files belonging to the SYSTEM tablespace.

    D

    Only the data files belonging to the SYSTEM tablespace and the control files.


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

  • 第20题：

    单选题
    You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）
    A

    Restore all the data files and open the database

    B

    Create the data file and perform tablespace recovery

    C

    No need to restore any file， just recover the database

    D

    Restore only the system data file and recover the database

    E

    Restore only lost date file and performtablespacerecovery


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

  • 第21题：

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.

    C

    Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.

    D

    Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online


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

  • 第22题：

    单选题
    A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）
    A

    flash back all the tables in the data file， one by one

    B

    restore the data file to a new location and perform a media recovery

    C

    flash back the database; there is no need to restore the data file

    D

    restore the data file from the most recent backup and flash back the database


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

  • 第23题：

    单选题
    You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）
    A

     until Thursday morning

    B

     until that point in time when the database is opened

    C

     until that point in time when the recovery is performed

    D

     until last Sunday’s backup

    E

     until that point in time when the table is dropped and purged

    F

     until Wednesday evening


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

  • 第24题：

    单选题
    Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation？（）
    A

    recover using Oracle Flashback Database technology

    B

    restore the data files from backup and perform a complete recovery

    C

    restore only the corrupted data file and perform tablespace recovery

    D

    restore the data files from backup and perform cancel-based recovery

    E

    restore the entire database from the most recent backup and start the instance and open the database


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

相关内容