20151231 OCP 053 90-120

93.the oracle_sid environment variable is set to +asm,asmlb is  not used in the configuration.you executed the following command to statrtup the automatic storage management (ASM) instance .

sql>startup

which two activities are perfored to use the ASM instance are mounted

b.the disk groups are mounted as per the ASM_DISKGROUPS intialization parameter 

ASM启动时会加载磁盘组

c.asm starts the oracle cluster synchronization services(CSS) deamon if it is not started 

ASM是依赖于css守护进程的，因此在启动ASM实例前要确保css守护进程已经启动

95.sql profile recommendations

during sql tuning,you select a statement for automatic tuning and run sql tuning advisor.the database can profile 

the following types of statement 

DML statements

create table statements

merge statements

sql tuning advisor invokes automatic tuning optimizer to generate recommendations

97.the emp table exists in your schema.you want to execute the following query:

select rname,sal from emp as of timestamp(systimestamp-interval '6' munute)

where ename='allen'

what are the mu8nimum requirments for the statemenbt to execute sucdessfully

d.the undo_management parameter must be set to auto

e.the undo_retention parameter must be set appropriately

闪回查询是基于undo数据的，所以只要保证要闪回的时间点有undo数据就可以

99.you want to create the recovery manager(rman) virtual private catalog(VPS)

to maintain a separation of reponsibilities along with a consolidation of rman reposity .which conditoon must be met before you create the vps?

a.a base catalog exists

在创建vpc时，首先是目录所有者来创建基本目录

100.you plan to control idle sessions that are blocking other sessions from performing trasations.you requirement is to 

automatically terminate blocking sessions when they remain idle for a 

specified amount of time

how would you accoplish this task?

b.implement database resource manager

利用数据库资源管理器提供空闲时间限制：指定会话的空闲时间，超过该时间后终止会话

102.for which two database objects can the versions clause of the flashback versions query be used?

a.views 

b.fixed tables 

固定表信息通常通过v$views访问，里面的信息通常由oracle维护，不可以闪回

c.heap tables

d.external tables

外部表不能执行dml，当然也不可能flashback

e.temporary tables

临时表数据commit或会话结束后丢失，不可flashback

f.index-organized tables

106.what does the DB_FLASHBACK_RETENTION_TARGET parameter configure?

c.the amount of time for which the flashback data is to be kept in the flash recovery area,procied that there is enough space

108.关于automatic fiagonostic repository 

e.the adr can be used for the problem diagnosis even when the database instance is down

即使在数据库关闭的情况下依然可以使用adr

f.the adr base isshared across multiple instance

可以供多个实例使用共享

109.you want to tabke a complete database backup using rman.the backup should consist only the used blocks from your database

which two statements are true about this backup operation？

a.backup compression should be enabled

只备份使用过的快，备份时可以不用压缩

b.parallesim  for the channel should be set to 2

也不用设置两个通道

111.to enable faster incremental backups.you enabled block change tracking for the database.

which two statements are true about the block change tracking file?

c.rman does not support backup and recovery of the change tracking file

d.the database cleares the change traking file and starts tracking changes again,after whole database restore and recovery operartions

115.indentify two advantages of using recovery catalog instead of the control file of the database in 

recovery manager(RMAN)

a.you can use rman stored scripts

c.you can store backup information of all registered databases in one place

116.the database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace temp 

has been corruted .what steps should you take to recover from this tempfile loss in an efficient manner?

d.allow the database to continuew runing ,add a new tempfile to temp tablespace within a new name,and drop the tempfile that has been corrupted

在11g中，如果删除临时文件，重启后会自动重新生成

如果手工恢复，因为临时文件不会影响数据库的运行，所以可以直接添加一个新的文临时文件，

把损坏的frop 掉

120.which two operations are not performed by the buplicate command in recovery manager while duplicating a runing database?

c.perforimg complete recopvery using all acailable backups

open状态只能热备份，因为redo无法应用，只能不完全恢复

e.copying the onlie redo log files from the target database to ther duplicate database

因为元数据库中的练级重做日志文件未备份且无法应用于副本数据库，就算复制也没用