20151207 ocp 052出错题 总结

2.which two statements are true about the automatic workload repository(AWR)?

c.the snapshots collected by the AWR are accessible theough data dictionary views

d.the snapshots collected by the AWR are used by self-tuning components in the database

AWR基础结构主要由两个主要部分组成

一个内存中统计信息收集工具，oracle database 11g 组件使用它来收集统计信息、。

出于性能方面的考虑，这些统计信息存储在内存中。可以通过动态性能视图访问存储在内存中的统计信息

代表该工具持久不分的AWR快照。AWR快照可以通过数据字典视图和enterprisemanager database control来访问

它为Oracle服务器组件提供服务来收集、处理、维护和使用性能统计信息，以便进行问题检测和优化

AWR中包含数百个表，所有这些表均属于sysman方案且存储在sysauc表空间中

162.you created a profile APP_USER and assigned it to the users.after a month,you decide to drop the profile

some user sessions are currently connected to the database instance and are using the APP_USER profile this command 

is used to drop the profile

sql>drop profile app_user;

which statement describes the result?

a.the command produces an error

在enterprise manager中和sql中，无法删除用户使用的概要文件。但是，如果删除具有cascade选型的概要文件，则会向具有该概要文件的所有用户自动分配default概要文件

44.your database is functional with a peak load for the last one hour.you want to preserve

the performenca statistics collected during this peiord to be userd for comparison when you analyze the performance of the database in the future

whta action would you take to achive this task?

b.create a baseline on a prair of snapshots spanning the peak-load period

创建一个基线，一对在峰值负载期间快照

awr基线，是一段时间内收集的一组AWR快照。基线用于性能比较，这既可以是当前性能与基线的比较，也可以是一个基线与

另一个基线的比较

从题中知，可在峰值期间建立一堆快照来对比性能

39.which two statements are true about standard database auditing

a.ddl statements can be sudited

b.statements that refer to stand-alone procedure can be sudited

ab.audit table 可审计影响表的任何数据定义语言（DDL）语句，包括create table,drop table和truncate table

也可以审计plsql语句

c.oracle db会自动捕获sysdba和sysoper用户的登录时间

d.只有在审计设置为by access的时候才可以

187.which two statements describe good practices for an application developer to reduce locking conflics in oracle database

a.avoid coding unnecessary long-running transations

避免编码不惜要的长时间运行的事物。正确，长时间的事物太多，别的用户无法访问，

b.allow therdatabase to handle locks in default locking mode

允许数据库来处理锁在默认锁定模式，这样的话，排队机制是自动运行的，不需要人来干预

87.you are managing an oracle database 11g running in archivelog mode.the flash recovery area is specified as the destination for the archive redo log files .

you notice this warning in the alert log file;

ORA-19815: WARNING: db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0

remaning bytes available 

what would you do to recalim the userd space in the falsh recovery ?

a.backup the flash recovery

b.recrease the retention time for the database backups and flash log files

可以选择增加额外的磁盘空间、将文件备份到三级存储设备、使用RMAN 从快速恢复区删除文件或考虑更改RMAN 保留策略。

166.view the exhibit and examine the setting for a table

which statement is true about the pctree setting for the table?

b.it sets the minimum percentage of a data block to be reseerved as free space before the server prevents into the block

默认的pctree为10%,意味着一个数据块里至少会有10%的空闲空间，如果插入的数据或者更新的数据让数据块的空闲空间少于10%，则会插入到另一个数据块里

167.which three descripitons are correcte about the effects of the trncate command on a table?

a.the corresponding the indexes for the table are also trncated

是的，索引也会清空

d.the high-water mark (HWM) is set to point to the first usable data block in the table segment

这个自不必说

e.no undo or very little undo data is generated during the excecution of the trnate command

产生少量的undo信息

59.in your database .the current status of a plsql procedure has become invaild.

which action would fix the problem and make the plsql procedure usable?

a.recompile the plsql procedure

废话，当然是重新编译了

106.

106. You plan to configure the new Oracle Database 11g installation by performing these tasks:

- Use Automatic Storage Management (ASM) as the storage option.

- Use Oracle Enterprise Manager Database Control to manage the database.

- Provide the same password for SYS, SYSTEM, SYSMAN, and DBSNMP accounts during theinstallation.

- Configure the database to send email notifications.

Some tools available to you for installation are:

1: Oracle Universal Installer (OUI)

2: Database Configuration Assistant (DBCA)

3: Database Upgrade Assistant (DBUA)

4: Oracle Net Configuration Assistant

Which tools would you use for this installation?

大写字母的都要

74.the database is running in archivelog mode.examine the initialization parameter and their values set to enable archiving on your database sever;

LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc

LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive'

DB_RECOVERY_FILE_DEST = '/u01/oradata'

DB_RECOVERY_FILE_DEST_SIZE = 20G

Which statement is true regarding the archived redo log files?

a.it will be created on the local file sytstem

关键词 local

77. You executed the following command to perform a backup of the USERS tablespace:

SQL> ALTER TABLESPACE users BEGIN BACKUP;

ALTER TABLESPACE users BEGIN BACKUP

*

ERROR at line 1:

ORA-01123: cannot start online backup; media recovery not enabled

What could be the reason for this error?

A.The MTTR Advisor is disabled.

B.The database is in NOARCHIVELOG mode.

C.The tablespace is already in backup mode.

D.The Flash Recovery Area is not configured.

Answer: B  

 

对数据库进行热备，必须把数据库设置为archivelog 模式。

如果未处于archivelog 模式，需shutdown数据库，启动到mount状态进行修改。因此B是正确答案。

100.in which situations does the oracle data pump user external tables and not the direct path load shile exporting a table 

b.if a table has an active trigger

有活动的触发器

c.if a table has an encrypted

表被加密

e.if a table has a referential integrity constarint defirnd on it 

有完整的约束