Oracle_11G_题库337(5)

View the Exhibit and examine the output. 参观图表，并检查输出。

You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table: ALTER TABLE exchange_rate FLASHBACK ARCHIVE; What is the outcome of this command? 执行以下 命令以启用汇率表上的闪回数据归档：更改汇率表闪回归档;这个命令的结果是什么？

A. The Flashback Archive is created on the same tablespace where the tables are stored. B. The Flashback Archive is created on the SYSAUX tablespace.

C. The command generates an error because no Flashback Archive name is specified and there is no default Flashback Archive. 该命令会产生一个错误，因为闪回归档没有指定名称并且没有默认闪回归档。 D. The table uses the default Flashback Archive. Answer: C

QUESTION NO: 67（重复） Exhibit #1:

Exhibit #2:

View the Exhibits exhibit1 and exhibit2. 查看图表exhibit1和exhibit2。

Both the processes use PROG_1 as the job template that is already available. The time taken by the jobs are recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in exhibit1 takes less time than the process in exhibit2. What is the reason for this? 这两个进程都使用 PROG_1作为可用的作业模板。作业所花的时间记录在测试日志表上。比较创建作业所花费的时间， exhibit1表的进程比exhibit2的进程花费较少的时间。这是什么原因呢？

A. It updates several tables in the SYSTEM tablespace instead of creating new tables. B. It creates jobs temporarily in memory only. C. It creates less metadata for the jobs. 它创建较少的作业元数据

D. It writes the job metadata to disk in compressed format. Answer: C

QUESTION NO: 68 Exhibit:

View the Exhibit to examine a portion of the output from the VALIDATE DATABASE command. 查看图表，从验证数据库命令检查输出部分。

Which statement is true about the block corruption detected by the command? 关于该命令检测到的块损坏哪种说法是正确？

A. No action is taken except the output in the Exhibit.

B. The ADVISE FAILURE command is automatically called to display the repair script. C. The failure is logged into the Automatic Diagnostic Repository (ADR). 该损坏被登录 到自动诊断信息库（ADR）。

D. The corruption is repaired by the command implicitly. Answer: C

QUESTION NO: 69？ Exhibit #1:

Exhibit #2:

View the Exhibit exhibit1 to observe the maintenance window property. View the Exhibit exhibit2 to examine the output of the query. 查看图表exhibit1以观察维护窗口属性。查看图表exhibit2以检查查询输 出。

Which two statements describe the conclusions? (Choose two.) 哪两个语句描述该结论？ A. RESOURCE_PERCENTAGE should be increased. 应增加资源百分比。 B. The repeat time for the window should be decreased. C. RESOURCE_PERCENTAGE should be decreased.

D. The window duration should be increased. 应增加窗口的持续时间。 Answer: A,D QUESTION NO: 70

ASM supports all but which of the following file types? (Choose all that apply.) ASM 支持所有的除了以下哪 些文件类型？ A. Database files B. Spfiles

C. Redo-log files D. Archived log files E. RMAN backup sets F. Password files密码文件 G. init.ora files 初始.ora文件

Answer: F,G

QUESTION NO: 71

After executing the command alter diskgroup disk group2 drop disk dg2a; you issue the following command from the ASM instance: 在执行更改磁盘组 磁盘 组2 删除磁盘 dg2a命令之后，你从ASM实例发 出以下命令：

Select group_number, count(*) from v$asm_operation; 从ASM操作视图选择组号和行数;

What is the implication if the query against V$ASM_OPERATION returns zero rows?如果查询违反ASM操 作视图，返回零行的含义是什么？

A. The drop disk operation is still proceeding and you cannot yet run the undrop disks operation. B. The drop disk operation is complete and you can run the undrop disks command if needed.

C. The drop disk operation is complete and you cannot run the undrop disk command. 删除磁盘操作完成， 你不能运行撤销删除磁盘命令。

D. The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance. E. None of the above is true. Answer: C

QUESTION NO: 72

What is the net effect of the following command? 下面的命令最终效果是什么？ alter diskgroup dgroup1 drop disk abc; 改变磁盘组 DGROUP1 删除磁盘ABC

A. The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command, the data on that disk will be lost.

B. The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.

C. The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete, the disk will be dropped. 在删除操作期间磁盘组将自动重新平衡。一旦完成再平衡，磁盘将被删除。 D. This command will fail because you cannot drop a specific disk in an ASM disk group.

E. The disk drop command will be suspended for a predetermined amount of time, waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command, ASM will proceed to rebalance the disk group and then drop the disk. Answer: C

QUESTION NO: 73

Which of the following is not a configurable attribute for an individual disk group? 下列哪项不是一个单个磁盘组可配置的属性？ A. AU_SIZE

B. COMPATIBLE.RDBMS C. COMPATIBLE.ASM D. DISK_REPAIR_TIME

E. DG_DROP_TIME磁盘组删除时间

Answer: E

QUESTION NO: 74

What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in

NOARCHIVELOG mode?

当数据库运行在归档记录模式而不是在非归档记录模式，Oracle进程运行什么？ A. MMON B. LGWR

C. ARCH 归档 D. ARWR E. COPY Answer: C

QUESTION NO: 75

You are peer reviewing a fellow DBA‘s backup plan for his NOARCHIVELOG mode database, as shown here: 您同等地评估一位同行的 DBA 备份计划用于他的非归档记录模式数据库，如下所示： 1. Put the tablespaces in backup mode. 2. Back up the datafiles for all tablespaces. 3. Take the tablespaces out of backup mode. 4. Back up all archived redo logs. 1。将表空间置于备份模式。 2。备份所有表空间的数据文件。 3。将表空间带出备份模式。 4。备份所有归档重做日志。

Your colleague asks for you to comment on his plan. Which response would be correct? 你的同事要求你对他的计划发表评论。哪个响应是正确的？ A. The plan will work as is.

B. The plan needs to be modified to allow for an archive-log switch after step 3. 该计划 需要进行修改以允许第3步后存档日志切换。

C. The plan needs to be modified so that a backup of the archived redo logs occurs before step 1. D. The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.

E. The plan cannot work as presented. 计划不能像所呈列的那样工作 Answer: E

Since the database is in NOARCHIVELOG mode, the entire plan will not work since you can not

perform hot backups in NOARCHIVELOG mode. If the database was in ARCHIVELOG mode, then you would

choose option B. For more information, see Chapter 2, ―Performing Oracle User-Managed Backups.‖ 由于 数据库是在非归档记录模式下，整个计划将无法正常工作，因为你不能在非归档记录模式下执行热备份。

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库Oracle_11G_题库337(5)在线全文阅读。