OracleOCP認證考試練習真題OCP052

試卷科目：OracleOCP認證考試練習OracleOCP認證考試練習真題OCP052PAGE"pagenumber"pagenumber/SECTIONPAGES"numberofpages"numberofpagesOracleOCP認證考試練習真題OCP052第1部分：單項選擇題，共52題，每題只有一個正確答案,多選或少選均不得分。[單選題]1.USER1.EMPhasareferentialintegrityconstraintdefinedonEMP.DNOthatreferencesUSER1.DEPT.DNO.USER1executesthesecommands:SQL>UPDATEdeptSETloc='UK'wheredno=1;1rowupdated.SQL>UPDATEempSETsal=1000whereeno=100;1rowupdated.SQL>ALTERTABLEdeptDROP(dno)Whatwillbetheoutcomeandwhy?A)ItwillfailbecauseareferentialintegrityconstraintisdefinedonUSER1.EMP.B)ItwillexecutesuccessfullyanddropDEPNT.DNO.C)ItwillfailbecausethereisanuncommittedtransactiononUSER1.DEPT.D)ItwillexecutesuccessfullyanddroptheDEPT.DNOandEMP.DNOcolumns.E)ItwillfailbecausethereisanuncommittedtransactiononUSER1.EMP答案:A解析:[單選題]2.Examinethesecommandsandtheiroutput:SQL>SELECT*FROMempENOENAME--100Adam--101AlanSQL>INSERTINTOempVALUES(102,'Ben');1rowcreated.SQL>COMMIT;Commitcompleted.SQL>UPDATEempSETename='Bryan'WHEREeno=102;1rowupdated.Apowerfailureoccurs.Theinstanceisrestartedandthisqueryisexecuted.SQL>SELECTenameFROMemp;Whatistheoutcome?A)OnlyAdamandAlanaredisplayed.B)Norowsarereturned.C)OnlyAdam,Alan,andBryanaredisplayed.D)Adam,Alan,Ben,andBryanaredisplayed.E)OnlyAdam,Alan,andBenaredisplayed.答案:E解析:[單選題]3.WhichistrueaboutinvalidPL/SQLobjects?A)Theyareautomaticallyrecompiledagainstthenewdefinitionofareferencedobjectwhentheyarecalled.B)TheymustbemanuallyrecompiledbeforetheycanbeusedifaDDLisperformedonatablethatisreferencedinthePL/SQLobject.C)Theyareautomaticallyrecompiledagainstthenewdefinitionofareferencedobjectatthesametimeasthereferencedobjectismodified.D)TheycanbemanuallyrecompiledonlybyusingSQLcommands.答案:A解析:[單選題]4.Whichstructurecanspanmultipledatafiles?A)abigfiletablespaceB)apermanenttablespaceC)asegmentD)atemporarytablespaceE)anextent答案:C解析:[單選題]5.Whendoesanincrementalcheckpointoccur?A)whenanonlineredologswitchoccurs.B)whenDBWnwritesdirtybuffersaspartofitsnormalprocessing.C)whentheALTERSYSTEMCHECKPOINTstatementisexecuted.D)whenausertablespaceistabkenoffline.答案:B解析:[單選題]6.WhichstatemustadatabasebetoenableARCHIVELOG?A)NOMOUNTB)OPENINREADWRITEmodeC)OPENINREADONLYmodeD)OPENINRESTRICTEDmodeE)MOUNT答案:E解析:[單選題]7.Whereisanexpdpoperationtracked?A)dumpfilesB)controlfileC)logfilesD)AutomaticDiagnosticRepository(ADR.E)mastertable(MT)答案:E解析:[單選題]8.YouwanttoauditupdatestatementsthatrefertoUSER1.DEPT.DNAME.Whichtypeofauditingmustyouuse?A)standardauditingB)mandatoryauditingC)value-basedauditingD)fine-grainedauditing答案:D解析:[單選題]9.yousuccessfullyexecutedthesecommands:connectscott/tiger@prod1;CREAETDATABASELINKdb_prod2CONNECTTOscottIDENTIFIEDBYtigerUSING'PROD2';Whichtypeofdatabaselinkiscreated?A)privatecurrentuserdatabaselinkB)publicconnecteduserdatabaselinkC)publiccurrentuserdatabaselinkD)privatefixeduserdatabaselinkE)publicfixeduserdatabaselink答案:D解析:[單選題]10.whichistrueaboutexternaltables?A)Segmentsareallocatedforexternaltables.B)Theymayhaveindexes.C)Theydonotsupportpartitioning.D)TheORACLE_DATAPUMPaccessdrivercanbeusedtowritedatatoexternaltables.E)DMLoperationsmaybeperformedonexternaltables.答案:D解析:[單選題]11.WhichistrueabouttheAutomaticDiagnosticRepository(ADR)？A)ItisusedonlyiftheDIAGNOSTIC_DESTparameterismanuallyconfigured.B)Itonlycontainsthealertlogandtracefilesforbackgroundprocesses.C)ItslocationisalwayssetbytheORACLE_BASEvariable.D)Itincludesdiagnosticdataforcriticalerrorsforeachserverandbackgroundprocess.答案:D解析:[單選題]12.YourdatabaseisopeninARCHIVELOGmode.LOG_ARCHIVE_DESTissettoFastRecoveryArea(FRA)andItis100%fullwhenalogswitchtakesplace.Noalternativeoroptionalarchivedestinationsaredefined.Whatistheoutcome?A)Obsoletebackupsareautomaticallydeletedandnewarchivelogsaregenerated.B)Allactivesessionshanguntilthedatabaseadministrator(DBA)makesspaceavailableintheFRA.C)Thearchivelogentriesaremadeinthediagnosticdestinationandwhenspaceisavailable,newarchivelogsaregenerated.D)Allactivesessionsaredisconnectedandtheirtransactionsrolledback.E)Noarchivelogsaregenerated.答案:B解析:[單選題]13.YourDB_RECOVERY_FILE_DEST_SIZEIS8G,Currently，5Gofthespaceisusedofwhich4Gconsistsofobsoletebackups,Youexecutethiscommand;SQL>ALTERSYSTEMSETdb_recovery_file_dest_size=2G;Whatistheoutcome?A)ItchangesDB_RECOVERY_FILE_DEST_SIZEto2GanddeletestheobsoletebackupsB)ItchangesDB_RECOVERY_FILE_DEST_SIZEto5GC)ItfailsbecauseDB_RECOVERY_FILE_DEST_SIZEisastaticparameterD)ItchangesDB_RECOVERY_FILE_DEST_SIZEto2GwithoutdeletingvalidbackupsE)Itfailsbecausethenewsizeislessthan5G答案:D解析:[單選題]14.USER1grantsSELECT,INSERT,andUPDATEprivilegesonUSER1.EMPtoUSER2.Sysexecutesthiscommand:SQL>REVOKEUPDATEONuser1.empFROMuser1;Whatwillbetheoutcome?A)ItwillfailbecauseUSER1istheownerofUSER1.EMP.B)ItwillsucceedbutneitherUSER1norUSER2willbeabletoperformSELECT,INSERT,orUPDATEonUSER1.EMP.C)ItwillsucceedandonlyUSER1willbeunabletoperformSELECT,INSERT,orUPDATEonUSER1.EMP.D)ItwillsucceedandneitherUSER1norUSER2willbeabletoperformINSERTorUPDATEonUSER1.EMP,butbothwillbeabletoqueryUSER1.EMP.E)ItwillsucceedandonlyUSER2willbeunabletoperformSELECT,INSERT,orUPDATEonUSER1.EMP.答案:A解析:[單選題]15.USER1grantsSELECTandUPDATEprivilegesonUSER1.EMPtoUSER2SYSexecutesthiscommandSQL>REVOKESELECTONuser1.empFROMuser1;Whatwillbetheoutcome?A)ItwillsucceedandUSER2willbeunabletoperformSELECTonUSER1.EMPB)ItwillsucceedandUSER2willbeunabletoperformsELECTorUPDATEonUSER1EMPbecauseupdatesrequireselectbedoneinternallyC)ItwillfailbecausesyscannotrevokeobjectprivilegesforotherusersD)ItwillfailbecauseUSER1ownsUSER1.EMP答案:D解析:[單選題]16.Inoneofyourdatabases:1.USER1andUSER2havenosystemprivileges.2.ROLE1onlyhastheseprivileges:?CREATESESSION?CREATETABLE?CREATEVIEWExaminethesecommands:SQL>conn/assysdbaConnected.SQL>GRANTcreatetable,role1TOuser1WITHADMINOPTION;Grantsucceeded.SQL>connuser1/oracle_4UConnected.SQL>GRANTrole1TOuser2;Grantsucceeded.Whichcommandwouldyouexecuteandaswhichuser,torevokethecreatetableprivilegefromUSER2?A)REVOKECREATETABLEFROMuser2asSYSB)REVOECREATETABLEFROMrole1asSYSC)REVOKECREATETABLEFROMrole1asUSER1D)REVOKECREATETABLEFROMuser1asSYS答案:B解析:[單選題]17.Inoneofyourdatabases:1.USER1andUSER2havenosystemprivileges.2.ROLE1onlyhastheseprivileges:?CREATESESSION?CREATETABLE?CREATEVIEWExaminethesecommands:SQL>conn/assysdbaConnected.SQL>GRANTcreatetable,role1TOuser1WITHADMINOPTION;Grantsucceeded.SQL>connuser1/oracle_4UConnected.SQL>GRANTrole1TOuser2;Grantsucceeded.Whichcommandwouldyouexecuteandaswhichuser,torevokethecreatetableprivilegefromUSER2?A)REVOKECREATETABLEFROMuser2asUSER1B)REVOKECREATETABLEFROMuser1asSYSC)REVOKECREATETABLEFROMrole1asUSER1D)REVOKECREATETABLEFROMrole1asSYSE)REVOKECREATETABLEFROMuser2asSYS答案:D解析:[單選題]18.Inadatabase,EXAMPLEisthedefaulttablespaceandDEFERED_SEGMENT_CREATIONisFLASE.ExaminethesecommandsexecutedbySYS:SQL>CREATEUSERu1IDENTIFIEDBYoracle;SQL>CREATETABLEu1.tab1(c1number);Whatwillbetheoutcomeandwhy?A)ItwillfailbecauseU1doesnothavetheCREATESESSIONprivilege.B)ItwillfailbecauseU1hasnoquotaonEXAMPLE.C)U1.TAB1willbecreated.D)ItwillfailbecauseU1doesnothavetheCREATETABLEprivilege.E)ItwillfailbecauseU1hasnodefaulttablespace.答案:B解析:[單選題]19.whichistrueaboutinitializationparameteradministration?A)SomeDynamicparametervaluescanbemodifiedtoaffectonlyonesessionB)Dynamicparameters,whenmodified,alwaysreverttotheiroriginalvaluesafterthedatabaseinstanceisrestartedC)Staticparametervaluescanbechangedinthespfileonlybyusingthealtersystemcommandwithscope=spfilewhenthedatabaseisclosedD)Staticparametervaluescanbechangedforthecurrentinstancebyusingaltersystemcommandwithscope=memory答案:A解析:[單選題]20.YouwanttousetheALTERSYSTEMstatementwithSCOPE=MEMORYtochangeaninitializationparametervalue.Whichistrue?A)Itcanbeusedonlyifapfileisused.B)Thechangeoccursimmediatelyinmemoryforstaticparametersbutitisnotpersistentafterinstancerestart.C)Thechangeoccursimmediateinmemoryfordynamicparametersbutitisnotpersistentafterinstancerestart.D)Incanbeusedonlyifanspfileisused.答案:C解析:[單選題]21.YourdatabaseisopeninARCHIVELOGmode.LOG_ARCHIVE_DESTissettoFastRecoveryArea(FRA.anditis100%fullwhenalogswitchtakesplace.Noalternativeoroptionalarchivedestinationsaredefined.Whatistheoutcome?A)Allactivesessionshanguntilthedatabaseadministrator(DBA.makesspaceavailableintheFRAB)Noarchivelogsaregenerated.C)Thearchivelogentriesaremadeinthediagnosticdestinationandwhenspaceisavailable,newarchivelogaregenerated.D)Allactivesessionsaredisconnectedandtheirtransactionsrolledback.E)Obsoletebackupsareautomaticallydeletedandnewarchivelogsaregenerated.答案:A解析:[單選題]22.Whichcommandisusedtodisplayfilesthatnolongerconformtothebackupretentionpolicy?A)LISTEXPIREDBACKUPB)REPORTOBSOLETE.C)SHOWDATAFILEBACKUPCOPIES.D)CROSSCHECKBACKUP.答案:B解析:[單選題]23.Yourdatabaseisconfiguredinarchivelogmode.TheUSERS01tablespaceiscurrentlyonline.Youarerequiredtotakethetablespaceoffline.Whichclauseorclausesensurethatnomediarecoveryisrequiredwhenthetablespaceisbroughtbackonline?A)eithertheNORMALortheTEMPORARYclauseB)onlytheTEMPORARYclauseC)onlytheNORMALclauseD)eithertheNORMALortheIMMEDIATEclauseE)onlytheIMMEDIATEclause.答案:C解析:[單選題]24.WhichistrueaboutenablingAUTOEXTENDfordatafiles?A)Itcanbeenabledforanewdatafilethatisaddedtoatablespaceonlyiftheexistingdatafilesinthattablesapcehaveautoextendenabled.B)Itcanbeenabledonlyfordatafilesinnon-OMFtablespaces.C)Itcanbeenabledfordatafilesonlyinbigfiletablespaces.D)Itcanbeenabledfordatafilesonlyinsmallfiletablespaces.E)ItcanbeenabledforanexistingdatafileinatablespacebyusingtheALTERTABLESPACEcommand.答案:E解析:[單選題]25.WhichistrueabouttheSYSTEMandSYSAUXtablespaces？A)Bothtablespacesmustbeonlineforadatabasetobeaccessible.B)TheSYSAUXtablespacecanbemaderead-onlybuttheSYSTEMtablespacecannot.C)OnlytheSYSTEMtablespacecontainsdatadictionarytables.D)Bothtablespacescanbeusedfortemporarystorageifnotemporarytablespaceisdefined.答案:C解析:[單選題]26.Examinethesefactsaboutadatabase.1.ThedatabasedefaulttabpespaceisUSERS.2.DEFERRED_SEGMENT_CREATIONisTRUE.3.ThedefaulttablespaceofUSER1istbs1.4.USER1hasonlytheseprivileges:?CREATESESSION?CREATETABLE?UNLIMITEDquotaontbs1ExaminethesecommandsexecutedbyUSER1:SQL>CREATETABLEemp(enoNUMBER,enameVARCHAR2(20..TABLESPACETBS1;Tablecreated.SQL>CREATEINDEXemp_inxONemp(eno.TABLESPACEUSERS;Indexcreated.SQL>INSERTINTOempVALUES(NULL,?Alan?.;WhatwillbetheoutcomeoftheINSERToperationandwhy?A)ItwillfailbecauseanindexedcolumncannothaveNULLvalues.B)ArowwillbeinsertedintoEMPandanindexentrywillbemadeintoEMP_IDX.C)ItwillfailbecauseUSER1hasnoquotaonUSERS.D)ArowwillbeinsertedintoEMPandanindexentrywillbeinsertedintoavirtualcolumnofEMPbecauseUSER1hasnoquotaanUSERS.E)ArowwillbeinsertedintoEMPbutnoindexentrywillbemadeintoEXP_IDX.答案:C解析:[單選題]27.YouareinstallingOracleGridInfrastructurebyusingtheOracleUniversalInstaller(OUI..Youselectthe?InstallandConfigureGridInfrastructureforaStandaloneServer?option.WhichtaskisperformedbyOUIaspartofthisinstallation?A)creationandconfigurationofEnterpriseManagerCloudControlontheserver.B)creationofageneralpurposedatabase.C)creationofanASMdiskgroupandregistrationofASMcomponentswithOracleRestart.D)creationofprivilegedoperatingsystemgroupsthatareusedforOSauthentication.答案:C解析:[單選題]28.WhichtaskwouldyouperformbeforerunningtheOracleUniversalInstaller(OUI.insilentorsuppressedmode?A)Installthedbhomescript.B)Installthecoraenvscript.C)CreatetheoraInst.locfile.D)Createthetnsnames.orafile.E)Createtheoratabfile.F)Installtheoraenvscript.答案:C解析:[單選題]29.YourdatabaseinstanceisinNOMOUNTstate.YouselectthedeleteoptionintheDatabaseConfigurationAssistant(DBCA.foryourdatabase.Whatistheoutcome?A)DBCAisabletodeletetheservicesbutnotthedatafiles.B)DBCApromptsyoutoopenthedatabase,andthenproceedswiththedeletion.C)DBCAisabletodeletedatafilesbutnottheservices.D)DBCAshutsdowntheinstanceanddeletesthedatabase.答案:D解析:[單選題]30.WhichistrueabouttheDatabaseConfigurationAssistant(DBCA.?A)ItcanuseOracleASMforstoringdatabasefilesonlyifOracleManagedFiles(OMF.isconfigured.B)Itcanchangetheservermodefromdedicatedtosharedandviceversaforanexistingdatabase.C)Itcancreatenewdatabasetemplatesonlyfromexistingtemplatesordatabase.D)ItcanregisteradatabasewithCloudControlandconfigureDatabaseControlforthesamedatabase.答案:B解析:[單選題]31.Forwhichrequirementshouldyouconfiguresharedservers?A)accommodatinganincreasingnumberofuserswhorunshort-duration,infrequentqueriesinanOLTPenvironmentwithlimitedmemory.B)usingRecoveryManager(RMAN.torecoveradatabase.C)submittingbackupjobsatregular,24-hourintervalsinanOLTPenvironmentwithlimitedmemory.D)accommodatinganincreasingnumberofuserswhorunanalyticalqueriesinaDSSenvironmentwithlimitedmemory.E)performingbulk-loadoperationsinaDSSenvironmentwithlimitedmemory.答案:A解析:[單選題]32.Whenwouldyouusememoryadvisors?A)todeterminetheimpactofaddingmemoryonlogicalandphysicalreads.B)todeterminetheimpactofaddingmemoryonhardparsecount.C)todeterminetheimpactofaddingorreducingmemoryonDBTime.D)togeneratememory-relatedalertswhenmemorydemandexceedsaspecifiedpercentage.E)togetarecommendationwhetherAutomaticMemoryManagement(AMM.orAutomaticSharedMemoryManagement(ASMM.shouldbeimplemented.答案:C解析:[單選題]33.Whichistrueaboutmemoryadvisors?A)IfautomaticmemoryManagementisenabled,nomemoryadvisorsareavailable.B)IfautomaticmemoryManagementisenabled,theSharedPoolAdvisorandBufferCacheAdvisorareavailabletosetthemaximumsizefortheseindividualSGAcomponents.C)IfManualSharedMemoryManagementisenabled,onlytheSharedPoolAdvisorandBufferCacheAdvisorareavailable.D)IfAutomaticsharedMemoryManagementisenabled,boththeSGAAdvisorandPGAareavailable.答案:D解析:[單選題]34.Inyourdatabase:SGA_TARGET=270MPGA_AGGREGATE_TARGET=90MTheMEMORY_TARGETandMEMORY_MAX_TARGETparametersarecurrentlynotconfigured.Youexecutethecommand:ALTERSYSTEMSETMEMORY_TARGET=400M;Whatistheoutcomeandwhy?A)TheexecutionfailsbecausetheMEMORY_MAX_TARGETparametermustbeconfiguredto400MbeforeconfiguringtheMEMORY_TARGETparameter.B)TheexecutionfailsbecauseSGA_TARGETandPGA_AGGREGATE_TARGETarealreadyconfigured.C)Theexecutionissuccessfulandautomaticmemorymanagementisenabled.D)TheexecutionissuccessfulbutdoesnotenableautomaticmemorymanagementbecausetheMEMORY_MAX_TARGETparemetermustbeconfiguredtoavaluegreaterthanMEMORY_TARGET.答案:C解析:[單選題]35.ExaminethesedescriptionsofOraclemetadataanddata:1.MetadataaboutschemaobjectsbeingqueriedbySQLstatments2.PrivateCursormetadataonly3.ResultsofSQLqueriesandPL/SQLfunctions4.SharedCursorandPrivateCursorData5.TheCallStackWhichofthesearealwaysstoredinthePGA?A)1and2B)1and2C)4and5D)2and5E)1and5答案:D解析:[單選題]36.Whichistrueaboutunusableindexes?A)Rebuildinganunusableindexalwaysrequiresatleasttwicethespaceoftheoriginalindex.B)Rebuildinganunusableindexcreatesanewsegmentafterdroppingtheunusableindex.C)RebuildinganunusableindexalwaysallowsDMLstatementsontheindex'stableduringtherebuild.D)Rebuildingoccursautomaticallywhenanunusableindexischosenbytheoptimizerwhencreatinganexecutionplan.答案:B解析:[單選題]37.43.whichistruewhenadatabaseinstanceisshutdown?A)IMMEDIATE,TRANSACTIONAL,andNORMALmodesallresultinacheckpoint.B)NeithertheIMMEDIATEnortheABORTmoderollsbackuncommittedtracsctions.C)OnlyTRANSACTIONALandNORMALmodeswaitforalluncommittedtransactionstoCOMMITorROLLBACKandthenclosethedatabaseD)IMMEDIATE,TRANSACTOINAL,andNORMALmodeswaitforalluncommittedtranscatoinseitherCOMMITorROLLBACKandthenclosethedatabase答案:A解析:[單選題]38.TheORCLdatabasehasCONTROLFILEAUTOBACKUPandBACKUPOPTIMIZATIONenabled.TBS1andTBS2aretheonlyuser-definedtablespacesinORCL.USER1.EMPisableinTBS1.Examinethesecommands:$rmantarget/RMAN>BACKUPINCREMENTALLEVEL0DATABASE;RMAN>exit$sqlplus/assysdbaSQL>UPDATEuser1.empSETsal=10000WHEREeno=1;1rowupdatedSQL>COMMIT;Commitcomplete.SQL>ALTERTABLESPACEtbs1READONLY;Tablespacealtered.SQL>exit$rmantarget/RMAN>BACKUPINCREMENTALLEVEL1DATABASE;Fromwhichfilesaremodifiedblocksbackedup?A)SYSTEMandSYSAUXonlyB)SYSTEM,SYSAUX,UNDO,TEMP,TBS1,andTBS2C)SYSTEM,SYSAUX,andUNDOonlyD)SYSTEM,SYSAUX,UNDO,andTBS1onlyE)SYSTEM,SYSAUX,UNDO,andTBS2only答案:D解析:[單選題]39.TheORCLdatabasehasthisconfiguration：1.CONTROLFILEAUTOBACKUPandBACKUPOPTIMIZATIONenabled.2.TBS1andTBS2aretheonlyadministratordefinedtablespaces.3.TBS1containstableUSER1.EMP.Examinethesecommands:$rmantarget/RMAN>BACKUPINCREMENTALLEVEL0DATABASE;RMAN>exit$sqlplus/assysdbaSQL>UPDATEuser1.empSETsal=10000WHEREeno=l;1rowupdatedSQL>COMMIT;Commitcomplete.SQL>ALTERTABLESPACEtbslREADONLY;Tablespacealtered.SQL>exit$rmantarget/RMAN>BACKUPINCREMENTALLEVEL1DATABASE；Fromwhichfilesaremodifiedblocksbackedupbythelevel0backup?A)SYSTEMandSYSAUXonlyB)SYSTEM,SYSAUX,UNDO,TEMP,TBS1,andTBS2C)SYSTEM,SYSAUX,UNDO,andTBS2onlyD)SYSTEM,SYSAUX,andUNDOonlyE)SYSTEM,SYSAUX,UNDO,andTBS1only答案:B解析:[單選題]40.inwhichstatecanyoubackupadatabaseinARCHIVELOGMODEusingRMAN?A)MOUNTandOPENonlyB)NOMOUNTandMOUNTonlyC)NOMOUNT,MOUNT,andOPEND)OPENRESTRICTEDonlyE)OPENonly答案:A解析:[單選題]41.WhereisbackupmetadatastoredforusebyRecoveryManager(RMAN.?A)intheSYSAUXtablespaceB)inthediagnosticdestinationfilesC)inthecontrolfileD)intheSYSTEMtablespaceE)intheSPFILE答案:C解析:[單選題]42.Examinethesecomponents:1.Executionplanforanon-embeddedSQLstatement2.Local,global,andpackagevariablesforasession.3.ExecutionplanforaSQLstatementcontainedinaPL/SQLprogramunit.4.Resultsofexecutedqueriesandqueryfragments.5.PL/SQLfunctionresultsets.WhichofthesearestoredinthesharedSQLarea?A)1and3B)1,3,4,and5C)1and4D)1,2,and3答案:A解析:[單選題]43.TheORCLdatabasehasCONTROLFILEAUTOBACKUPandBACKUPOPTIMIZATIONenabled.USER1.EMPisatableintablespaceTBS1.TherearenoexistingbackupsofthedatabaseExaminethesecommands:$rmantarget/RMAN>BACKUPDATABASE;RMAN>exit;$sqlplus/assysdbaSQL>UPDATEUSER1.EMPsetSAL=5000WHEREeno=10;1rowupdatedSQL>COMMIT;Commitcomplete.SQL>exit;$rmantarget/RMAN>CONFIGUREEXCLUDEFORTABLESPACEtbs1;RMAN>BACKUPINCREMENTALLEVEL1DATABASE;Whatistheoutcome?A)Ittakesalevel1incrementalbackupofORCLwithoutTBS1.B)Ittakesalevel0incrementalbackupofORCLwithoutTBS1.C)Ittakesalevel1incrementalbackupofORCLwithTBS1.D)Ittakesalevel0incrementalbackupofORCLwithTBS1.答案:B解析:[單選題]44.AdatabaseinstancewasterminatedduetothelossoftheCURRENTonlineredologgroupandhasnotbeenrestarted.YouwishtorestoredatabaseavailabilitybyusingtheDataRecoveryAdvisor.ExaminethislistofRMANcommands;1.Startup2.Listfailureall;3.Advisefailureall;4.Repairfailurenoprompt;5.Alterdatabaseopen;Whataretheminimumcommandsrequiredandinwhatordermusttheybeexecutedtoachievethis?A)1,2,3,and4B)1,3,and4C)1and4D)1,3,4,and5E)1,2,3,4,and5答案:B解析:[單選題]45.AdatabaseinstancewasterminatedduetothelossoftheCURRENTonlineredologgroupandhasnotbeenrestarted.ThedatabaseisconfiguredwithFLASHBACKmodeonYouwishtorestoredatabaseavailabilitybyusingtheDataRecoveryAdvisor.ExaminethislistofRMANcommands;1.Startup2.Listfailureall;3.Advisefailureall;4.Repairfailurenoprompt;5.Alterdatabaseopen;Whataretheminimumcommandsrequiredandinwhatordermusttheybeexecutedtoachievethis?A)1,2,3,and4B)1,3,and4C)1and4D)1,3,4,and5E)1,2,3,4,and5答案:B解析:[單選題]46.AdatabaseinstancewasterminatedduotoalostdatafileandhasnotbeenrestartedYouwishtorestoreatabaseavailabilitybyusingtheDataRecoveryAdvisorExaminethislistofRMANcommands;1.Startup2.Listfailureall;3.Advisefailureall;4.Repairfailurenoprompt;5.Alterdatabaseopen;Whicharetheminimumrequiredcommandsandinwhatordermusttheybeexecutedtoarchive?A)1,3,4and5B)1and4C)1,3and4D)1,2,3,4and5E)1,2,3,and4答案:C解析:[單選題]47.WhichactionisautomaticallyperformedaspartoftheIncidentPackagingServiceinEnterpriseManagerSupportWorkbench?A)gatheringmetadatafromtheAutomaticDiagnosticRepository(ADR.B)invokingtheDataRecoveryAdvisorandSQLRepairAdvisorC)creatingaservicerequestwithMyOracleSupportD)invokingtheSQLTestCaseBuilder答案:A解析:[單選題]48.Whichistrueaboutlogicalandphysicaldatabasestructures?A)AnextentalwaysconsistsofphysicallycontiguousdatablocksinstorageB)AnundotablespacehasatempfileinsteadofadatafileC)ApermanenttablespacecanonlycontaintablessegmentsandindexsegmentsD)Atablespacecanconsistofdatablocksofdifferentsizes.E)Asegmentcanconsistofextentsofdifferentsizes.答案:E解析:[單選題]49.Yourdatabaseinstanceisintheopenstatewithuncommittedtransactions.Youplantoexecutethesecommands:SHUTDOWNABORTSTARTUPWhichistrueabouttheSTARTUPcommandassumingthatnoerrorsoccur?A)Itopensthedatabaseinread-onlymode.B)Itopensthedatabaseinread/writemodeonlyifanspfileisused.C)Itperformsaninstancerecoveryandleavesthedatabaseinstanceinmountstate.D)Itperformsaninstancerecoverybeforeopeningthedatabaseinread/writemode.答案:D解析:[單選題]50.ExaminethisLISTENER.ORAlife:LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP.(HOST=.(PORT=1522SID_LIST_LISTENER=(SID_DESC=(SID_DESC=(GLOBAL_DBNAME=.(GLOBAL_HOME=/u01/app/oracle/product/11.2.0/dbhome_1.SID_NAME=orclHowshouldyouconfigureanadditionallistenerLISTENER2thatlistensforthesameSID?A)AddrelevantdetailsinSID_LIST_LISTENERundertheexistingLISTENERinLISTENER.ORAB)CreateanotherconfigurationfilecalledLISTENER2.ORAwithonlyLISTENER2detailsinitC)AddLISENER2anditsSID_LISTdetailsseparatelyunderthenameLISTENER2inLISTENER.ORAD)AddrelevantdetailsinDESCRIPTIONundertheexistingLISTENERwithadifferentportnumberinLISTENER.ORA.答案:C解析:[單選題]51.ExaminethisLISTENER.ORAfile.LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS_LIST(ADDRESS=(PROTOCOL=TCP.(HOST=.(PORT=1522SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=.(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1.(SID_NAME=orcl...WhichmethodcanbeusedtoconfigureanadditionallistenerLISTENER2thatlistensforthesameservicename?A)AddrelevantdetailsinDESCRIPTIONundertheexistingLISTENERwithadifferentportnumberinLISTENER.ORA.B)CreateanotherfilecalledLISTENER2.ORAwithonlyLISTENER2detailsusingadifferentportnumberthanLISTENERC)CreateanotherfilecalledLISTENER2.ORAwithonlyLISTENER2detaillsusingthesameportnumberusedbyLISTENERD)AddLISTENER2anditsSID_LISTdetailswiththesameportnumberasLISTENERunderthenameLISTENER2inLISTENER.ORA.E)AddLISTENER2anditsSID_LISTdetailswithadifferentportnumberthenLISTENERunderthenameLISTENER2inLISTENER.ORA答案:E解析:[單選題]52.USER1.EMPhasareferentialintegrityconstraintonEMP.DNOreferencingUSER1.DEPT.DNO.USER1hasascriptcontainingthesecommandsUPDATEdeptSETloc='UK'wheredno=1;UPDATEempSETsal=1000whereeno=100;ALTERTABLEEMPshrink;Whatwillbetheoutcomeofrunningthescriptandwhy?A)ItwillfailbecausethereisanuncommittedtransactiononUSER1.DEPT.B)ItwillfailbecauseareferentialintegrityconstraintisdefinedonUSER1.EMP.C)Itwillexecutesuccessfully.D)ItwillfailbecausethereisanuncommittedtransactiononUSER1.EMP.答案:C解析:第2部分：多項選擇題，共114題，每題至少兩個正確答案,多選或少選均不得分。[多選題]53.EachrowintheTRANS_SUMMARYtablecontainsdetailsofoneproduct.EachrowintheTRANS_MONTHLYtablecontainstransactiondetailseitherfornewproductsorforupdatestoexistingproducts.Thereisamonthlyrequirementto:1.InsertTRANS_MONTHLYrowsfornewproductstotheTRANS_SUMMARYtable2.UpdatetheTRANS_SUMMARYtablewhenaTRANS_MONTHLYrowreferstoanexistingproduct.Whichtwocanbeusedtodothis?A)INSERTINTO..SELECTFROM..B)acalledprocedure.C)anOracleloadertypeexternaltable.D)theMERGEcommand.E)CREATETABLEASSELECT(CTAS)答案:BD解析:第3部分：問答題，共8題，請在空白處填寫正確答案。[問答題]54.Whichfourstatementsaretrueabouttruncatingatable?A)Anyinserttriggersforthetablewillbeexecuted.B)Anyofthetable?sindexesarealsotruncated.C)Anydeletetriggersforthetablewillbeexecuted.D)Alltablestoragecanberetained.E)OnlyHEAPtablesmaybetruncated.F)Alltablestorageisconvertedtofreespace.G)MINEXTENTSamountofstorageforthetablecanberetained.答案:BDFG解析:[多選題]55.ExaminetheseattributesfortheprofileassignedtoUSER1whosepasswordisoracle_4U.?PASSWORD_REUSE_MAXis5.?PASSWORD_REUSE_TIMEis10.?PASSWORD_GRACE_TIMEis15.WhichtwoconditionsmustbemetforUSER1toreuseoracle_4U?A)Atleast5daysmusthavepassedsinceoracle_4Uwaslastused.B)Thepasswordmusthavechanged5timessinceoracle_4Uwaslastused.C)Atleast10daysmust