20160102 OCP 053 150-180

151.which are the two prerequisistes before setting up flashback dataarchive?

d.automatic undo management must be enabled 

e.the tablespace in which the flashback data archive is created must have automatic segment space management(ASSM)

152.you have enabled backup optimization for the rman environment,identify two criteria on which rman will skip the file 

if it has already been backed up

c.the backup was taken after the data files was taken offline normal os s in the read only mode
这个很好理解，数据文件脱机或只读，不会发生改变，所以无需备份

d.the data file backup conplies with the back retention plicy and the backup dumplexing feature 

153.you are using the controlfile to maintain information about the database backups that are being performed by recovery manager

identify two scenarios is which you must have a recovery catalog

必须只用恢复目录的场景

a.to store the backup informaton of multiple database

可以存储多个数据库的备份信息，恢复目录可以做到，而控制文件只能记录一个数据库的备份信息

d.to list the data files that in a target database at a given time by using the at option of report chema command

160.you want to use the automatic management of backup and recover y operations features for your database

which configuration must you set、、

a.enable the flash recovrry area and specify is as the archived redo log destination

使fra变为可用，并且制定fra为归档日志的目的地

162.to accoplish user-managed backup for the users tablespace,you issued the following command to put the database in backup mode

sql>alter tablespace users begin backup;

while coping the file to te backup destination a power outage caused the instance to terminate abnormally

which is true about the next database startup and the users tablespace?

c.the database will be mounted ,and data files in the users tablespace must be taken out of the backup mode

169.identify the channel setting that can be performed using the configure channel or allocate channel commands in rman 

a.limiting the io bbandwidth consumption

c.spacecifying vendor-spaceific information for a media manager

170.what two are the prerequisites for enableling flashback database?

a.the database must be in archivelog mode

数据库级别的闪回必须要在归档模式

b.the database must be in mount exclusive mode

必须要在独占模式下才能闪回

180.which two client requests are captured during database replay capture?

c.login and logoff activities of sessions

e.data definition langguange and data information manipulation language operations