20151124 ocp(30-50)

33.identify two situations in which the block header grows in a data block.

a.when row directions need more row entries

d.when morwe transation slots are required than initially configured

块头:块头包含段类型（如表或索引）、数据块地址、表目录、航母路和事务处理插槽，每个插槽的大小约为23字节，修改快中的行时会使用这些插槽。块头自上而下进行增长。

行数据：这时块中行的实际数据。行数据空间自下而上进行增长

空闲数据：空闲空间位于块的中部，允许头和行数据空间在必要时进行增长。当插入新行或用更大的值更新现有行的列时，行数据会占用空闲空间

导致块头增长的时间实例包括：

行目录需要更多的行条目

需要的事务处理插槽多于最初配置的数目

34.you want to create a role to meet these requirements;

1.the role is to be protected from unauthorized usage.

2.the password of the role is not to be embedded in the application source code or stored in a table

which method would you use to restrict enabling of such roles?

c.create the role as a secure application role.

《Security Guide》 Glossary

secure application role, 是授予给应用程序用户的数据库角色，通过调用者权限存储过程从数据库表获取角色的口令。

secure application role的口令不是嵌在应用程序中的

36.you are installing oracle database 11g on a machine.when you run the installer,the oracle universal installer

(OUI) shows the message that says one of the procuct-specific prerequisite checks has failed

checking the available swap sapce requirements..

expected available 1512m

actual result 1018m

check complete.the overall result of this check is :failed<<<

problem:the system does not have the required swap space.

what happens to the installation in this situation?

a.it can be cotinued.

38.which two statements are ture regarding the usage of the sql*loader utlity?

a. you can load into multiple tables during the same load session.

b.you can load data from multiple files to a table during the same load session.

可以指定多个Infile字句，即B正确

可以指定一个或多个into table块，说明A正确

39.the instance abnormally terminates bcause of a power outage.which statements is true about redo 

log files during instance recovery?

c.all redo lof entries after the last checkpoints are applied from redo log files to data files;

实例恢复不需要DBA的干预

oracle db会自动从实例故障中进行恢复。实例所需要做的就是正常启动。如果oracle restart已启用并且配置为监视该数据库

则该启动操作会自动进行。实例会装载控制文件，然后尝试打开数据文件。如果实例发现数据文件在关闭期间尚未同步

则会使用重做日志组中包含的信息将数据文件前滚到关闭时的状态，此时利用的重做日志文件即是自最后一次检查点以来所有的重做信息。然后，打开数据库，并回退所有未提交的事务处理

42.to make audit information more productive ,the DBA executes the followding command before starting an audit operation;

sql>alter system set audit_trail=db,extended scope=spfile;

which statements is true regarding the audit record generated when auditing starts after restarting the database?

b.it contains the sql text executed by the user and the bind variable used with it.

通过标准审计收集的额外信息包括

系统更改号，记录对系统的每一项更改

用户执行的确切的sql文本以及与sql文本一起使用的绑定变量，只有已制定audit_trail=db,extended的情况下，这些列才会出现

45.you executed the following command perform a bakcup of the userstablesppace;

sql>alter tablespace users begin backup;

alter tablespace users begin backup

*

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

what would be the reason for this error?

b.the database is in noarchivelog mode;

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

如果未处于archivelog模式，需要shutdown数据库，启动到Mount状态进行修改

47.note the following points describing various utilities in oracle database 11g;

4:it provides a tape backup management for the oracle ecosystem

oracle secure backup增加了被分到磁带功能和操作系统文件备份。

oracle secure backup和rman一起为oracle环境提供端到端备份解决方案

48.in your database instance,the user sessions are connected to the database server from the remote machines,you want

to achive the following for these users;

1.the user account must be locked after four unsuccessful login attempts >password_lock_time

2,.the user must be the prompted to change the password at regular intervals.>password——life_time

3.the user may not have more than three simultaneous sessions.>sessions_per_user

4: The user session must automatically be logged off if more than 10 minutes elapsed time used. CONNECT_TIME

How would you accomplish the above?

a.by assigning profiles for the users

创建一个概要文件来实施口令安全

49.identify the memory component from your memory may be allocated for;

a.session memory for the shared server

2.oracle database recovery manager(rman) backup and restore operations

a.large pool

数据库管理员可以配置称为大型池的可选内存区，以便为以下对象提供大型内存分配：

共享服务器的会话内存和oracle XA借口（在事务处理或多个数据库交互时使用）

I/O服务器进程

ORACLE DB备份与还原操作

50.which two statements are true about alerts?

a.clearing an alert sends the alert to the alert history

d.server_generated alerts notify the problems that cannot be resolved automatically and require administartors to te notified

服务器生成预警分为两种类型：阈值预警和非阈值预警。

大多数服务器生成的预警是通过对数据库度量设置警告阈值和严重阈值来配置的。可为120 多个度量定义阈值，这些度量包括：

• 每秒的物理读取次数

• 每秒的用户提交次数

•SQL 服务响应时间

除了表空间的空间占用率度量与数据库相关外，其它度量都与实例相关。阈值预警又称为“有状态预警”，清空预警条件后，会自动清空这些预警。有状态预警显示在

DBA_OUTSTANDING_ALERTS中，清空后会转到DBA_ALERT_HISTORY。

服务器生成的其它预警对应于特定的数据库事件，如ORA-*错误、“快照太旧”错误、“恢复区空闲空间过少”和“可恢复会话被挂起”等。这些都不是基于阈值的预警，又称

为“无状态预警”。无状态预警会直接转到历史记录表。只在Database Control 环境中，清空无状态预警才有意义，因为Database Control 会在自身的资料档案库中存储无状态预警。服务器生成的预警对应于一些数据库时间，不会自动去解决，而是通知管理员去解决。