ocp 052 50-70

51.which two statements are true about B-tree index?

a.the leaf blocks in the index are doubley linked

在索引的叶块是双向链表。正确，叶块在两个方向是相互关联的，这便于按键值升序或降序扫描索引

b.叶节点为每个键值存储的事rowid而不是位图

c.键列中的null值得行在索引中也有条目，错误，当某行包含的所有键列为null时，改行没有对应的索引条目。因此

当where字句指定了null时,始终会导致全表扫描

d.the deletion of a row from the table causes a logical deletion in index leaf block and the space

becomes available for the new leaf entry

从表中的行的删除操作导致逻辑删除索引的块的叶块中的空间变为可用的新的页条目，正确

删除一行只会导致对索引条目进行逻辑删除。在删除块中的所有条目之前，已删除行占用的空间

不可用于新条目，在删除后，便可用于新条目

53.the job to gather optimizer statistics for objects runs as part of the automatic maintenance window 

in your database instance.at a certain point of time ,the maintenance window closes before the statistics are gathered for all objects.which statements is true in theis scenario?

d.the job is terminated and the statistics for the remaining objecxts are collected the next time that the maintenance window is opened

一个作业在你的数据库实例的自动维护窗口为一些对象正在所及优化统计信息，在一个特定的时间点，所有对象的统计信息还没有搜集完，维护窗口就关闭了，此时

这个作业被终止，剩下的统计信息的搜集将在下次维护窗口打开的时候继续搜集

55.in your production database,data mainpulation language (DML) operations are executed on the sales table ,

you have noticed some dubious values in the sales table during the last days.you are able to track users,actions taken,anf the time of the action for this particular 

period but the changes in data are not tracked .you decide to keep the track of both the old data and the new data in the table along with the user

information ,what action would you take to ahice this task?

b.implement value-based auditing

进行数据库审计时会记录审计对象中发生的插入，更新和删除操作，但是不会捕获更改的实际值。

要扩展数据库审计，可使用基于值得审计，利用数据库触发器来捕获更多的值

56.you are managing an oracle database 11g database,the database is open,and you plan to perdorm recovery manager (RMAN) backups,which three statements are true about these backups?

b.the backups would be inconsistent

在数据库打开的情况下备份，始终是不一致的

c.the backups would be possible only if the database is running in archiverlog mode

e.the backups need to be restored and the database has to be recoverd in case of a media failure

如果出现介质故障，则用restore备份中还原数据文件，用restore通过应用增量备份和重做日志文件中记录的更改来恢复已还原文件到最近的事务点

58，view the exhibit and examine the output of the query ,what do you infer from whis?

what do you infer from this?

c.the server parameter file (spfile) was used to start the instance.

使用spfile启动时，sga_target的isspcified为true，如果为false,则是使用pfile启动

61,.user scott want to perform a bulk insert operation in the emp_dep table.scott receives the following error after the insert 

statement is issued and few rows are inserted;

insert into emp_dep (emp_id,name,salary,dep_name,mgr_id)

error at line 1;

ora-01653:unable to extend table scott.emp_dep by 128 in tablespace users

identify two actions either of which will help you resolve this problem

b.add datafile to the users tablespace

e.icrease the size of the data file associated withj the users tablespace

65.you have recently collected statistics oncertain objects of a schema in your database.but you observe suboptimal execution plans for the queries 

on these objects after two days of statistics collection .the optimizer statistics retention period is set to its default value,which action

would help use the previous set of statistics on the objexcts?

a.restore statistics from statistics history

70.your database is running with full workload after database creation ,you have decided to user

a fixed-size undo tablespace,you want to use the undo advisor to estimate the capacity of the undo tablespace

which two factors must you consider before using the undo advisor to estimate the capacity of the undo tavlespace?

a. the retention period to support flashback 

b.the expected length of the longest-running query

此题考的是，在固定大小的undo表King见，使用undo advisor 来估算指定的还原保留时间所需要的还原表空间大小

还原指导可估计满足指定的还原事件所需要的还原表空间大小

undo advisor 要考虑的两个因素是持续时间最长的查询和指定闪回持续更长时间