OCP043题库详细注解版.docx
- 文档编号:14089286
- 上传时间:2023-06-20
- 格式:DOCX
- 页数:113
- 大小:929.03KB
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,要
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- OCP043 题库 详细 注解