OCP043题库详细注解版.docx
《OCP043题库详细注解版.docx》由会员分享，可在线阅读，更多相关《OCP043题库详细注解版.docx（113页珍藏版）》请在冰豆网上搜索。
OCP043题库详细注解版
题库二（题有注解，对应书页码出处，本题库适合学习时候用，考试覆盖2-3%）
A.186开始是RMAN
B.214开始是资源管理，常规问题
C.227开始是访问安全
D.230开始是不完全恢复
E.263开始是FLASHBACK
F.303开始是数据修复DBVERIFYANALYZE
G.317开始是Advisor
H.326磁盘管理ASM
I.342开始是国际化TIMEZONE共4题
J.346是索引
K.347是数据库编码
L.348-349是TIMEZONE
M.350开始是资源计划RESOURCEMANAGE
N.366开始是JOB
O.376开始是索引
P.404开始是监听
Q.417开始内存分配
（题号编排是接题库一的185开始）
（题库二）
186、YouaremaintainingyourdatabaseinOracle10g.Youarenotusingtherecoverycatalogtomaintainthebackupinformationofyourdatabase.WhichfilecanbeusedasarepositorytostoreinformationregardingtheRMANbackup?
A.onlineredologfiles
B.alertlogfiles
C.controlfile
D.datafilesassociatedwiththeSYSTEMtablespace
187.YouaremaintainingyourdatabaseinOracle10g.Youwanttostoretheinformationaboutthebackupofthedatabaseinthecontrolfile.Youissuethefollowingstatement:
SQL>ALTERSYSTEMSETCONTROL_FILE_RECORD_KEEP_TIME=400;
Whatistheoutcomeofthisstatement?
A.Thestatementwillnotexecutesuccessfully.
B.Thestatementwillexecutesuccessfully,andthebackupsmetadatawillbemaintainedinthecontrolfilefor400days
C.Thestatementwillexecutesuccessfully,andthebackupsmetadatawillbemaintainedintherecoverycatalogfor400days.
D.Backupswillbedeletedfromthemediaafter400days.
NOTE：
043书5-10，CONTROL_FILE_RECORD_KEEP_TIME是初始化参数
188.Youhaveissuedthefollowingcommand:
RMAN>CONFIGURERETENTIONPOLICYTORECOVERYWINDOWOF100DAYS;
Whatwillbetheresultofusingtheabovecommand?
A.Thebackupmetadatawillbemaintainedinthecontrolfilefor100days.
B.Thebackupmetadatawillbemaintainedintherecoverycatalogfor100days.
C.Thebackupmetadatawillbemaintainedintheflashrecoveryareafor100days.
D.After100days,thebackupsetsandimagecopieswillbedeletedfromthemedia.
NOTE：
要求保留备份，可以恢复到100天内的任意时间点，100天以后如果没有资源竞争仍然保留。
Backupfile存在flashrecoveryarea,而backupmetadata存在recoverycatalog里。
189.Youareperformingabackupofyourdatabaseacrossthenetwork.Whiletakingthebackup,youwanttosavespaceonthestoragemediaandreducethenetworkbandwidth.Whichcommandwillyouissuetoconfiguretherequiredtypeofbackup?
A.CONFIGUREDEVICETYPETOsbtBACKUPTYPETOBACKUPSET;
B.CONFIGUREDEVICETYPETOdiskBACKUPTYPETOCOPY;
C.CONFIGUREDEVICETYPETOsbtBACKUPTYPETOCOMPRESSEDBACKUPSET;
D.CONFIGUREDEVICETYPETOsbtBACKUPTYPETOCOMPRESSEDCOPY;
NOTE:
043书6-12，RMANchanneltosbt。
190.YouaremaintainingtheSALESdatabaseofacompany.YouhaveneverbackeduptheUSERStablespacethatiscurrentlyoffline.OnSunday,youissuedthefollowingcommands:
CONFIGUREDEFAULTDEVICETYPETOsbt;
CONFIGUREBACKUPOPTIMIZATIONON;
CONFIGURERETENTIONPOLICYTOREDUNDANCY3;
FromMondaytoSaturday,youperformedthefollowingactions:
DayAction
MondayBACKUPDATABASE
TuesdayBACKUPDATABASE
WednesdayBACKUPDATABASE
ThursdayBACKUPDATABASE
FridayBACKUPDATABASE
SaturdayBACKUPDATABASE
HowmanytimeswillthebackupoftheUSERStablespacebeperformed?
A.Thebackupwillnotbeperformedatall.
B.threetimes
C.fourtimes
D.sixtimes
NOTE:
043书6-28，备份不少于3个。
191.YouissuedtheRMAN>SHOWALL;command.Theoutputofthecommandisasfollows:
Afteranalyzingthisoutput,whatconclusioncanyoudraw?
（Choosetwo.）
A.Ifyouperformabackupacrossanetwork,thenthebackupwillreducethebandwidth.
B.Ifyouperformabackupofadatafile,thenthebackupwillbethesameastheoperatingsystemcopyofthedatafile.
C.Ifyouperformabackupofasingledatafile,thenthecontrolfilewillnotbebackedup.
D.Themaximumsizeofeachbackupsetis10MB.
E.Thebackupswillbeperformedonthedisk.
NOTE:
043书6-8
192.YouissuedtheRMAN>SHOWALL;command.Theoutputofthiscommandisasfollows:
Afteranalyzingtheoutput,whichconclusionwillyoudraw?
A.Thebackupsconsistofbackuppieces.
B.Thedatafilescanbemultiplexedwithinthebackup.
C.Thebackupscanbestoredonlyonthedisk.
D.Whileperformingthebackupacrossanetwork,thenetworkbandwidthisreduced.
NOTE:
043书6-8
193.YouissuedthefollowingRMANcommand:
RMAN>CONFIGURECONTROLFILEAUTOBACKUPON;
WhatisNOTanimpactofusingtheabovecommand?
A.WhenasuccessfulbackupisrecordedintheRMANrepository,thenabackupofthecurrentcontrolfileisperformed.
B.Whenastructuralchangeismadetothedatabase,thenabackupofthecurrentcontrolfileisperformed.
C.WhenasuccessfulbackupisperformedintheRMANrepository,thenabackupofthespfileisperformed.
D.Whenastructuralchangeismadetothedatabase,thenabackupofthealertlogfilewillbeperformed.
NOTE:
043书8-7将备份控制文件和参数文件（如果以参数文件启动），当RMAN备份完成写到保存地址，或数据库结构变化影响导致控制文件变化后。
194.YouadministeranOracleDatabase10gandathird-partydatabase.YouuseRecoveryManager（RMAN）toperformbackupandrecoveryoperations.YouhaveconfiguredarecoverycatalogtoactasanRMANrepository.TowhichofthefollowingdatabasescanyouNOTconnectusingtheRMANCONNECTcommand?
A.targetdatabase
B.auxiliarydatabase
C.third-partydatabase
D.recoverycatalogdatabase
195.YouissuethefollowingRMANcommandtosetaretentionpolicyonadatabase:
RMAN>CONFIGURERETENTIONPOLICYTOREDUNDANCY2;
Whatwillbetheoutcomeoftheabovecommand?
A.Aftertwodays,thebackupwillbemarkedobsolete.
B.Aftertwodays,thebackupwillbedeletedfromthemedia.
C.IftheRMANrepositoryhasrecordsoftwoormorerecentbackupsofafile,thentheolderbackupwillbedeletedfromthemedia.
D.IftheRMANrepositoryhasrecordsoftwoormorerecentbackupsofafile,thentheolderbackupwillbemarkedobsolete.
NOTE:
043书6-28，redundancy策略是保留两份，window是保留两天。
196.YouareusingRecoveryManager（RMAN）forbackupandrecoveryoperations.YourbackupandrecoverypolicyissuchthatyouareperformingfulldatabasebackupeveryTuesdayandFriday.YouconfigureRMANusingthefollowingcommand:
RMAN>CONFIGURERETENTIONPOLICYTORECOVERYWINDOWOF4DAYS;
Allbackupandarchivedredologsgeneratedduringthecurrentweekareasfollows:
WhichofthefollowingfileswillbelistedwhenissuingtheREPORTOBSOLETEcommandonSunday?
A.thearchivedredologwiththelogsequence520
B.thebackupfilesfromthefulldatabasebackupperformedonTuesday
C.thearchivedredologwiththelogsequence520andthebackupfilesfromthefulldatabasebackupperformedonTuesday
D.archivedredologswiththelogsequences520,521,522andthebackupfilesfromthefulldatabasebackupperformedonTuesday
NOTE:
043书6-28，全备是不受限制的。
197.Thesizeofthelargestdatafile,data1.dbf,inyourdatabaseis30MB.Youissuedthefollowingcommand:
RMAN>CONFIGUREMAXSETSIZE10MB;
Whatwillbetheimpactoftheabovesetting?
A.Whileperformingthebackupofthedatafile,data1.dbf,onebackupsetiscreated.
B.Whileperformingthebackupofthedatafile,data1.dbf,twobackupsetsarecreated.
C.Whileperformingthebackupofthedatafile,data1.dbf,threebackupsetsarecreated.
D.Whileperformingthebackupofthedatafile,data1.dbf,thecommandforperformingabackupofthedatafile,data1.dbf,willfail.
NOTE:
改小数据文件大小后，做备份失败。
198.YourdatabaseisrunningintheARCHIVELOGmode.YouhaveconfiguredRMANforbackupandrecoveryoperations.YouexecutethefollowingcommandfromtheRMANprompt:
RMAN>CONFIGURECONTROLFILEAUTOBACKUPON;
Afterexecutingthiscommand,inwhichofthefollowingcaseswillRMANmakeanauto-backupofthecontrolfile?
（Chooseallthatapply.）
A.whenyouchangethenameofadatafile
B.whenyoudropatablefromthedatabase
C.whenyoutakeanexportofthedatabase
D.whenyoubackupthedatabaseusingOSutilities
E.whenyouissueanALTERSYSTEMSWITCHLOGFILEstatement
F.whenyouissueaBACKUPcommandfrominsidetheRMANrunblock
NOTE:
凡是引起控制文件变化的都会记录的，修改数据文件，切换日志会有序列的变化被记录到控制文件，在RMAN中执行命令记录到RMAN备份集也会自动备份。
199.YouissuedtheRMAN>SHOWALL;command.Theoutputofthiscommandisasfollows:
Afteranalyzingtheoutput,whichconclusionwillyoudraw?
A.Thecurrentcontrolfileisnotautomaticallybackedupeverytimeyouperformabackup.
B.Thebackupssavespaceonthestoragemedia.
C.Whileperformingbackupsacrossanetwork,thenetworkbandwidthisreduced.
D.Thebackupsconsistofbackuppieces.
200.YouaremaintainingyourdatabaseinOracle10g.Youarenotusingtherecoverycatalogtomaintainthebackupmetadatainformation.Youwanttoenablethereusablesectionofthecontrolfiletoexpanditselfiftheoldestrecordcannotbereused,andwheneveranewrecordisaddedtothereusablesectionofthecontrolfile.
WhichvaluewillyousetfortheCONTROL_FILE_RECORD_KEEP_TIMEparameter?
A.Zero
B.Oneormore
C.NONE
D.DEFAULT
NOTE:
043书5-10，CONTROL_FILE_RECORD_KEEP_TIME保留天数是指RMAN在controlfile里保存时间，默认是7，当使用catalog时，应尽可能小。
201.YouwanttoimplementthebackupandrecoverystrategyinyourdatabaseusingRecoveryManager（RMAN）.YouhavechosenthecontrolfileofthetargetdatabasefortheRMANrepository.
Whichcommand-lineRMANcommandwouldyouusetoestablishalocalconnectionbetweenRMANandtheRMANrepositoryifyourdatabaseisusingpasswordfileauthentication?
A.rmanTARGET/NOCATALOG
B.rmanTARGETsys/password
C.rmanTARGETsys/passwordASSYSDBA
D.rmanTARGETsys/password@db_nameCATALOG
rman_user/rman_password@rcat
202.YouaremaintainingyourproductiondatabaseinOracle10g.Youwantthecircularreuserecordsinthecontrolfileofthetargetdatabasetobereusedasrequired.
WhichvaluewillyousetfortheCONTROL_FILE_RECORD_KEEP_TIMEinitializationparameter?
A.0
B.1
C.NONE
D.DEFAULT
NOTE:
043书5-10，要
升级会员 