Oracle 11G 053 题库最新版 V13.02 - 数据库管理II

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

"OCP 11G 053 最新题库 V13.02 20130929" 这个资源是一个针对Oracle Certified Professional (OCP) 11g考试的题库，特别是1Z0-053科目，即Oracle Database 11g: Administration II。版本号为V13.02，发布日期为2013年9月29日。这个题库旨在帮助用户顺利通过IT相关考试，提供安全、简便的学习方式。 1/193题目涉及的是在部署新的应用程序模块时，软件供应商会同时提供新SQL语句的性能计划基线。以下是关于这个情况的两个陈述： A. 计划基线可以随着时间的推移逐步演进以实现更好的性能。 B. 新生成的计划会直接放入SQL计划基线中，无需进行验证。正确答案是A和C。这意味着计划基线能够随着运行和优化而改善性能，而新引入的SQL语句会使用已知在标准测试配置下能产生良好性能的计划。选项B不正确，因为新计划在被纳入基线之前应经过验证，以确保其有效性和可靠性。 2/193题目关注的是调整默认系统定义的移动窗口基线的大小，以使用自适应阈值。增加移动窗口的大小时，以下哪个陈述考虑了这一因素？这个问题没有给出完整的选项列表，但可以推测它可能涉及到调整窗口大小时对性能、存储或自适应策略的影响。在实际操作中，增大移动窗口大小可能会影响性能监控的粒度、存储需求以及自适应阈值的准确性，因为更大的窗口意味着更长的数据历史，这可能会影响优化器对SQL语句的评估和选择计划。在Oracle数据库管理中，SQL计划基线是性能调优的重要工具，用于存储和管理SQL语句的执行计划。它们可以帮助避免由于统计信息变化或其他因素导致的性能下降，通过记录和重用已知良好的执行计划来确保SQL语句的稳定性能。自适应阈值是一种动态调整性能阈值的方法，可以根据工作负载的变化来优化SQL语句的执行。这个题库覆盖了Oracle数据库管理中的关键概念，包括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页未读，继续阅读

小强_888

粉丝: 1
资源: 33

Oracle 11G 053 题库最新版 V13.02 - 数据库管理II

最新1Z0-053 V13.02-20130929题库711道及模拟vce文件

OCP 053最新题库

OCP 11G 题库053补充题库

OCP 11G的053的题库

OCP 11G 053题库

OCP1Z0-053 V13.02：备考指南与SQL优化策略

11G OCP 1Z-053 题库

ocp11g 2013年最新题库

ocp 11g 最新题库

ocp11g最新题库

最新资源