考试052最新考试题库解析_精品文档_002.pptx
- 文档编号:1276460
- 上传时间:2022-10-20
- 格式:PPTX
- 页数:17
- 大小:142.95KB
考试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
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 考试 052 最新 题库 解析 精品 文档 _002