考试052最新考试题库解析_精品文档_002.pptx

考试052最新考试题库解析_精品文档_002.pptx

《考试052最新考试题库解析_精品文档_002.pptx》由会员分享，可在线阅读，更多相关《考试052最新考试题库解析_精品文档_002.pptx（17页珍藏版）》请在冰豆网上搜索。

2018年OCP052最新考试题库解析-20180608,题库新特点：

更加灵活，题库的顺序与考试时的顺序每场都在变化更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案整理：

CUUG,2018年OCP052最新考试题库解析-20180608,1、Whichthreearetrueaboutundosegmentsandundotablespacesinthesamedatabaseandinstance?

A.MultipletransactionsrunbythesameOracleusercanshareasingleundosegment.B.MultipletransactionsrunbydifferentOracleuserscanshareasingleundosegment.C.Aserialtransactioncanusemultipleundosegments.D.Undosegmentsareautomaticallydroppedshortlyaftertransactionsthatusethemcommit.E.Anewundosegmentisalwayscreatedforeachtransaction.F.Adatabasecanhavemultipleundotablespaces.CorrectAnswer:

ABF,2018年OCP052最新考试题库解析-20180608,2、WhichtwoaretrueabouttheDataRecoveryAdvisor?

A.ItcanbeusedonlyfordatabasesthatarerunninginARCHIVELOGmode.B.Itcanbeusedwhenthedatabaseisclosed.C.Itcanbeusedtovalidatedatabaserecoverystrategies.D.Itprovidesintelligentdatabaseproblemanalysis.E.Itcanbeusedtovalidatedatabasebackupstrategies.F.ItcanbeusedonlyfordatabaseswithFLASHBACKenabled.CorrectAnswer:

CD,2018年OCP052最新考试题库解析-20180608,3、WhichtwoaretrueaboutOracleDataPumpinOracleDatabase11gRelease2?

A.Ifthedirectoryusedintheexportoperationhasexistingdumpfiles,itoverwritesthem.B.Itallowsencryptiontobeperformedwithoutusingapassword.C.Itsupportstherenamingoftablesduringimport.D.Itsupportstheexportofspecificviewsastables.E.Itallowscompressionlevelstobedefinedfortheexport.CorrectAnswer:

BE,2018年OCP052最新考试题库解析-20180608,4、ForyourORCLdatabase.1.Theinstanceisstartedusinganspfile.2.Thedatabaseisopened.3.ItisinARCHIVELOGmode.4.CONTROLFILEAUTOBACKUPISON.Examinethiscommand:

RMANbackupascopydatafileusers01.dbf,example01.dbf;Whichfourfilesarebackedup?

A.spfileB.undo01.dbfC.users01.dbfD.archivelogsE.sysaux01.dbfF.controlfileG.system01.dbfH.example01.dbfCorrectAnswer:

ACFH,2018年OCP052最新考试题库解析-20180608,5、Whendoesanincrementalcheckpointoccur?

A.whenDBWnwritesdirtybuffersaspartofitsnormalprocessB.whenthealtersystemcheckpointstatementisexecuted.C.whenausertablespaceistakenofflineD.whenanonlineredologswitchoccursCorrectAnswer:

A,2018年OCP052最新考试题库解析-20180608,6、Examinethisqueryanditsoutput:

SQLselectsid,event,blocking_sessionfromv$sessionwhereblocking_sessionisnotnull;SIDEVENTBLOCKING_SESSION-105enq:

TXrowlockcontention15Whichtwoaretrue?

A.Theblockedsessioniswaitingonasharedtablelock.B.Theblockedsessioniswaitingonanenqueue.C.Theblockingsessioniswaitingonarow-levellock.D.Session105isblockedbysession15.E.Session105isblockingsession15.CorrectAnswer:

BD,2018年OCP052最新考试题库解析-20180608,7、Inoneofyourdatabases:

1.USER1andUSER2havenosystemprivileges.2.ROLE1onlyhastheseprivileges:

*createsession*createtable*createviewExaminethesecommands:

SQLconn/assysdbaConnectedSQLGRANTcreatetable,role1touser1withadminoption;grantsuccessedSQLconnuser1/oracle_4uConnectedSQLGRANTrole1touser2;grantsuccessed7、Whichcommandwouldyouexecuteandaswhichuser,torevokethecreatetableprivilegefromUSER2?

A.Revokecreatetablefromuser2asuser1B.Revokecreatetablefromuser1assysC.Revokecreatetablefromrole1asuser1D.Revokecreatetablefromrole1assysE.Revokecreatetablefromuser2assysCorrectAnswer:

D如果用user1回收角色的权限，会报错：

SQLrevokecreatesessionfromrole1;revokecreatesessionfromrole1*ERRORatline1:

ORA-01031:

insufficientprivileges,2018年OCP052最新考试题库解析-20180608,8、Whichtwoaretrueaboutserver-generatedalerts?

A.Statefulalertsmustalwaysbeclearedmanually.B.TheyarevisibleinOracleEnterpriseManagerbydefault.C.AllstatefulalertscanbefoundinDBA_ALERT_HISTORY.D.Theycanbebasedonlyondatabasemetrics.E.StatelessalertscannotbefoundinDBA_OUTSTANDING_ALERTS.F.Theycanbebasedonlyoninstancemetrics.CorrectAnswer:

BE,2018年OCP052最新考试题库解析-20180608,9、YourdatabaseinstanceisinNOMOUNTstate.Yourselectthedeleteoptioninthedatabaseconfigurationassistant（DBCA）foryourdatabase.Whatistheoutcome?

A.DBCAisabletodeletethedatafilesbutnottheservices.B.DBCAshutsdowntheinstanceanddeletesthedatabase.C.DBCAisabletodeletetheservicesbutnotthedatafiles.D.DBCApromptsyoutoopenthedatabase,andthenproceedswiththedeletion.CorrectAnswer:

D,2018年OCP052最新考试题库解析-20180608,10、Whichistruewhenadatabaseinstanceisshutdown?

A.IMMEIATE,TRANSACTIONAL,andNORMALmodeswaitforalluncommittedtransactionseithertocommitorrollbackandthenclosethedatabaseB.IMMEIATE,TRANSACTIONAL,andNORMALmodesallresultinacheckpointC.OnlyTRANSACTIONAL,andNORMALmodeswaitforalluncommittedtransactionstocommitorrollbackandthenclosethedatabaseD.NeithertheIMMEDIATEnortheABORTmoderollsbackuncommittedtransactions.CorrectAnswer:

B,2018年OCP052最新考试题库解析-20180608,11、TheOR