052-题库解析-5-20180608

052题库解析最新16道题题库新特点：更加灵活，题库的顺序与考试时的顺序每场都在变化更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案不断有新的考题出现，目前最新已经更新到130道题1、Whichthreearetrueaboutundosegmentsandundotablespacesinthesamedatabaseandinstance?•A.MultipletransactionsrunbythesameOracleusercanshareasingleundosegment.•B.MultipletransactionsrunbydifferentOracleuserscanshareasingleundosegment.•C.Aserialtransactioncanusemultipleundosegments.•D.Undosegmentsareautomaticallydroppedshortlyaftertransactionsthatusethemcommit.•E.Anewundosegmentisalwayscreatedforeachtransaction.•F.Adatabasecanhavemultipleundotablespaces.•CorrectAnswer:ABF2、WhichtwoaretrueabouttheDataRecoveryAdvisor?•A.ItcanbeusedonlyfordatabasesthatarerunninginARCHIVELOGmode.•B.Itcanbeusedwhenthedatabaseisclosed.•C.Itcanbeusedtovalidatedatabaserecoverystrategies.•D.Itprovidesintelligentdatabaseproblemanalysis.•E.Itcanbeusedtovalidatedatabasebackupstrategies.•F.ItcanbeusedonlyfordatabaseswithFLASHBACKenabled.•CorrectAnswer:CD3、WhichtwoaretrueaboutOracleDataPumpinOracleDatabase11gRelease2?•A.Ifthedirectoryusedintheexportoperationhasexistingdumpfiles,itoverwritesthem.•B.Itallowsencryptiontobeperformedwithoutusingapassword.•C.Itsupportstherenamingoftablesduringimport.•D.Itsupportstheexportofspecificviewsastables.•E.Itallowscompressionlevelstobedefinedfortheexport.•CorrectAnswer:BE4、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.dbfCorrectAnswer:ACFH5、Whendoesanincrementalcheckpointoccur?•A.whenDBWnwritesdirtybuffersaspartofitsnormalprocess•B.whenthealtersystemcheckpointstatementisexecuted.•C.whenausertablespaceistakenoffline•D.whenanonlineredologswitchoccurs•CorrectAnswer:A6、Examinethisqueryanditsoutput:Whichtwoaretrue?•A.Theblockedsessioniswaitingonasharedtablelock.•B.Theblockedsessioniswaitingonanenqueue.•C.Theblockingsessioniswaitingonarow-levellock.•D.Session105isblockedbysession15.•E.Session105isblockingsession15.•CorrectAnswer:BD•7、Inoneofyourdatabases:1.USER1andUSER2havenosystemprivileges.2.ROLE1onlyhastheseprivileges:*createsession*createtable*createviewExaminethesecommands:7Whichcommandwouldyouexecuteandaswhichuser,torevokethecreatetableprivilegefromUSER2?•A.Revokecreatetablefromuser2asuser1•B.Revokecreatetablefromuser1assys•C.Revokecreatetablefromrole1asuser1•D.Revokecreatetablefromrole1assys•E.Revokecreatetablefromuser2assys•CorrectAnswer:D如果用user1回收角色的权限，会报错：SQLrevokecreatesessionfromrole1;revokecreatesessionfromrole1*ERRORatline1:ORA-01031:insufficientprivileges8、Whichtwoaretrueaboutserver-generatedalerts?•A.Statefulalertsmustalwaysbeclearedmanually.•B.TheyarevisibleinOracleEnterpriseManagerbydefault.•C.AllstatefulalertscanbefoundinDBA_ALERT_HISTORY.•D.Theycanbebasedonlyondatabasemetrics.•E.StatelessalertscannotbefoundinDBA_OUTSTANDING_ALERTS.•F.Theycanbebasedonlyoninstancemetrics.•CorrectAnswer:BE9、YourdatabaseinstanceisinNOMOUNTstate.Yourselectthedeleteoptioninthedatabaseconfigurationassistant(DBCA)foryourdatabase.Whatistheoutcome?•A.DBCAisabletodeletethedatafilesbutnottheservices.•B.DBCAshutsdowntheinstanceanddeletesthedatabase.•C.DBCAisabletodeletetheservicesbutnotthedatafiles.•D.DBCApromptsyoutoopenthedatabase,andthenproceedswiththedeletion.CorrectAnswer:D10、Whichistruewhenadatabaseinstanceisshutdown?•A.IMMEIATE,TRANSACTIONAL,andNORMALmodeswaitforalluncommittedtransactionseithertocommitorrollbackandthenclosethedatabase•B.IMMEIATE,TRANSACTIONAL,andNORMALmodesallresultinacheckpoint•C.OnlyTRANSACTIONAL,andNORMALmodeswaitforalluncommittedtransactionstocommitorrollbackandthenclosethedatabase•D.NeithertheIMMEDIATEnortheABORTmoderollsbackuncommittedtransactions.CorrectAnswer:B11、TheORCLdatabasehasCONTROLFILEAUTOBACKUPandBACKUPOPTIMIZATIONenabled.USER1.EMPisatableintablespaceTBS1.Therearenoexistingbackupsofthedatabase.Examinethesecommands:•Whatistheoutcome?•A.Ittakesalevel0incrementalbackupofORCLwithTBS1.•B.Ittakesalevel1incrementalbackupofORCLwithoutTBS1.•C.Ittakesalevel0incrementalbackupofORCLwithoutTBS1.•D.Ittakesalevel1incrementalbackupofORCLwithTBS1.•CorrectAnswer:C12、WhichtwostatementsaretrueaboutdispatchersusedbytheOraclesharedserver?•A.Multipleuserprocessescanconnecttoasingledispatcher.•B.Theyreturncompletedrequeststotheappropriateuserprocesses.•C.Adispatcheriscreatedforeachuserprocess.•D.Multipledispatcherscanconnecttoasingleserverprocess.•E.Theypullrequestsfromtherequestsqueueandprocessthemuntiltheyarecomplete.•CorrectAnswer:AB13、Examinethissessionoutput:Whichtwowillgenerateanauditrecord?•A.everyDDLstatementexecutedbySCOTTthataffectsSCOTT.EMP•B.everyUPDATEstatementexecutedbySCOTTthatupdatesSCOTT.EMP•C.onlythefirstSELECTstatementexecutedbySCOTTisasessiononSCOTT.EMP•D.onlythefirstDMLstatementexecutedbySYSTEMinasessiononSCOTT.EMP•E.everyUPDATEstatementexecutedbySCOTTthatupdatesHR.EMP•F.anyDMLstatementexecutedbySYSonS