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…
升级会员 