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

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