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. 所有注册的数据库的备份信息 可以存储在一个地方。
D. Database backups are automatically deleted when they are older than the specified time period. Answer: A,C
QUESTION NO: 104
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. 您正在使用带有恢复目录功能的恢复管理器（RMAN） 备份您的生产数据库。备份和归档重做日志文件复制到磁带驱动器作为每天的基础工作。由于介质故障时， 你随着恢复目录数据库完全失去了你的生产数据库。你要恢复目标数据库，并使其恢复功能。
You could consider performing the following steps to accomplish this task: 你可以考虑执行下列步骤来完成 这项任务：
1) Restore an autobackup of the server parameter file. 2) Restore the control file.
3) Start the target database Instance. 4) Mount the database. 5) Restore the data files.
6) Open the database with the RESETLOGS option. 7) Recover the data files.
8) Set DBID for the target database
Which option illustrates the correct sequence that you must use? 哪个选项阐明了你必须使用的正确的顺序？
A. 8, 1, 3, 2, 4, 5, 7, 6 B. 1, 8, 3, 4, 2, 5, 7, 6 C. 1, 3, 4, 2, 8, 5, 6, 7 D. 1, 3, 2, 4, 6, 5, 7, 8 Answer: A
QUESTION NO: 105
You configured the default backup device type as disk for RMAN backups. In your database, because of business requirements, you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. 您配置了 RMAN 备份的默认备份设备类型为磁盘。在您的数据库，由于业务需 求，当 RMAN 备份命令使用时，你必须要同时成对备份数据文件。
What must you set using the RMAN CONFIGURE command to achieve this? 使用 RMAN 配置命令来实现 这个，你必须设置什么？ A. MAXSETSIZE TO 2;
B. DEVICE TYPE DISK PARALLELISM 2;
C. RETENTION POLICY TO REDUNDANCY 2; 保留策略到冗余 2; D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2; Answer: C
QUESTION NO: 106
Examine the following ALTER command;
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?
A. It cancels all pending disk drops within the disk group. 取消磁盘组内所有挂起的磁盘删除。 B. It adds previously dropped disks back into the disk group.
C. It restores disks that are being dropped as the result of a DROP DISKGROUP operation.
D. It mounts disks in the disk group for which the drop-disk operation has already been completed.
E. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed. Answer: A
QUESTION NO: 107
Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. 你的数据库运行在归档记录模式。数据文件之一，USBRDATAOI.DBF，在用户表空间已 损坏，需要恢复文件到故障点。数据文件的备份是可用的。
Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)? (Choose three.) 哪三个文件将被用来在由数据库管理员（DBA）进行用户管理的恢复 过程？
A. redo logs重做日志 B. control file控制文件
C. temporary files of temporary tablespace
D. the latest backup of only the damaged data file 只有损坏的数据文件的最新备份 E. the latest backup of all the data files In the USERS tablespace Answer: A,B,D
QUESTION NO: 108
You want to set the following Initialization parameters for your database Instance 你想为你的数据库实例设 置初始化参数如下
LOG_ARCHIVE_DEST_1 =
?LOCATION=/disk1/arch‘ LOG_ARCHIVE_DEST_2 = ?LOCATION=/disk2/arch‘ LOG_ARCHIVB_DEST_3 = ?LOCATION=/disk3/arch‘ LOG_ARCHIVE_DEST_4 = ?LOCATION=/disk3/arch‘ Identify the statement that correctly describes this setting.
A. The MANDATORY location must be a flash recovery area. B. The optional destinations may not use the flash recovery area.
C. This setting is not allowed because the first destination is not set as MANDATORY.
D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination. 联机重做日志文件是不允许被覆盖，如果归档记录不能创建在第四目的地 Answer: D
QUESTION NO: 109
View the Exhibits: Exhibit 1 and Exhibit 2.
Both processes use an existing job template PROG_1. The time taken by the Jobs is recorded in the TEST_LOG table. 这两个过程使用现有的作业模板PROG_1。所采取的工作时间被记录在测试日志表。 It was observed that the job creation process in Exhibit 1 takes less time than In Exhibit2. What is the reason for this? 据观察，图表1作业创建进程比图表2花费较少的时间。这是什么原因？
A. It creates less metadata for jobs. 它创建较少的作业元数据 B. It creates Jobs temporarily in memory only.
C. It writes the Job metadata to disk in compressed format.
D. It updates tables In the SYSTEM tablespace instead of creating new tables. Answer: A
QUESTION NO: 110