OCP认证考试052最新考试题库解析-20180608

2018年OCP052最新考试题库解析-20180608题库新特点：更加灵活，题库的顺序与考试时的顺序每场都在变化更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案整理：CUUG2018年OCP052最新考试题库解析-20180608•1、Whichthreearetrueaboutundosegmentsandundotablespacesinthesamedatabaseandinstance?••A.MultipletransactionsrunbythesameOracleusercanshareasingleundosegment.••B.MultipletransactionsrunbydifferentOracleuserscanshareasingleundosegment.••C.Aserialtransactioncanusemultipleundosegments.••D.Undosegmentsareautomaticallydroppedshortlyaftertransactionsthatusethemcommit.••E.Anewundosegmentisalwayscreatedforeachtransaction.••F.Adatabasecanhavemultipleundotablespaces.••CorrectAnswer:ABF2018年OCP052最新考试题库解析-20180608•2、WhichtwoaretrueabouttheDataRecoveryAdvisor?••A.ItcanbeusedonlyfordatabasesthatarerunninginARCHIVELOGmode.••B.Itcanbeusedwhenthedatabaseisclosed.••C.Itcanbeusedtovalidatedatabaserecoverystrategies.••D.Itprovidesintelligentdatabaseproblemanalysis.••E.Itcanbeusedtovalidatedatabasebackupstrategies.••F.ItcanbeusedonlyfordatabaseswithFLASHBACKenabled.••CorrectAnswer:CD2018年OCP052最新考试题库解析-20180608•3、WhichtwoaretrueaboutOracleDataPumpinOracleDatabase11gRelease2?••A.Ifthedirectoryusedintheexportoperationhasexistingdumpfiles,itoverwritesthem.••B.Itallowsencryptiontobeperformedwithoutusingapassword.••C.Itsupportstherenamingoftablesduringimport.••D.Itsupportstheexportofspecificviewsastables.••E.Itallowscompressionlevelstobedefinedfortheexport.••CorrectAnswer:BE2018年OCP052最新考试题库解析-20180608•4、ForyourORCLdatabase.•1.Theinstanceisstartedusinganspfile.•2.Thedatabaseisopened.•3.ItisinARCHIVELOGmode.•4.CONTROLFILEAUTOBACKUPISON.•Examinethiscommand:•RMANbackupascopydatafile‘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.dbf•CorrectAnswer:ACFH2018年OCP052最新考试题库解析-20180608•5、Whendoesanincrementalcheckpointoccur?••A.whenDBWnwritesdirtybuffersaspartofitsnormalprocess••B.whenthealtersystemcheckpointstatementisexecuted.••C.whenausertablespaceistakenoffline••D.whenanonlineredologswitchoccurs••CorrectAnswer:A2018年OCP052最新考试题库解析-20180608•6、Examinethisqueryanditsoutput:•SQLselectsid,event,blocking_session•fromv$session•whereblocking_sessionisnotnull;•SIDEVENTBLOCKING_SESSION•------------------------------------------•105enq:TX–rowlockcontention15••Whichtwoaretrue?••A.Theblockedsessioniswaitingonasharedtablelock.••B.Theblockedsessioniswaitingonanenqueue.••C.Theblockingsessioniswaitingonarow-levellock.••D.Session105isblockedbysession15.••E.Session105isblockingsession15.••CorrectAnswer:BD2018年OCP052最新考试题库解析-20180608••7、Inoneofyourdatabases:•1.USER1andUSER2havenosystemprivileges.•2.ROLE1onlyhastheseprivileges:•*createsession•*createtable•*createview•Examinethesecommands:•SQLconn/assysdba•Connected•SQLGRANTcreatetable,role1touser1withadminoption;•grantsuccessed•SQLconnuser1/oracle_4u•Connected•SQLGRANTrole1touser2;•grantsuccessed•7、Whichcommandwouldyouexecuteandaswhichuser,torevokethecreate•tableprivilegefromUSER2?••A.Revokecreatetablefromuser2asuser1••B.Revokecreatetablefromuser1assys••C.Revokecreatetablefromrole1asuser1••D.Revokecreatetablefromrole1assys••E.Revokecreatetablefromuser2assys••CorrectAnswer:D•如果用user1回收角色的权限，会报错：•SQLrevokecreatesessionfromrole1;•revokecreatesessionfromrole1•*•ERRORatline1:•ORA-01031:insufficientprivileges2018年OCP052最新考试题库解析-20180608•8、Whichtwoaretrueaboutserver-generatedalerts?••A.Statefulalertsmustalwaysbeclearedmanually.••B.TheyarevisibleinOracleEnterpriseManagerbydefault.••C.AllstatefulalertscanbefoundinDBA_ALERT_HISTORY.••D.Theycanbebasedonlyondatabasemetrics.••E.StatelessalertscannotbefoundinDBA_OUTSTANDING_ALERTS.••F.Theycanbebasedonlyoninstancemetrics.••CorrectAnswer:BE2018年OCP052最新考试题库解析-20180608•9、YourdatabaseinstanceisinNOMOUNTstate.•Yourselectthedeleteoptioninthedatabaseconfigurationassistant(DBCA)foryourdatabase.•Whatistheoutcome?••A.DBCAisabletodeletethedatafilesbutnottheservices.••B.DBCAshutsdowntheinstanceanddeletesthedatabase.••C.DBCAisabletodeletetheservicesbutnotthedatafiles.••D.DBCApromptsyoutoopenthedatabase,andthenproceedswiththedeletion.•CorrectAnswer:D2018年OCP052最新考试题库解析-20180608•10、Whichistruewhenadatabaseinstanceisshutdown?••A.IMMEIATE,TRANSACTIONAL,andNORMALmodeswaitforalluncommittedtransactionseithertocommitorrollbackandthenclosethedatabase••B.IMMEIATE,TRANSACTIONAL,andNORMALmodesallresultinacheckpoint••C.OnlyTRANSACTIONAL,andNORMALmodeswaitforalluncommittedtransactionstocommitorrollbackandthenclosethedatabase••D.NeithertheIMMEDIATEnortheABORTmoderollsbackuncommittedtransactions.•CorrectAnswer:B2018年OCP052最新考试题库解析-20180608•11、TheORCLdatabasehasCONTROLFILEAUTOBACKUPandBACKUPOPTIMIZATIONenabled.USER1.EMPisatableintablespaceTBS1.•Therearenoexistingbackupsofthedatabase.•Examinethesecommands:•$rmantarget/•RMANBACKUPDATABASE•RMANexit•$sqlplus/assysdba•SQLUPDATEUSER1.EMPsetSAL=5000WHEREeno=10;•1rowupdated•SQLCOMMIT•CommitComplete•SQLexit•RMANCONFIGUREEXECUTEFORTABLESPACEtbs1;•RMANBACKUPINCREMENTALLEVEL1DATABASE;••Whatistheoutcome?••A.I