20151229 053 30-60

31.which of the following is a benifit of asm fast disk resync?

a.failed disks are taken offline immeidately but are not dropped

ASM快速镜像重新同步可以显著减少重新同步临时故障磁盘所需要的时间，如果某个磁盘因临时故障而脱机

ASM将跟踪在中断期间发生修改的区，临时故障恢复后，asm可以快速地仅重新同步在中断期间受影响的asm磁盘区

某个asm磁盘路径出现故障时，如果已设置了相应磁盘组的disk_repair_time属性，

则asm磁盘会脱机，但不会被删除。此属性的设置确定了asm可容忍的磁盘中UA断持续时间；

如果中断在此时间范围内，则修复完成后仍可重新同步

32.which of the following is not a configurable attribute for an individual disk group?
e.dg_drop_time

33.view the exhibit for some of the current parameter setting

a user logs to the hr schema and issues the following commands;

sql>create table emp(

empno number(3),

ename varchar2(20),

sal number(8,2));

sql>insert into emp(empno,ename) values (1,'james')

at this moment,a second user also logs into the hr schema and issues the following commnad

alter table emp mopdify sal number(10,2);

what happens in the above scenario?

c.the second user's session waits for a time period before producing the resourse busy error

DDL_LOCK_TIMEOUT specifies a time limit for how long ddl statements will wait in a dml lock queue

the default value of 1000000seconds will result in the ddl statement waiting foreever to acqire a dml lock

if a lock is not acquied before the timeout period expires then an error is returned

35.you are managing an oracle database 11g database .you want to take the backup of mult_data,a big file

tablespace of size 100tb on tape drive,but you have tapedrives of only 10gb each

which method would accomplish the task quickly and effciently?

d.intrafile parallel backup

rman的新增功能

对超大型文件应用intrafile并行备份和还原

在备份单一大型数据文件时，现在可以使用多个并行服务器进程和‘通道’来有效地分配工作量

这种使用多个部分的方法改善了备份的性能

36.which statement is true regarding virtual private catalog?

d.to perform most of the rman operarions,the virtual catalog owner must havce the sysdba or sysoper privilege on the target database

作为虚拟目录所有者，你只能查看授予了你访问权限的数据库

如果目录所有者未被授予对目标数据库的sysdba或sysoper的权限，则无法执行大多数rman操作

37.in oracle11g,which recommendations does the sql acdcess advisor generate ?

b.statistics collection recommendations

只有statistics静态的是不支持的

38.which tuning tool recommends how to optimize materialized views so that these views can tabke advantage 

of the general query rewrite feature?

b.sql access advisor

sql访问指导：评估sql的全部工作量，并建议索引，分区和实体化视图，他们讲改善sql工作量的总体性能

42.what is the location of the automatic diagnostic repository(ADR) home?

b./u01/app/oracle

如果oracle_base环境变量已设置，则diagnostic_dest被设置为$ORACLE_BASE

43，做一个模拟实验

alter tablespace t1 begin backup;

模拟断电 shutabort

再启动

需要在Mount状态执行alter tablespace end backup 才能使数据库open;

47.

a.the bzip2 compression algorithm consumes more cpu resources than the zlib compression algorithm

50.compressed

压缩备份可以节省空间，减小带宽

53.to create and execute an rman stored script ,you must use a recovery catalog

如果要使用rman存储脚本就必须使用恢复目录