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

B. Lists all backups that are subject to retention criteria

C. Lists all backups that are missing associated physical backup set pieces 列出所有缺失的与物理备份集 片相关的备份

D. Lists the status of datafile backup failures due to the use of the duration command

E. Lists backups that cannot be used by the restore command because they have been marked as disabled Answer: C

QUESTION NO: 96

What is the purpose of the catalog command? 目录命令的目的是什么？

A. To review RMAN control file and recovery catalog metadata and ensure that it‘s correct B. To delete RMAN backup-related metadata from the recovery catalog

C. To create metadata in the control file and the recovery catalog related to backup set pieces，创建与备份 集片相关的控制文件和恢复目录中的元数据

D. To create a report that lists database backups E. To rebuild the recovery catalog Answer: C

元数据的定义为“有关数据的结构数据”，例如某个数据库中的表和视图的个数及名称，某个表或者视图中 列的个数以及每一列的名称、数据类型、长度、精度、描述等，某个表上定义的约束，某个表上定义的索引 以及主键/外键的信息

QUESTION NO: 97

Which of the following commands will fail? 下面的哪条命令将失败？ A. report schema;

B. report need backup;

C. report need backup days 3; D. report user;报告用户; E. report obsolete; Answer: D

QUESTION NO: 98

What are the two different types of database duplication? (Choose two.) 两种不同类型的数据库复制是什 么？

A. Active 活跃 B. Passive C. Online

D. Backup-based 基于备份 E. Failure driven Answer: A,D

QUESTION NO: 99

When you‘re performing a tablespace point-in-time recovery, which tablespaces will always be restored to the auxiliary instance? (Choose all that apply.)

当你执行一个表空间时间点的恢复，哪些表空间总是会被恢复到辅助实例？

A. The SYSTEM tablespace. 系统表空间。 B. The UNDO tablespace. 撤销表空间 C. All tablespaces with tables. D. All tablespaces with indexes.

E. No tablespaces are automatically restored. Answer: A,B

QUESTION NO: 100

Which operation requires that you create an auxiliary instance manually before executing the operation? (Choose all that apply.) 执行操作之前，哪个操作需要你手动创建一个辅助实例？ A. Backup-based database duplication. 基于备份的数据库复制 B. Active database duplication. 活动数据库复制。 C. Tablespace point-in-time recovery.

D. No operation requires the creation of an auxiliary instance. Answer: A,B

QUESTION NO: 101

Note the output of the following query; 请注意下面的查询的输出;

SQL> SELECT flashback_archieve_name, status FROM dba_flashback_archieve; 从DBA闪回归档选择闪回存档名称、状态

FLASHBACK_ARCHIEVE_NAME STATUS FLA1闪回归档名称状态FLA1

You executed the following command to enable Flashback Data Archive on the EXCHANG_RATE table: 你执行以下命令以在汇率表上启用闪回数据归档，：

ALTER TABLE exchange_rate FLASHBACK ARCHIEVE; 更改汇率表闪回归档; What is the outcome of this command? 这个命令的结果是什么？

A. The table uses the default Flashback Data Archive. 该表使用默认闪回数据归档。 B. The Flashback Data Archive Is created In the SYSAUX tablespace.

C. The Flashback Data Archive is created in the same tablespace where the tables are stored.

D. The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve. Answer: A

QUESTION NO: 102

A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member. A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. 数据库正在运行在归档 XXMS 模 式。它有两个联机重做日志组，每组有一名成员。 一个 LGWR 输入/输出（I / O）失败是由于永久介质故 障，该故障导致重做日志文件丢失和 LWGR 终止导致实例崩溃。

The steps to recover from the loss of a current redo log group member in the random order are as follow.从 在如下的随机顺序的当前重做日志组的成员的损失中恢复过来的步骤如下。 1) Restore the corrupted redo log group. 2) Restore from a whole database backup.

3) Perform incomplete recovery. 执行不完全恢复。

4) Relocate by renaming the member of the damaged online redo log group to a new location. 通过重命名 迁移损坏的联机重做日志组的成员到一个新的位置。

5) Open the database with the RESETLOGS option.用重置日志选项打开数据库。 6) Restart the database instance.

7) Issue a checkpoint and clear the log. 发出一个检查点并清除日志。

Identify the option with the correct sequential steps to accomplish the task efficiently.

确定带有正确顺序步骤的选项以有效地完成任务。 A. 1, 3, 4, and 5 B. 7, 3, 4. and 5 C. 2, 3, 4, and 5 D. 7, 4, 3. and 5 E. Only 6 is required Answer: B

QUESTION NO: 103

Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager (RMAN). (Choose two.) 标识出目标数据库恢复管理器（RMAN）的控制文件恢复目录负 载的两个优势。

A. You can use RMAN stored scripts. 您可以使用 RMAN 存储脚本。

B. Recovery is faster if data is stored in catalog in addition to the control file.

C. You can store backup Information of all registered databases in one place. 所有注册的数据库的备份信息 可以存储在一个地方。 …… 此处隐藏：2577字，全部文档内容请下载后查看。喜欢就下载吧 ……