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

QUESTION NO: 21

Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.) 关于自动任务后台进程（ABP）的功能哪三种说法是真实的？ A. It creates jobs without considering the priorities associated with them.

B. It translates tasks into jobs for execution by the scheduler. 它把任务转换成由调度器执行的作业。 C. It determines the list of jobs that must be created for each maintenance window. 间隔时间 它决定了必须建立每个维护窗口的作业列表。

D. It is spawned by the MMON background process at the start of the maintenance window. 它在维护窗口开始的时候，由可管理性监视器后台进程衍生出来。（Manageability Monitor可管理性监视 器）

E. It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks. Answer: B,C,D

QUESTION NO: 22

Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g? (Choose all that apply.) 哪些说法是正确的关于Oracle数据库11g 中的故障诊断能力基础架构的问题和事件的概念？

A. Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository (ADR). B. The problem key is the same as the incident number.

C. The database sends an incident alert to the Oracle Enterprise Manager Database Home page. 数据库发出事故警报到Oracle企业管理器数据库主页。

D. Every problem has a problem key, which is a text string that describes the problem. 每个问题 都有一个问题的钥匙，这是一个描述问题的文本字符串。

E. The database makes an entry into the alert log file when problems and incidents occur. 当问题和事故发生时，数据库生成进入警报日志文件的入口。 Answer: C,D,E

QUESTION NO: 23

What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.) 关于从SQL访问顾问收到的建议，哪两个陈述是真实的？

A. It cannot generate recommendations that support multiple workload queries.

B. It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type. 它可以建议在表上进行分区，如果这些表的工作负载在数 字或日期类型的列上有一些谓词（判断）和连接。

C. It can recommend partitioning only on tables that have at least 10,000 rows. 它建议只有在有至少 10,000行的表进行分区。

D. It can recommend only B-tree indexes and not bitmap or function-based indexes. Answer: B,C

QUESTION NO: 24

You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours: 你正用具有高冗余的 ASM存储来管理Oracle11g数据库。五个小时后发出下面的命令去从DGA磁盘组中删除磁盘： ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H; 修改DGA磁盘组 ，离线磁盘，在f2故障组， 5小时后删除; Which statement is true in this scenario? A. It starts the ASM fast mirror resync.

B. All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.

C. It drops all disk paths from the dga disk group.

D. All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours. 在F2故障组的DGA磁盘组中的所有磁盘将下线且磁盘修复时间磁盘 属性将设置到5个小时。 Answer: D

QUESTION NO: 25

Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.) 哪种说法描述了在RMAN中更改故障命令的意义？

A. It is used to change failure priority only for HIGH or LOW priorities. 它是只用来改变故障的优先级为高或低优先级。 B. It is used to execute the advised repair script.

C. It is used to change failure priority only for the CRITICAL priority.

D. It is used to explicitly close the open failures. 它是用来显式地关闭打开的故障。 E. It is used to inform the database about the repair after the repair script executes. Answer: A,D

QUESTION NO: 26

Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.) 关于通过使用EM工作台支持以创建一个事件包文件，哪些描述是 真实的？

A. You can add or remove the trace files to the package. 您可以添加或删除包的跟踪文件。

B. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created. 您可以创建增量的事件包ZIP文件，用于已创建事件包的新的或修改 的诊断信息。

C. You can add SQL test cases to the incident package. 您可以添加SQL测试用例（判例案件）到事件包。 D. You cannot create an incremental incident package when the physical files are purged from the ADR. Answer: A,B,C

QUESTION NO: 27

The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this? 应用程序表由测试数据库中的测试用户所拥有，该数据库需要使用数据泵导出到 生产数据库中的APPS方案。你会用数据泵导入的哪个选项来做到这一点？ A. owner B. touser C. attach …… 此处隐藏：2555字，全部文档内容请下载后查看。喜欢就下载吧 ……