Oracle 053 1-124译文版

阅读053考试指南，你能知道因果！

比较菜的译文，请大家谅解！

声明整个题库至少有10题左右的答案出入。

你正在管理一个oracle11g ASM实例（有3个硬盘在磁盘组，用ASM兼容性属性设置为11.1.0；冗余设置为high）。磁盘组中某个磁盘变成unavailable，因为电源故障。这种场景下，那个语句描述是正确的：

B. The ASM tracks theextents that are modified during the outa；ASM故障期间跟踪修改的extents，不会迁移区间到有效盘上。

D. The diskautomatically goes offline.该磁盘自动offline,但不会dropped

 

 

Explanation:

QUESTION NO:7(Jesse)

 (Choose three.)关于sql 计划基线正确的3个语句：

A. The plans generated for every SQL statement are stored inthe SQL plan baseline  by  default.

B. The plans can bemanually loaded to the SQL plan baseline.计划可以手工导入到SQL计划基线中

C. The plan baselines are stored temporarily in the memoryas long as the database instance is running.

D. The plans in theSQL plan baseline are verified and accepted plans. SQL计划基线中的计划是被验证和接受的计划

E. For the SQL planbaselines to be accessible to the optimizer, the SYSAUX tablespace must be online.

对于SQL计划基线可以访问相对于优化器来说，SYSAUX表空间必须在线。

 

—问题？每条SQL语句产生的计划存储在哪里？

 

 

Explanation:

QUESTION NO:11 (Jesse)

 (Choose three.)关于persistentlightweight jobs永久性轻量级工作描述正确的3句：

A. Persistent lightweight jobs modify several tables in thedata dictionary to generate a lot of redo.

B. The user cannotset privileges on persistent lightweight jobs.用户不能在永久性轻量级jobs上设置权限。

C. Persistentlightweight jobs are useful when users need to create a large number of jobs ina short time.当用户在短时间内需要创建的大量的job时永久性轻量级job是有效的。

D. Persistent lightweight jobs are useful when users need tocreate a small number of jobs that run infrequently.

E. The use of atemplate is mandatory to create persistent lightweight jobs.创建永久性轻量级job强制使用模板。

 

 

Explanation:

QUESTION NO:13 (Jesse)

关于虚拟专用编目virtual privatecatalogs正确的是：

A. A virtual private catalog owner can create a local storedscript, and have read/write access to a global stored script.一个虚拟专用编目所有者可以创建一个本地存储脚本，有读写访问全局存储脚本权限X？

B. The virtual private catalog owner cannot create andmodify the stored scripts.虚拟专用编目所有者不能创建和修改存储脚本

C. The set of views and synonyms that make up the virtualprivate catalog is stored in the schema of the RMAN recovery catalog owner.

D. To perform most ofthe RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPERprivilege on the target database.执行大多数RMAN操作，虚拟编目所有者必须有SYSDBA或SYSOPER权限（在目标数据库上）

 

 

 

Explanation:

QUESTION NO:16

 (Choose two.)哪两个被ASM元数据备份和还原功能所使用：

C. It can be used togather information about a preexisting ASM disk group with disk paths, disk name,failure groups, attributes, templates, and alias directory structure.用于去收集关于先前存在的ASM磁盘组（磁盘路径，磁盘名，失败组，属性，模板和别名结构等）的信息

D. It can be used tore-create the ASM disk group with its attributes.它可以用去重建ASM磁盘组（用它的属性）。

 和数据无关

 

Explanation:

QUESTION NO:18 问题什么是autotask framework  (Jesse)

哪个原因可以将Automatic  sqltuning作为autotask架构下的组成部分来使用

B. SQL statementsbased on the AWR top SQL identification 基于AWR top sql鉴定中的sql语句

 

Explanation:

QUESTION NO:19

当执行FRA备份时，你注意到其中某个归档重做日志文件已经丢失。你有多个归档重做日志文件存储路径。它在FRA备份上的影响是：

D. The backupsucceeds because it fails over to one of the alternative非正常的，二选一的 archived redo logdestinations.备份成功因为它有二选一的归档重做日志目标。

 

Explanation:

QUESTION NO:20 (Jesse)

 (Choose all that apply.)你正在管理一个oracle11g实例和oracle10的实例（在相同的机器上）。两个实例都使用ASM实例作为存储。在个场景下关于ASM磁盘组兼容性属性描述正确的是：

A. Thedatabase-compatibility version settings for each instance must begreaterthan or equal to the RDBMS compatibility of all ASM disk groups used bythat database instances.每一个实例的数据库兼容性版本设置必须大于或等于被数据库实例所使用的所有的ASM磁盘组的RDBMS的兼容性。

B. RDBMScompatibility and the database version determines whether a database instancecan mount the ASM disk group.RDBMS兼容性和数据库版本决定了一个数据库实例是否可以mount一个ASM磁盘组。

C. The RDBMS compatibility settings for a disk group controlthe format of data structures for ASM metadata on the disk. 兼容性设置和元数据的数据结构格式无关

D. ASM compatibilitycontrols which features for the ASM will be enabled.ASM的兼容性控制功能将启用

 

Explanation:

QUESTION NO:21 (Jesse)

Choose three.) Autotask BackgroundProcess(ABP)的功能描述正确的是：

A. It creates jobs without considering the prioritiesassociated with them.

B. It translatestasks into jobs for execution by the scheduler.它把任务转换成通过调度器执行的job

C. It determines thelist of jobs that must be created for each maintenance window.它决定了为每一个维护窗口所创建的job的列表

D. It is spawned引起，酿成 by the MMONbackground process at the start of（开始起初） the maintenancewindow.在维护窗口开始之初由MMON后台进程来引起

E. It maintains a repository in the SYSTEM tablespace tostore the history of the execution of all tasks.

 问题：所有任务的执行历史存储在哪个表空间？

Explanation:

QUESTION NO:22

(Choose all that apply.)在oracle11g的故障诊断架构中的问题和事件的内容描述正确的是：

A. Only the incident metadata and dumps are stored in theAutomatic Diagnostic Repository (ADR).

B. The problem key is the same as the incident number.

C. The database sendsan incident alert to the Oracle Enterprise Manager Database Home page.数据库发送一个事件警告到oracle EM数据库home页面

D. Every problem hasa problem key, which is a text string that describes the problem.每个问题有一个问题key，描述问题的文本字符串

E. The database makesan entry into the alert log file when problems and incidents occur.数据库写个entry到alert日志文件，当问题和事件发生的时候。

 问题：ADR中存储的是什么？

 

Explanation:

QUESTION NO:23

(Choosetwo.)来自sql access advisor的推荐方案，描述正确的两句是：

A. It cannot generate recommendations that support multipleworkload queries.

B. It can recommendpartitioning on tables provided that the workloads have some predicates and  joins on the columns of the NUMBER or DATEtype.他可以推荐表分区（表的负载有一些断定和连接在number或日期类型的列上）

<