oracle 10g例题,Oracle 10G OCP 1z0-043题库

Oracle 10G OCP 1z0-043题库分享

以下是Test-passport整理的最新Oracle 10G OCP 1z0-042题库

1. You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use?

你需要检查在雇员表的物理损坏EMP_EAST分区。你还需要验证该行属于正确的分区。你可以使用哪些选项？

A.LogMiner

B.the DBNEWID utility

C.the DBVERIFY utility

D.the ANALYZE command

=============

validate structure

=============

用于分析表或者索引结构的一致性,判断索引与表间是否匹配,有没有坏块,数据是不是正确分布在正确的分区中,索引压缩效率等...他不是用来分析用于优化SQL所需要的信息.所以也不会在DBA_INDEXES,DBA_TABLES中保存信息.

检验碎片用analyze index/table.... validate structure，这些信息存在index_stats中.

E.the RMAN REPORT command

F.the RMAN CROSSCHECK command

G.the RMAN BLOCKRECOVER command

ANSWER: D

2. You execute the following command to enable a session in resumable mode:

您执行以下命令，以启用会话中可恢复模式

SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60;

What is the impact of a timeout on the statements being suspended?

什么是一个关于被停止发言超时的影响？

A.The statements remain suspended for at least 60 seconds.

B.The statements are suspended for 60 seconds and then they are executed.

C.The suspended statements error out if the problem is not rectified within 60 seconds.

悬浮的语句错误了如果不在 60 秒内纠正的问题。

D.The statements are automatically suspended 60 seconds after an error is received, and then attempt to

execute normally again.

ANSWER: C

3. Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management (ASM) instance, you find that the performance of the database decreases initially, until the addition or removal process is completed. Performance then gradually returns to normal levels.Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.)

直接通过自动存储管理器(ASM)的实例,添加新的磁盘或者删除已存在的磁盘,你发现完成数据设备的初始化,直到添加或删除进程结束.逐步执行后返回到正常的水平.在添加或删除磁盘过程中,你能维护数据库的一致性的两个活动?

A.increase the number of checkpoint processes

B.define the POWER option while adding or removing the disks

确定电力方案，同时添加或删除磁盘

C.increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES

D.increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES

E.increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT du