Oracle - 11G - 题库337 - 图文(10)

如果数据库在归档记录模式下，那么你会选择选项B欲了解更多信息，请参阅第2章，“执行Oracle用户管理 的备份。”

QUESTION NO: 76

Which of the following statements is true when the database is in ARCHIVELOG mode and

tablespaces are in hot backup mode? 下面哪个描述是真实的，当数据库处于归档记录模式且表空间处于热备份模式？

A. Archive log generation is suspended until the tablespaces are taken out of hot backup mode. B. Datafiles are not written to during hot backups.

C. Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.

D. The datafile headers are not updated during the backup. 在备份过程中不会更新数据文件头。 E. The way data is written to the online redo logs is unchanged during the backup. Answer: D

When a tablespace is in hot backup mode, the related datafile headers are not updated. The headers will be updated after the tablespaces are taken out of hot backup mode. For more information, see Chapter 2, ―Performing Oracle User-Managed Backups.‖ 当一个表空间处于热备份模式，相关的数据文件头不被更 新。表空间从热备份模式中取出后头将更新。欲了解更多信息，请参阅第2章“执行Oracle用户管理的备 份。”

QUESTION NO: 77

When you create a backup control file, where is the resulting file written to? 当您创建一个备份控制文件时，生成的文件写入哪里？

A. The database user dump destination directory B. The database diagnostic destination directory C. To $ORACLE_HOME/rdbms

D. To $ORACLE_HOME/admin

E. To the directory and filename you specify in the command你在命令中指定的目录和文件名 Answer: E

QUESTION NO: 78

If a log file becomes corrupted, it may cause the database to stall. How would you correct such a situation? 如果日志文件被损坏，可能会导致数据库停止运行。你会如何纠正这种情况？ A. Recover the online redo log from backup. B. Delete and re-create the log file.

C. Use the alter database clear logfile command to clear the log file. 使用修改数据库清除日志文件命令清除 日志文件。

D. Shut down the database and restart it.

E. Shut down the database and then mount it. Clear the log file with the alter database clear logfile command and then restart the database with alter database open resetlogs. Answer: C

QUESTION NO: 79

You have lost datafiles 1 and 3 from your database, and the database has crashed. In what order should you perform the following steps to recover your database? 你已经失去了你的数据库中的数据文件1和3， 数据库崩溃。你应该按照什么顺序执行以下步骤来恢复你的数据库？ 1. Take the datafiles that were lost offline.

2. startup mount the database 启动挂载数据库

4. Restore the datafiles that were lost 还原丢失的数据文件

5. Recover the datafiles with the recover datafile command. 用恢复数据文件命令恢复数据文件 3. Issue the alter database open command.发出修改数据库打开命令 6. Bring the datafiles back online.

7. Recover the database with the recover database command. A. 2, 1, 3, 4, 5, 6 B. 2, 4, 5, 3 C. 4, 7, 3

D. 2, 4, 7, 3 E. 2, 7, 3 Answer: B

QUESTION NO: 80

Which command is used to open the database after an incomplete recovery? 使用哪个命令在数据库不完全

恢复后打开数据库？ A. alter database open

B. alter database open repairlog C. alter database open resetlogs 修改数据库打开重置日志

D. alter database open resetlog E. alter database resetlogs open Answer: C

QUESTION NO: 81

Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generated since the previous Monday, but you have archived redo logs available from the previous Sunday and earlier. You now need to restore

your backup due to database loss. To which point can you restore your database? 你的数据库有一个昨日

（星期二）13:00 至 15:00 小时进行的备份。这是唯一的备份。您已经失去了从过去的周一以来产生的所有 的归档重做日志，但你有过去的周日和更早的归档重做日志可以利用。由于数据库丢失你现在需要恢复您的

备份。哪一点你可以恢复你的数据库？ A. 13:00 on Tuesday. B. 15:00 on Tuesday.

C. Up until the last available archived redo log on Sunday.

D. To any point; all the redo should still be available in the online redo logs. E. The database is not recoverable. 该数据库是无法恢复的。 Answer: E

The database is not recoverable. You would need all the archived redo logs generated during the backup on Tuesday, at least, to restore the database after that backup. The online redo logs are very unlikely to have all the redo that would be required. For more information, please see Chapter 3, ―Performing Oracle

User-Managed Database Recoveries.‖ 该数据库是无法恢复的。您将需要在周二备份过程中产生的所有的

归档重做日志，至少在备份后还原数据库。联机重做日志是不太可能有所有需要的重做。欲了解更多信 息，请参见第3章“执行Oracle用户管理的数据库收回。”

QUESTION NO: 82

Which of the following files cannot be backed up by RMAN? (Choose all that apply.) 以下哪些文件不能由 RMAN 进行备份？ A. Database datafiles B. Control files

C. Online redo logs 联机重做日志

D. Database pfiles数据库的参数文件

E. Archived redo

logs Answer: C,D

QUESTION NO: 83

Which of the following RMAN structures can data from a datafile span? 以下哪个 RMAN 结构记录着数据文 件的范围？

A. RMAN backup-set pieces spanning backup sets

B. RMAN backup-set pieces within a given backup set 给定备份集中的 RMAN 备份集块 C. RMAN backups D. RMAN channels

E. None of the above Answer: B

QUESTION NO: 84

Which RMAN backup command is used to create the block-change tracking file? 哪一个 RMAN 备份命令用 来创建块改变跟踪文件？

A. alter database create block change tracking file B. alter database enable block change fil …… 此处隐藏：4868字，全部文档内容请下载后查看。喜欢就下载吧 ……