Oracle 11G 1Z0-053题库解析：数据库管理II

需积分: 3 132 浏览量更新于2024-07-23 1 收藏 3.04MB PDF 举报

"OCP 11G的053题库，包含Oracle Database 11g: Administration II的考试内容，版本V13.02，提供帮助通过IT考试的安全、简便方式。" 在Oracle Certified Professional (OCP) 11G的053题库中，主要涉及的是Oracle Database 11g的第二部分管理，即Oracle Database 11g: Administration II。这个题库是为准备相关认证考试的考生设计的，旨在帮助他们熟悉并掌握数据库管理的关键概念和技术。 1/193题描述了SQL计划基线在部署新应用模块时的作用。SQL计划基线是Oracle数据库性能优化的一个重要工具，它允许存储和管理已知能提供良好性能的执行计划。题目中提到的两个关键点是： A. 计划基线可以随着时间推移逐步演化以提升性能。 C. 新的SQL语句在一开始会使用已知在标准测试配置下能产生良好性能的计划。选项A表明，随着数据库操作的进行，计划基线可以通过学习和调整来优化性能。选项C强调了计划基线在确保新SQL语句性能稳定性方面的作用，避免了未验证的新计划可能导致的性能问题。 2/193题涉及到系统默认的移动窗口基线的大小调整，特别是为了使用自适应阈值。移动窗口基线是一种性能监控机制，用于跟踪一段时间内SQL语句的执行情况。增大移动窗口的大小可以更全面地分析SQL语句的性能趋势。而自适应阈值允许数据库根据历史数据动态调整性能阈值，以适应工作负载的变化。在考虑增加移动窗口大小时，需要考虑到这将影响数据库对性能数据的收集和分析，以及自适应阈值如何在更大的数据集上有效地工作。这可能会影响到内存使用、I/O操作以及数据库的整体响应时间。 OCP 11G的053题库涵盖了Oracle Database 11g的SQL计划基线管理和性能优化策略，这些都是数据库管理员必须掌握的关键技能，以确保数据库高效稳定运行。通过这个题库，考生能够深入理解这些概念，并为实际的考试做好充分准备。

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

15 / 193

D. The pending area has not been created before running the I/O calibration process.

Answer: B

49.Which statement about recovering from the loss of a redo log group is true?

A. If the lost redo log group is ACTIVE, you should first attempt to clear the log file.

B. If the lost redo log group is CURRENT, you must clear the log file.

C. If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and

open the database using the RESETLOGS option.

D. If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery,

and open the database using the RESETLOGS option.

Answer: D

50.Examine the following command:

ALTER DISKGROUP data MOUNT FORCE;

In which scenario can you use the above command to mount the disk group?

A. when ASM disk goes offline

B. when one or more ASM files are dropped

C. when some disks in a disk group are offline

D. when some disks in a failure group for a disk group are rebalancing

Answer: C

51.To control the execution of a server process when it is receiving bad packets from a potentially

malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as

follows:

SQL> ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop,10;

What is the significance of this setting?

A. It terminates the client connection after 10 bad packets and the client cannot reconnect to the same

instance.

B. It terminates the client connection after 10 bad packets but the client can still reconnect, and attempt

the same operation again.

C. It terminates the client connection 10 seconds after receiving a bad packet and the client cannot

reconnect to the same instance.

D. It terminates the client connection after receiving a bad packet and the client can reconnect to the

same instance after 10 minutes.

Answer: B

52.You have the following requirements in relation to the detection of block corruption for your database

instance:

Check for logical self-consistency of data blocks when modified in memory.

Checksums are calculated before and after the block change.

Checks are performed for the lost writes to the physical standby database.

Which method would help you perform the above checks automatically?

A. Set the DB_SECUREFILE parameter to PERMITTED.

B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY.

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

17 / 193

Answer: C

56.You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also

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

FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;

What will be the result of executing this statement?

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

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

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

other to a system-generated name.

D. None of the tables are recovered from the Recycle Bin, and the statement returns an error.

Answer: B

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

connects as a foreground process into the ASM instance?

A. ASMB

B. PMON

C. RBAL

D. SMON

Answer: A

58.Which statement is true when Automatic Workload Repository (AWR) baselines are created using

baseline templates?

A. AWR baselines are always created as repeating baselines.

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

C. AWR baselines are always created with infinite expiration duration.

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

as expiration duration.

Answer: B

59.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?

A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

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

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

D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;

Answer: C

60.For which two situations would you use functionality provided by the Resource Manager? (Choose

two.)

A. setting idle timeout limits on resource plans

B. saving storage space by using compressed backup sets

C. creating jobs that will run automatically at a scheduled time

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

18 / 193

D. assigning priorities to jobs to manage access to system resources

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

Answer: AD

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

statement and make recommendations for performance improvement?

A. SQL Repair Advisor

B. SQL Optimizer

C. SQL Access Advisor

D. SQL Tuning Advisor

Answer: D

62.You want to convert your existing non-ASM files to ASM files for the database PROD. Which method

or command would you use to accomplish this task?

A. Data Pump Export and Import

B. conventional export and import

C. the CONVERT command of RMAN

D. the BACKUP AS COPY. command of RMAN

Answer: D

63.Which method would you use to undo the changes made by a particular transaction without affecting

the changes made by other transactions?

A. point-in-time recovery

B. execute the ROLLBACK command with transaction number

C. flashback the database to before the transaction was committed

D. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and

use them for recovery

Answer: D

64.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

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

A. The archived redo log files will be overwritten.

B. The archived redo log files are deleted automatically.

C. The archived redo log files should be moved to some other location.

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

Answer: D

65.An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold

alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS

tablespace does not include autoextensible data files?

A. TEST_TBS is a small file tablespace.

B. TEST_TBS is a bigfile tablespace (BFT).

C. TEST_TBS is the default temporary tablespace.

剩余193页未读，继续阅读

未来囧图

粉丝: 5
资源: 44

Oracle 11G 1Z0-053题库解析：数据库管理II

OCP 11G 053题库

OCP 11G最新题库.7z

OCP 11g 051 题库

OCP 11G 题库053补充题库

OCP 11G 053 最新题库 V13.02 20130929

OCP 11G 题库053

11G OCP 1Z-053 题库

OCP051 052 053题库

ocp11g最新题库

OCP11g考试题库

最新资源