Oracle 11G数据库管理II：最新题库确保通过

5星 · 超过95%的资源需积分: 10 165 浏览量更新于2024-07-27 1 收藏 2.48MB PDF 举报

"OCP 11G 题库053" Oracle Certified Professional (OCP) 是 Oracle 公司针对其数据库产品所设立的专业认证，11G 版本的 OCP 认证主要针对 Oracle Database 11g 的管理和优化技能。1Z0-053 是这个认证过程中的一个考试，主要测试考生在 Oracle Database 11g 管理第二部分的能力，包括但不限于性能优化、备份恢复、安全管理和数据库维护等。 1. SQL 计划基线（SQL Plan Baseline） SQL 计划基线是 Oracle 数据库的一个重要特性，用于管理并存储 SQL 语句的最佳执行计划。当新的应用程序模块部署时，软件供应商可能提供与新 SQL 语句对应的计划基线。选项 A 和 C 描述了计划基线的两个关键后果： A. 计划基线可以随着时间的推移不断进化以获得更好的性能。这意味着数据库系统能够通过学习和优化过程改进这些计划。 C. 新的 SQL 语句最初会使用已知在标准测试配置下能产生良好性能的计划。这确保了新引入的 SQL 在一开始就能有良好的性能表现。 2. 自适应阈值（Adaptive Threshold）与移动窗口大小默认的系统定义的移动窗口基线（Moving Window Baseline）用于 AWR（Automatic Workload Repository）报告，它收集和分析数据库性能数据。如果你打算增加移动窗口的大小来使用自适应阈值，你需要考虑以下因素： A. AWR 的收集级别应该设置为 B（基本级别）。自适应阈值功能可能需要更详细的性能数据来有效地调整阈值，因此增大窗口的同时，可能需要提高数据收集的详细程度。 3. 性能优化 OCP 11G 考试涵盖了如何使用各种工具和策略来优化数据库性能，如 SQL 优化器、索引管理、分区、物化视图以及 SQL 计划指导等。掌握这些技能对于确保数据库高效运行至关重要。 4. 备份与恢复学习如何创建和管理 RMAN（Recovery Manager）备份，以及如何在灾难发生时恢复数据，是 OCP 11G 认证的重要组成部分。这包括了解不同的备份类型、备份策略、恢复模式和闪回技术。 5. 安全管理数据库的安全性是任何数据库管理员的首要任务。OCP 11G 认证要求考生熟悉角色和权限的管理，网络安全性，审计功能以及如何保护敏感数据。 6. 数据库维护维护任务包括监控性能、空间管理、日志切换、表空间的扩展以及定期的健康检查。考生需要知道如何使用 DBA 工具来自动化和简化这些任务。在准备 OCP 11G 1Z0-053 考试时，除了深入理解上述知识点，还需要通过模拟题库进行大量练习，以确保在实际考试中能够顺利通过。题库通常包含了涵盖所有主题的大量题目，通过它们可以检验对 Oracle Database 11g 管理理论和实践的掌握程度。

The safer , easier way to help you pass any IT exams.

180

Set the DB_LOCK_CHECKSUM parameter to TYPICA

Set the DB_LOST_WRITE_PROTECT parameter to TYPICA

Answer:

You want

to use RMAN to create compressed backups.

Which statement is true about the compression algorithms that RMAN can use?

The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression

algorithm.

The ZLIB compression algorithm con

sumes more CPU resources than the BZIP2 compression

algorithm.

The ZLIB compression algorithm provides maximum compression and produces smaller backups than

the BZIP2 compression algorithm.

Only the BZIP2 compression algorithm can be used to make com

pressed backups to disk.

Answer:

Evaluate the following function code:

CREATE FUNCTION get_dept_avg(dept_id NUMBER) RETURN NUMBER RESULT_CACHE

RELIES_ON

(EMPLOYEES) IS avgsal NUMBER(6);

BEGIN

SELECT AVG(SALARY)INTO avgsal

FROM EMPLOYEES

WHERE DEPARTM

ENT_ID = dept_id;

RETURN avgsal;

END get_dept_avg;

Which statement is true regarding the above function?

The cached result becomes invalid when any structural change is done to the EMPLOYEES table.

If the function execution results in an unhandled ex

ception, the exception result is also stored in the

cache.

Each time the function is invoked in a different session, the current result in the result cache gets

overwritten.

If the function is invoked with a different parameter value, the existing re

sult in the result cache gets

overwritten by the latest value.

Answer:

Following is the list of locations in random order where oranfstab can be placed.

1./etc/mtab

2.$ORACLE_HOME/dbs/oranfstab

3./etc/oranfstab

What is the sequence in which Direct NF

S will search the locations?

1, 2, 3

3, 2, 1

2, 3, 1

1, 3, 2

The safer , easier way to help you pass any IT exams.

180

Answer:

You discover that your Recycle Bin contains two tables with the same name, MY_TABL

You also

have a table named MY_TABLE in your schema. You execute the following state

ment:

FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;

What will be the result of executing this statement?

One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.

One of the tables is recovered fro

m the Recycle Bin using a Last In First Out (LIFO) approach.

Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the

other to a system

generated name.

None of the tables are recovered from the Recycle Bin, and t

he statement returns an error.

Answer:

Which background process of a database instance, using Automatic Storage Management (ASM),

connects as a foreground process into the ASM instance?

ASMB

PMON

RBAL

D. SMON

Answer:

Which statement is

true when Automatic Workload Repository (AWR) baselines are created using

baseline templates?

AWR baselines are always created as repeating baselines.

AWR baselines can be created on the basis of two time values.

AWR baselines are always created

with infinite expiration duration.

AWR baselines are always created using the Automatic Workload Repository (AWR) retention period

as expiration duration.

Answer:

You have not configured Oracle Managed Files (OMF) in your database. You do not want

to scan the

entire datafile every time an incremental backup is performed. You decide to enable the block change

tracking feature. Which statement should you use to enable the block change tracking feature?

ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;

Answer:

For which two situations would you use functionality provided by t

he Resource Manager? (Choose

two.)

setting idle timeout limits on resource plans

saving storage space by using compressed backup sets

creating jobs that will run automatically at a scheduled time

The safer , easier way to help you pass any IT exams.

180

assigning priorities to jobs to manage access to

system resources

creating alerts to perform notification when tablespaces are low on available space resources

Answer:

Which of the following advisors within the Oracle advisory framework will analyze a single SQL

statement and make recommendati

ons for performance improvement?

SQL Repair Advisor

SQL Optimizer

SQL Access Advisor

SQL Tuning Advisor

Answer:

You want to convert your existing non

ASM files to ASM files for the database PRO

Which method

or command would you use to a

ccomplish this task?

Data Pump Export and Import

conventional export and import

the CONVERT command of RMAN

the BACKUP AS COPY. command of RMAN

Answer:

Which method would you use to undo the changes made by a particular transaction withou

t affecting

the changes made by other transactions?

point

time recovery

execute the ROLLBACK command with transaction number

flashback the database to before the transaction was committed

determine all the necessary undo SQL statements from

FLASHBACK_TRANSACTION_QUERY and

use them for recovery

Answer:

You performed an incomplete recovery and opened the database with the RESETLOGS option. The

LOG_ARCHIVE_FORMAT parameter is set to 'ora_%t_%s_%r.log'. Which statement regarding the

archive

d redo log files, created in an earlier incarnation of the database, is true?

The archived redo log files will be overwritten.

The archived redo log files are deleted automatically.

The archived redo log files should be moved to some other locatio

The archived redo log files are still maintained because the file names are unique.

Answer:

An online tablespace, TEST_TBS, is full and you realize that no server

managed tablespace threshold

alerts were generated for the TEST_TBS tablespace. W

hat could be the reason, if the TEST_TBS

tablespace does not include autoextensible data files?

TEST_TBS is a small file tablespace.

TEST_TBS is a bigfile tablespace (BFT).

TEST_TBS is the default temporary tablespace.

The safer , easier way to help you pass any IT exams.

180

EXAMPLE tablespace:

ALTER TABLE employees SHRINK SPACE CASCADE;

Which

statement is correct in this scenario?

The EMPLOYEES table will be changed to read

only mode during the shrink operation.

The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.

The shrink behavior w

ill be cascaded to all dependent segments of the table that support a shrink

operation.

Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during

the COMPACTION phase of the shrink operation.

Answer:

The Automa

tic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your

database. Your database is facing a series of interrelated problems over a period of two hours. You need

to ensure that the ADDM analysis is run over a time span of two hours in

future. What would you do?

Create two custom ADDM tasks.

Modify the AWR snapshot time interval to two hours.

Create a new scheduler window for a time period of two hours.

Modify the Automatic Workload Repository (AWR) snapshot retention period

to two hours.

Answer:

You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running

low on space.

You can use Segment Advisor to _____.

identify the segments that you should shrink

modify the storage parameters

for the tablespace

automatically shrink the segments with unused space

check the alerts generated for the tablespace that is running low on space

Answer:

You are using Recovery Manager (RMAN) to perform backups. In which three situations would

you

perform a compressed backup? (Choose three.)

You are backing up to tape and your tape device performs its own compression.

You are making image copies, and you have not enabled tablespace compression.

You are using disk

based backups and disk

space in your Flash Recovery Area, or other disk

based

backup destinations are limited.

You are performing your backups to some device over a network where reduced network bandwidth is

more important than CPU usage.

You are using some archival backu

p media, such as CD or DVD, where reducing backup sizes saves

media costs and archival storage.

Answer:

CDE

Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find

that the performance of the database goes dow

n initially until the time the addition or removal process is

completed, and then gradually becomes normal.

剩余179页未读，继续阅读

hello985

粉丝: 1
资源: 7

Oracle 11G数据库管理II：最新题库确保通过

OCP 11G 题库053补充题库

ocp11g题库新

OCP 11G的053的题库

OCP 11G 053题库

OCP 11G题库

ocp 11g 题库

ORACLE认证题库 OCA 10G 11G OCP 11G 题库

ocp 11g 题库全集

ocp11g题库 2013最新

OCP 11G题库.zip

最新资源