OCP考试052最新考试题库原题50608.docx

1、OCP考试052最新考试题库原题50608052题库解析OCP考试052最新考试题库原题-5-20180608题库新特点：更加灵活，题库的顺序与考试时的顺序每场都在变化更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案不断有新的考题出现，目前最新已经更新到130道题1、Which threearetrue aboutundosegmentsand undo tablespacesinthe same database and instance?A.Multipletransactionsrun bythesame Oracle user cansharea singleundo s

2、egment.B.Multipletransactionsrun bydifferentOracle userscansharea singleundo segment.C.Aserial transactioncanuse multipleundosegments.D.Undosegments areautomaticallydroppedshortly aftertransactionsthat use themcommit.E. Anewundo segmentisalwayscreatedforeachtransaction.F.Adatabasecanhavemultipleundo

3、tablespaces.CorrectAnswer: ABF2、Which twoaretrueaboutthe DataRecovery Advisor?A.Itcanbe used only fordatabasesthat arerunning inARCHIVELOGmode.B.It canbe used when the database is closed.C.Itcanbe used tovalidatedatabaserecoverystrategies.D.It providesintelligent databaseproblemanalysis.E. Itcanbe u

4、sed tovalidatedatabasebackupstrategies.F.Itcanbe used only fordatabaseswithFLASHBACKenabled.CorrectAnswer: CD3、Which twoaretrueaboutOracleData Pump inOracle Database11gRelease2?A.Ifthedirectory usedinthe export operationhasexistingdump files, itoverwritesthem.B.It allowsencryptiontobe performedwitho

5、utusingapassword.C.Itsupportsthe renamingof tablesduring import.D.Itsupportstheexportofspecific viewsas tables.E. It allowscompressionlevelstobe definedforthe export.CorrectAnswer: BE4、For yourORCLdatabase.1. Theinstanceis startedusing an spfile.2. Thedatabaseis opened.3. It isinARCHIVELOGmode.4. CO

6、NTROLFILE AUTOBACKUPIS ON.Examinethiscommand:RMANbackupascopydatafileusers01.dbf,example01.dbf; Whichfour filesarebacked up?A.spfileB.undo01.dbf C.users01.dbf D.archivelogsE.sysaux01.dbf F.control fileG.system01.dbfH.example01.dbf CorrectAnswer:ACFH5、When doesanincrementalcheckpointoccur?A.whenDBWnw

7、ritesdirtybuffersas partof itsnormalprocessB.when thealtersystemcheckpoint statement isexecuted.C.when a usertablespaceis takenofflineD.when an online redolog switchoccursCorrectAnswer: A6、Examine thisquery and itsoutput:Whichtwo aretrue?A.Theblocked sessioniswaitingon a sharedtable lock.B.Theblocke

8、d session is waitingon anenqueue.C.Theblockingsession is waitingon a row-levellock.D.Session 105 is blocked bysession 15.E. Session 105 isblockingsession15. CorrectAnswer: BD7、Inoneofyourdatabases:1. USER1andUSER2havenosystemprivileges.2. ROLE1onlyhas theseprivileges:*createsession*createtable *crea

9、teviewExaminethesecommands:7Whichcommandwouldyouexecuteandaswhichuser,torevokethe createtableprivilegefromUSER2?A. Revokecreatetablefromuser2as user1B.Revokecreatetablefromuser1as sysC.Revokecreatetablefromrole1as user1D.Revokecreatetablefromrole1as sysE.Revokecreatetablefromuser2as sysCorrectAnswer

10、:D如果用user1回收角色的权限，会报错：SQLrevokecreatesessionfromrole1;revokecreatesessionfromrole1*ERROR atline1:ORA-01031:insufficientprivileges8、Whichtwoaretrueaboutserver-generatedalerts?A.Statefulalerts must always be clearedmanually.B.Theyarevisiblein OracleEnterprise Managerbydefault.C.Allstatefulalertscanbe

11、foundin DBA_ALERT_HISTORY.D.Theycanbe based onlyon database metrics.E. Statelessalertscannotbe foundinDBA_OUTSTANDING_ALERTS.F.Theycanbe basedonlyon instancemetrics.CorrectAnswer: BE9、Yourdatabase instanceis inNOMOUNTstate.Yourselectthedeleteoptioninthedatabaseconfigurationassistant(DBCA)foryourdata

12、base.Whatisthe outcome?A.DBCAis able todelete the data files butnot the services.B.DBCAshutsdowntheinstance and deletesthe database.C.DBCAis abletodelete the servicesbutnot the datafiles.D.DBCAprompts youtoopenthe database,and then proceedswiththe deletion.CorrectAnswer: D10、Whichis truewhen adataba

13、se instance isshutdown?A.IMMEIATE,TRANSACTIONAL,and NORMAL modeswait foralluncommitted transactionseithertocommitor rollbackandthen closethe databaseB. IMMEIATE,TRANSACTIONAL,and NORMALmodes allresultin acheckpointC.Only TRANSACTIONAL,and NORMAL modeswait foralluncommittedtransactionstocommitorrollb

14、ack and thenclosethe databaseD.Neitherthe IMMEDIATEnorthe ABORTmode rollsbackuncommittedtransactions.CorrectAnswer: B11、TheORCLdatabase hasCONTROL FILEAUTOBACKUPand BACKUP OPTIMIZATION enabled.USER1.EMPisa tableintablespaceTBS1.Thereareno existingbackupsofthe database.Examinethese commands:Whatisthe

15、outcome?A.It takesa level0 incrementalbackupof ORCLwithTBS1.B.It takesa level1 incrementalbackupof ORCLwithoutTBS1.C. Ittakesa level0incrementalbackupof ORCLwithoutTBS1.D.Ittakesa level1incrementalbackupof ORCLwithTBS1.CorrectAnswer:C12、Whichtwostatementsaretrueaboutdispatchersused by the Oracleshar

16、edserver?A.Multipleuser processescanconnect toasingledispatcher. B.Theyreturncompleted requeststothe appropriate userprocesses.C.Adispatcher is createdforeachuser process.D.Multipledispatchers can connect toa singleserver process. E. Theypull requestsfromthe requestsqueue andprocessthemuntilthey are

17、complete.CorrectAnswer: AB13、Examine thissessionoutput:Whichtwowillgenerateanauditrecord?A.every DDLstatementexecutedbySCOTTthataffectsSCOTT.EMPB.every UPDATEstatementexecutedbySCOTTthatupdatesSCOTT.EMPC. onlythe firstSELECTstatementexecutedbySCOTTis a sessiononSCOTT.EMPD.onlythe firstDMLstatementex

18、ecutedbySYSTEMina sessiononSCOTT.EMPE. everyUPDATEstatementexecutedbySCOTTthatupdatesHR.EMPF.anyDMLstatementexecutedbySYS onSCOTT.EMPCorrectAnswer:AB14、Inwhichtwocasesis a consistent database backupcreated?A.whenthe RMANBACKUPcommandis used whilethedatabase is OPEN READONLYB.when theRMANBACKUP ASCOP

19、Ycommandis used whilethe database is OPENRESTRICTEDC.when the RMANBACKUP AS COPYcommandis used whilethe database is OPEND.when O/S commandsareusedtocopydatabase files after adatabase instance isshutdownnormallyE. when theRMANBACKUPcommandis used whilethedatabase is mountedCorrectAnswer: AD只读表空间下用rma

20、n备份时没有发生检查点，无需更改数据文件头部，所以可以备份数据库。15、WhichtwoaretrueaboutUNDO data?A.Inactive UNDO is neverwrittentodisk.B.Active UNDOisalwayskeptin memoryC.Only DML statements generateUNDO. D.Active UNDO canneverbeoverwritten.E. Itcanbe used torestoreatable byusingFLASHBACK TABLE. F.Inactive UNDO cannotbe overwritt

21、enuntilthe elapsed timesincebecominginactiveexceedsUNDO RETENTION.CorrectAnswer: DE16、You successfullyexecutedthese commands:Whichtypeofdatabase link iscreated?A. privatecurrentuser databaselink.B.public current user databaselinkC. privatefixed user databaselinkD.publicconnecteduserdatabaselinkE. publicfixeduserdatabaselink CorrectAnswer:CCreatedatabaselinkconnecttocurrent