Oracle Database 11g Administration II: OCP Exam 1Z0-053详解

需积分: 10 178 浏览量更新于2024-07-24 收藏 3.04MB PDF 举报

"ocp考试053最考题2013年11月3日最新版" 在Oracle数据库管理领域，OCP（Oracle Certified Professional）是Oracle公司提供的专业认证，其中1Z0-053是Oracle Database 11g Administration II的考试，这个考试涵盖了数据库管理和维护的多个关键方面。此资源似乎是一个针对该考试的题库，旨在帮助考生准备可能遇到的问题。第一部分题目涉及到SQL计划基线的部署。SQL计划基线是Oracle数据库11g中的一个特性，它允许管理员存储和管理SQL查询的执行计划，以确保性能稳定。当新的应用程序模块部署时，软件供应商可能会提供相应的SQL计划基线。以下是两个关于其后果的正确描述： A. 计划基线可以随时间演进以提高性能：随着数据库工作负载的变化，Oracle优化器可以学习并改进这些计划，以适应新的工作负载条件，从而实现更好的性能。 C. 新的SQL语句最初会运行已知在标准测试配置下产生良好性能的计划：在引入新的SQL语句时，它们将使用与计划基线匹配的已验证计划，以确保初始性能。 B和D不是正确选项。B选项错误是因为新生成的计划在放入SQL计划基线之前会被优化器验证。D选项错误是因为即使导入了SQL计划基线，优化器仍然会为那些SQL语句生成新计划，但会优先考虑基线中的计划。第二部分题目关注默认系统定义的移动窗口基线的大小调整。移动窗口基线是一种管理策略，用于适应性阈值，它允许数据库根据最近的性能数据动态调整阈值。增加移动窗口的大小意味着可以包含更多历史性能数据，这对于使用自适应阈值来更准确地检测性能变化至关重要。在调整窗口大小时，必须考虑到这将影响数据库监控的粒度和存储需求，更大的窗口可能导致更高的存储开销，但可以提供更全面的性能趋势分析。总结起来，这个资源提供了对Oracle Database 11g管理员考试1Z0-053中关于SQL计划基线管理和性能优化问题的实践练习。通过理解和掌握这些知识点，考生能够更好地准备考试，并在实际工作中有效地管理Oracle数据库的性能。

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页未读，继续阅读

渐行渐近

粉丝: 0
资源: 1

Oracle Database 11g Administration II: OCP Exam 1Z0-053详解

OCP考试 053 711题 答案修改版 最新14.5.11日 oracle

OCP 053最新题库

oracle ocp 考试 053 排序题库 答案

11G OCP考试053考试题库2019.4.zip

ocp 真题 053

OCP_053题库

ocp053--ocp考试题目

OCP053考试原题

OCP-053考试题库中英文对照详解

OCP 11g考试053最新试题

最新资源

OCP考试 053 711题答案修改版最新14.5.11日 oracle

oracle ocp 考试 053 排序题库答案