Oracle数据库11g管理员II实战练习题及解析

需积分: 9 172 浏览量更新于2024-07-17 收藏 4.22MB PDF 举报

"1z0-053-练习题（更新）.pdf 是一份关于OCP053考试的最新整理真题集，包含了711道问题和36个练习，主要目的是帮助考生熟悉Oracle Database 11g: Administration II的考试内容，并对文件的格式和排版进行了优化，以便于学习和使用。这份资料可能来自Testpassport，一个提供各类IT认证考试复习材料的平台，旨在确保用户能够顺利通过考试。" 在这些内容中，我们可以提取出以下几个关键的知识点： 1. **SQL计划基线**：在部署新应用模块时，软件供应商会提供SQL计划基线，这是针对新引入SQL语句的性能优化策略。选项A指出，计划基线可以随时间演进以实现更好的性能，而选项C则表示新的SQL语句会从一开始就运行已知能产生良好性能的计划。这两个选项正确地描述了SQL计划基线的作用和效果。 2. **优化器行为**：对于已经导入SQL计划基线的SQL语句，选项D指出优化器不会为这些语句生成新的计划，这表明优化器会依赖于基线中的计划，而不是每次都重新生成。 3. **默认系统定义的移动窗口基线**：如果你想要增大默认系统定义的移动窗口基线的大小，以便使用自适应阈值，这涉及到性能监控和调整的策略。在增大窗口大小时，需要考虑的因素可能包括如何有效地利用自适应阈值来监控SQL语句的性能变化，以及如何在更大时间范围内保持系统的稳定性和效率。 4. **Oracle Database 11g: Administration II**：这个考试是Oracle数据库管理员认证的一部分，涵盖了数据库的管理、性能优化、安全性、备份与恢复等多个方面。因此，备考者需要掌握如何配置和管理Oracle数据库，包括SQL语句的优化、数据库性能监控、故障排查和维护等技能。为了准备OCP053考试，考生需要深入理解Oracle数据库的管理和维护，尤其是SQL优化、性能监控和系统配置等方面的知识。通过这份题库，考生可以进行模拟练习，了解考试的题型和难度，从而提升应试能力。同时，考生还应该结合官方文档和其他参考资料，全面学习和掌握相关理论知识。

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

15 / 193

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?

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

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

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

recovery, and open the database using the RESETLOGS option.

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?

when ASM disk goes offline

when one or more ASM files are dropped

when some disks in a disk group are offline

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?

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

the same instance.

It terminates the client connection after 10 bad packets but the client can still reconnect,

and attempt the same operation again.

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

cannot reconnect to the same instance.

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?

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?

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

One of the tables is recovered from 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 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?

ASMB

PMON

RBAL

SMON

Answer: A

58. 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: 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?

ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

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

setting idle timeout limits on resource plans

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

SQL Optimizer

SQL Access Advisor

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

conventional export and import

the CONVERT command of RMAN

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?

point-in-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: 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.

The archived redo log files are deleted automatically.

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

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.

TEST_TBS is a bigfile tablespace (BFT).

TEST_TBS is the default temporary tablespace.

剩余205页未读，继续阅读

niumanjun

粉丝: 0
资源: 1

Oracle数据库11g管理员II实战练习题及解析

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

OCP_OCA认证考试指南全册Oracle Database 11g（1Z0-051,1Z0-052,1Z0-053）练习与知识点

已按下面规律译成密码: a--z a--z b--y b--y c--x c--x ...... 即第1

^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+.{0，1}[a-zA-Z]{2,}$解释一下这个正则表达式

email_pattern = r'^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$'输入输出格式是什么

用matlab求peaks函数的最小值。 >> peaks z = 3*(1-x).^2.*exp(-(x.^2) - (y+1).^2) ... - 10*(x/5 - x.^3 - y.^5).*exp(-x.^2-y.^2) ... - 1/3*exp(-(x+1).^2 - y.^2)

相机的旋转矩阵-0.027 , -0.999, 0, 0.938 , -0.015, -0.347, 0.346 ,0.034 , 0.938求相机的平移向量

正则/^(?!http://|https://)[a-zA-Z0-9][a-zA-Z0-9-.]{1,60}[a-zA-Z0-9].[a-zA-Z]{1,10}$/的含义

最新资源

用matlab求peaks函数的最小值。 >> peaks z = 3(1-x).^2.exp(-(x.^2) - (y+1).^2) ... - 10(x/5 - x.^3 - y.^5).exp(-x.^2-y.^2) ... - 1/3*exp(-(x+1).^2 - y.^2)