Oracle 11g数据库管理员升级考试1Z0-050要点解析

5星 · 超过95%的资源需积分: 9 126 浏览量更新于2024-07-22 1 收藏 1.21MB PDF 举报

"Oracle Database 11g OCP 升级考试1Z0-050是Oracle数据库管理员的专业认证考试，旨在验证考生对Oracle 11g数据库新特性的理解和管理能力。此考试包括了183个问题，涵盖SQL计划、工作负载捕获与重放、性能优化等多个方面。" 在Oracle Database 11g OCP升级考试1Z0-050中，考生需要熟悉以下几个关键知识点： 1. SQL计划基础：SQL计划可以来源于两个直接源——Cursor Cache（游标缓存）和SQL Tuning Set（SQL调优集）。Cursor Cache存储最近执行的SQL语句，而SQL Tuning Set则用于收集和存储一组SQL语句以便于分析和优化。 2. 工作负载捕获与重放：这是性能测试和优化的重要工具。工作负载捕获（Workload Capture）是指记录数据库在特定时间段内的活动，以便于后期分析。正确选项C指出，在开始工作负载捕获前需要将数据库重启到RESTRICTED模式，以确保捕获到干净的工作负载状态。选项D强调，当工作负载重放开始时，捕获系统和重放系统的应用程序状态必须保持一致，以确保测试的准确性。 3. SQL计划基线：SQL计划基线是Oracle数据库中的一个功能，用于存储和管理优化器选择的优秀执行计划。考生应了解如何查看和管理这些计划，例如通过Exhibit 2所示的SQL计划基线，来分析和选择合适的执行策略。 4. 性能优化：Oracle 11g引入了新的性能优化工具和特性，如Automatic Workload Repository (AWR)快照，它提供了数据库性能的历史视图，帮助管理员识别性能问题。虽然在题目中没有直接提及AWR作为SQL计划的加载源，但了解AWR对于理解整个数据库的性能管理至关重要。 5. 数据库运行模式：RESTRICTED模式在特定操作中使用，如在开始工作负载捕获或重放前，以限制数据库的访问并确保测试环境的纯净。 6. SQL优化：考生还需要掌握如何使用Oracle的自动优化工具，如SQL Profile和SQL Plan Management，以及如何通过优化顾问来改进SQL语句的性能。通过这些考试内容，考生能够证明他们在Oracle 11g数据库管理方面的专业知识，包括但不限于性能监控、问题诊断、工作负载管理和SQL优化。备考过程中，考生应深入理解这些概念，并通过实践来增强技能。

Get Certified @ TEST-KINGS.COM

Exam Name: Oracle Database 11g: New Features for Administrators

Exam Type Oracle

Exam Code: 1Z0-050 Total Questions: 183

Page 11 of 62

A. to prevent the creation of an excessive number of scheduler job classes

B. to allow the Automated Maintenance Tasks to use system resources without any restriction

C. to allow resource sharing only among the Automated Maintenance Tasks in the maintenance

window

D. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system

resources

Answer: D

QUESTION NO: 34

Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK

framework?

A. SQL statements that are part of the AWR baseline only

B. SQL statements based on the AWR top SQL identification

C. SQL statements that are part of the available SQL Tuning Set (STS) only

D. SQL statements that are available in the cursor cache and executed by a user other than SYS

Answer: B

QUESTION NO: 35

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 table uses the default Flashback Archive.

B. The Flashback Archive is created on the SYSAUX tablespace.

C. The Flashback Archive is created on the same tablespace where the tables are stored.

D. The command generates an error because no Flashback Archive name is specified and there

is no default Flashback Archive.

Answer: D

QUESTION NO: 36

View the Exhibit to examine the error during the database startup.

Get Certified @ TEST-KINGS.COM

Exam Name: Oracle Database 11g: New Features for Administrators

Exam Type Oracle

Exam Code: 1Z0-050 Total Questions: 183

Page 12 of 62

You open an RMAN session for the database instance. To repair the failure, you executed the

following as the first command in the RMAN session:

RMAN> REPAIR FAILURE;

Which statement describes the consequence of the command?

A. The command performs the recovery and closes the failures.

B. The command only displays the advice and the RMAN script required for repair.

C. The command produces an error because the ADVISE FAILURE command has not been

executed before the REPAIR FAILURE command.

D. The command executes the RMAN script to repair the failure and removes the entry from the

Automatic Diagnostic Repository (ADR).

Answer: C

QUESTION NO: 37

You issued the following command on the temporary tablespace LMTEMP in your database:

SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M;

Which requirement must be fulfilled for this command to succeed?

A. The tablespace must be locally managed.

B. The tablespace must have only one temp file.

C. The tablespace must be made nondefault and offline.

D. The tablespace can remain as the default but must have no active sort operations.

Answer: A

QUESTION NO: 38

You are working as a DBA on the decision support system. There is a business requirement to

track and store all transactions for at least three years for a few tables in the database. Automatic

undo management is enabled in the database. Which configuration should you use to accomplish

this task?

A. Enable Flashback Data Archive for the tables.

B. Enable supplemental logging for the database.

C. Specify undo retention guarantee for the database.

D. Create Flashback Data Archive on the tablespace on which the tables are stored.

E. Query V$UNDOSTAT to determine the amount of undo that will be generated and create an

undo tablespace for that size.

Answer: A

QUESTION NO: 39

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database

in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes

the following script:

Get Certified @ TEST-KINGS.COM

Exam Name: Oracle Database 11g: New Features for Administrators

Exam Type Oracle

Exam Code: 1Z0-050 Total Questions: 183

Page 13 of 62

SQL> @utlrp.sql

What is the significance of executing this script?

A. It performs parallel recompilation of only the stored PL/SQL code.

B. It performs sequential recompilation of only the stored PL/SQL code.

C. It performs parallel recompilation of any stored PL/SQL as well as Java code.

D. It performs sequential recompilation of any stored PL/SQL as well as Java code.

Answer: C

QUESTION NO: 40

Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)

A. It can be used to back up all data on ASM disks.

B. It can be used to re-create the ASM disk group with its attributes.

C. It can be used to recover the damaged ASM disk group along with the data.

D. It can be used to gather information about a preexisting ASM disk group with disk paths, disk

name, failure groups, attributes, templates, and alias directory structure.

Answer: B, D

QUESTION NO: 41

You executed the following PL/SQL block successfully:

VARIABLE tname VARCHAR2(20)

BEGIN

dbms_addm.insert_finding_directive (NULL, DIR_NAME=>'Detail CPU Usage',

FINDING_NAME=>'CPU Usage',

MIN_ACTIVE_SESSIONS=>0, MIN_PERC_IMPACT=>90);

:tname := 'database ADDM task4';

dbms_addm.analyze_db(:tname, 150, 162);

END;

Then you executed the following command:

SQL> SELECT dbms_addm.get_report(:tname) FROM DUAL;

The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis ____.

A. with the CPU Usage finding if it is less than 90

B. without the CPU Usage finding if it is less than 90

C. with the CPU Usage finding for snapshots below 90

D. with the CPU Usage finding for snapshots not between 150 and 162

Answer: B

QUESTION NO: 42

Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package?

(Choose all that apply.)

A. It can be used to allow the access privilege settings for users but not roles.

B. It can be used to allow the access privilege settings for users as well as roles.

C. It can be used to control the time interval for which the access privilege is available to a user.

D. It can be used to selectively restrict the access for each user in a database to different host

computers.

E. It can be used to selectively restrict a user's access to different applications in a specific host

computer.

剩余61页未读，继续阅读

hendrix0623

粉丝: 1
资源: 3

Oracle 11g数据库管理员升级考试1Z0-050要点解析

oracle升级OCP到12c考试题库 Oracle-1z0-060

OCPOCA认证考试指南全册：Oracle Database 11g（1Z0-051，1Z0-052，1Z0-053）.part4.rar

老哥讲数据库mysql ocp 8.0 1z0-908题库

mysql ocp 8.0 1z0-908 报名流程

mysql 8 ocp 1z0-908 题库

java 1z0-809

oracle数据库ocp考试

oracle 12c OCP

oracle ocp 19c

Oracle的OCP认证

最新资源