OCP考试052最新考试题库原题50608.docx
- 文档编号:30387445
- 上传时间:2023-08-14
- 格式:DOCX
- 页数:9
- 大小:50.47KB
OCP考试052最新考试题库原题50608.docx
《OCP考试052最新考试题库原题50608.docx》由会员分享,可在线阅读,更多相关《OCP考试052最新考试题库原题50608.docx(9页珍藏版)》请在冰豆网上搜索。
OCP考试052最新考试题库原题50608
052题库解析
OCP考试052最新考试题库原题-5-20180608
题库新特点:
更加灵活,题库的顺序与考试时的顺序每场都在变化
更加考验知识点的掌握,题库答案为二,考试时要求选择
最佳一个答案
不断有新的考题出现,目前最新已经更新到130道题
1、Whichthreearetrueaboutundosegmentsandundotablespacesinthesamedatabaseandinstance?
•A.MultipletransactionsrunbythesameOracleusercan
shareasingleundosegment.
•B.MultipletransactionsrunbydifferentOracleuserscan
shareasingleundosegment.
•C.Aserialtransactioncanusemultipleundosegments.
•D.Undosegmentsareautomaticallydroppedshortlyafter
transactionsthatusethemcommit.
•E.Anewundosegmentisalwayscreatedforeachtransaction.•F.Adatabasecanhavemultipleundotablespaces.•CorrectAnswer:
ABF
2、WhichtwoaretrueabouttheDataRecoveryAdvisor?
•A.Itcanbeusedonlyfordatabasesthatarerunningin
ARCHIVELOGmode.
•B.Itcanbeusedwhenthedatabaseisclosed.•C.Itcanbeusedtovalidatedatabaserecoverystrategies.•D.Itprovidesintelligentdatabaseproblemanalysis.•E.Itcanbeusedtovalidatedatabasebackupstrategies.•F.ItcanbeusedonlyfordatabaseswithFLASHBACKenabled.•CorrectAnswer:
CD
3、WhichtwoaretrueaboutOracleDataPumpinOracleDatabase11gRelease2?
•A.Ifthedirectoryusedintheexportoperationhasexisting
dumpfiles,itoverwritesthem.
•B.Itallowsencryptiontobeperformedwithoutusinga
password.
•C.Itsupportstherenamingoftablesduringimport.•D.Itsupportstheexportofspecificviewsastables.•E.Itallowscompressionlevelstobedefinedfortheexport.•CorrectAnswer:
BE
4、ForyourORCLdatabase.
1.Theinstanceisstartedusinganspfile.
2.Thedatabaseisopened.
3.ItisinARCHIVELOGmode.
4.CONTROLFILEAUTOBACKUPISON.Examinethiscommand:
RMAN>backupascopydatafile‘users01.dbf’,’example01.dbf’;Whichfourfilesarebackedup?
•A.spfile
•B.undo01.dbf•C.users01.dbf•D.archivelogs•E.sysaux01.dbf•F.controlfile
•G.system01.dbf
•H.example01.dbfCorrectAnswer:
ACFH
5、Whendoesanincrementalcheckpointoccur?
•A.whenDBWnwritesdirtybuffersaspartofitsnormalprocess•B.whenthealtersystemcheckpointstatementisexecuted.•C.whenausertablespaceistakenoffline•D.whenanonlineredologswitchoccurs•CorrectAnswer:
A
6、Examinethisqueryanditsoutput:
Whichtwoaretrue?
•A.Theblockedsessioniswaitingonasharedtablelock.•B.Theblockedsessioniswaitingonanenqueue.•C.Theblockingsessioniswaitingonarow-levellock.•D.Session105isblockedbysession15.
•E.Session105isblockingsession15.•CorrectAnswer:
BD
•7、Inoneofyourdatabases:
1.USER1andUSER2havenosystemprivileges.
2.ROLE1onlyhastheseprivileges:
*createsession
*createtable*createview
Examinethesecommands:
7
Whichcommandwouldyouexecuteandaswhichuser,torevokethecreatetableprivilegefromUSER2?
•A.Revokecreatetablefromuser2asuser1•B.Revokecreatetablefromuser1assys•C.Revokecreatetablefromrole1asuser1•D.Revokecreatetablefromrole1assys•E.Revokecreatetablefromuser2assys•CorrectAnswer:
D
如果用user1回收角色的权限,会报错:
SQL>revokecreatesessionfromrole1;revokecreatesessionfromrole1*
ERRORatline1:
ORA-01031:
insufficientprivileges
8、Whichtwoaretrueaboutserver-generatedalerts?
•A.Statefulalertsmustalwaysbeclearedmanually.•B.TheyarevisibleinOracleEnterpriseManagerbydefault.•C.AllstatefulalertscanbefoundinDBA_ALERT_HISTORY.•D.Theycanbebasedonlyondatabasemetrics.
•E.Statelessalertscannotbefoundin
DBA_OUTSTANDING_ALERTS.
•F.Theycanbebasedonlyoninstancemetrics.•CorrectAnswer:
BE
9、YourdatabaseinstanceisinNOMOUNTstate.
Yourselectthedeleteoptioninthedatabaseconfigurationassistant(DBCA)foryourdatabase.
Whatistheoutcome?
•A.DBCAisabletodeletethedatafilesbutnottheservices.•B.DBCAshutsdowntheinstanceanddeletesthedatabase.•C.DBCAisabletodeletetheservicesbutnotthedatafiles.
•D.DBCApromptsyoutoopenthedatabase,andthenproceeds
withthedeletion.
CorrectAnswer:
D
10、Whichistruewhenadatabaseinstanceisshutdown?
•A.IMMEIATE,TRANSACTIONAL,andNORMALmodeswaitforalluncommittedtransactionseithertocommitorrollbackandthenclosethedatabase
•B.IMMEIATE,TRANSACTIONAL,andNORMALmodesallresult
inacheckpoint
•C.OnlyTRANSACTIONAL,andNORMALmodeswaitforalluncommittedtransactionstocommitorrollbackandthenclosethedatabase
•D.NeithertheIMMEDIATEnortheABORTmoderollsback
uncommittedtransactions.
CorrectAnswer:
B
11、TheORCLdatabasehasCONTROLFILEAUTOBACKUPandBACKUPOPTIMIZATIONenabled.USER1.EMPisatableintablespaceTBS1.
Therearenoexistingbackupsofthedatabase.Examinethesecommands:
•Whatistheoutcome?
•A.Ittakesalevel0incrementalbackupofORCLwithTBS1.•B.Ittakesalevel1incrementalbackupofORCLwithoutTBS1.•C.Ittakesalevel0incrementalbackupofORCLwithoutTBS1.•D.Ittakesalevel1incrementalbackupofORCLwithTBS1.•CorrectAnswer:
C
12、WhichtwostatementsaretrueaboutdispatchersusedbytheOraclesharedserver?
•A.Multipleuserprocessescanconnecttoasingledispatcher.•B.Theyreturncompletedrequeststotheappropriateuser
processes.
•C.Adispatcheriscreatedforeachuserprocess.
•D.Multipledispatcherscanconnecttoasingleserverprocess.•E.Theypullrequestsfromtherequestsqueueandprocess
themuntiltheyarecomplete.
•CorrectAnswer:
AB
13、Examinethissessionoutput:
Whichtwowillgenerateanauditrecord?
•A.everyDDLstatementexecutedbySCOTTthataffectsSCOTT.EMP•B.everyUPDATEstatementexecutedbySCOTTthatupdatesSCOTT.EMP•C.onlythefirstSELECTstatementexecutedbySCOTTisasessiononSCOTT.EMP•D.onlythefirstDMLstatementexecutedbySYSTEMinasessiononSCOTT.EMP•E.everyUPDATEstatementexecutedbySCOTTthatupdatesHR.EMP•F.anyDMLstatementexecutedbySYSonSCOTT.EMP
•CorrectAnswer:
AB
14、Inwhichtwocasesisaconsistentdatabasebackupcreated?
•A.whentheRMANBACKUPcommandisusedwhilethe
databaseisOPENREADONLY
•B.whentheRMANBACKUPASCOPYcommandisusedwhile
thedatabaseisOPENRESTRICTED
•C.whentheRMANBACKUPASCOPYcommandisusedwhile
thedatabaseisOPEN
•D.whenO/Scommandsareusedtocopydatabasefilesaftera
databaseinstanceisshutdownnormally
•E.whentheRMANBACKUPcommandisusedwhilethe
databaseismounted
CorrectAnswer:
AD
只读表空间下用rman备份时没有发生检查点,无需更改数据文件头部,所以可以备份数据库。
15、WhichtwoaretrueaboutUNDOdata?
•A.InactiveUNDOisneverwrittentodisk.•B.ActiveUNDOisalwayskeptinmemory•C.OnlyDMLstatementsgenerateUNDO.•D.ActiveUNDOcanneverbeoverwritten.
•E.ItcanbeusedtorestoreatablebyusingFLASHBACKTABLE.•F.InactiveUNDOcannotbeoverwrittenuntiltheelapsedtime
sincebecominginactiveexceedsUNDORETENTION.
CorrectAnswer:
DE
16、Yousuccessfullyexecutedthesecommands:
Whichtypeofdatabaselinkiscreated?
•A.privatecurrentuserdatabaselink.•B.publiccurrentuserdatabaselink•C.privatefixeduserdatabaselink•D.publicconnecteduserdatabaselink•E.publicfixeduserdatabaselinkCorrectAnswer:
C
Createdatabaselinkconnecttocurrent…
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- OCP 考试 052 最新 题库 50608
![提示](https://static.bdocx.com/images/bang_tan.gif)