单项选择题
单项选择题 Youhaveausecaseinyourwebapplicationthataddsseveralsession-scopedattributes.Attheendoftheusecase，oneoftheseobjects，themanagerattribute，isremovedandthenitneedstodecidewhichoftheothersession-scopedattributestoremove.Howcanthisgoalbeaccomplished？（）A.TheobjectofthemanagerattributeshouldimplementtheHttpSessionBindingListeneranditshouldcall theremoveAttributemethodontheappropriatesessionattributes.B.TheobjectofthemanagerattributeshouldimplementtheHttpSessionListeneranditshouldcallthe removeAttributemethodontheappropriatesessionattributes.C.TheobjectofthemanagerattributeshouldimplementtheHttpSessionBindingListeneranditshouldcall thedeleteAttributemethodontheappropriatesessionattributes.D.TheobjectofthemanagerattributeshouldimplementtheHttpSessionListeneranditshouldcallthe deleteAttributemethodontheappropriatesessionattributes.
单项选择题 Ashoot-outhaseruptedbetweenyourMSdevelopmentteamsusing.NETandyourLinuxdevelopmentteamsusingJava.Knowingthatyourdatabaseisindanger，whichcommandwouldyouusetobackupyourNOARCHIVELOGmodedatabaseusingRMANwithcompression？（）A.backupdatabaseallB.backupcompresseddatabaseC.backupascompressedbackupsetdatabaseD.backupascompressedbackupdatabaseplusarchivelogallE.backupascompressedbackupsetdatabasepluscompressarchivelogall
单项选择题 TheUNDO_RETENTIONparameterinyourdatabaseissetto1000andundoretentionisnotguaranteed.Whichstatementregardingretentionofundodataiscorrect？（）
单项选择题 InaJavaEEmessagingapplication,oneMDBisconsumingalotofmemoryathightraffic.Whatconfigurationshouldyouusetopreventpossibleout－of－memoryerrorathightrafficandatthesametimenotlosingmessages?（）
单项选择题 YouaremaintainingyourdatabaseinOracle10g.Whileperforminganincrementalbackupofthedatabase，youwanttobackuponlythoseblocksthathavechangedsincethelastbackup.Whichfilewillyoucreatetoincreasetheperformanceofthebackupoperationwhileperformingtheincrementalbackupofthedatabase？（）A.redologfilesB.passwordfileC.controlfileD.changetrackingfile
单项选择题 Atdatabasestartup，youdiscoverthatoneofthediskscontaininganindextablespacehasbeenlostduetoamediafailure.Abackupofthelostindextablespaceisnotavailable.Youhaveallthenecessaryscriptstorecreatetheindexes.Youneedtore-createtheindexesinanewindextablespace.Whichactionmustyouperformbeforere-creatingtheindexes？（）A.StartthedatabaseinOPENmode，andcreateanewindextablespace.B.StartthedatabaseinOPENmode，anddropthelostindextablespacefromthedatabase.C.StartthedatabaseinMOUNTmode，createanewindextablespace，anddropthelostindextablespacefromthedatabase.D.StartthedatabaseinMOUNTmode，dropthelostindextablespacefromthedatabase，openthedatabase，andcreateanewindextablespace.
单项选择题 YoucanbackuptheRMANrecoverycatalogwithRMAN.（）
单项选择题 Asnapshotofthe/export/projectfilesystemhasbeentaken.Priortobackingupthefilesystem，youneedtochecktoseeifcertainfilesareonthesnapshot.Thesnapshotneedstobemountedtocheckforthesefiles.Whichcommandwillmountthesnapshot？（）A.mount-Fufs-oro/dev/fssnap/0/checkB.mount-Fufs-orw/dev/fssnap/0/checkC.mount-Fufs-oro/export/project/checkD.mount-Fufs-orw/export/project/check
单项选择题 YouhaveconfiguredOMFinyourdatabase.YouenabledtheALTERDATABASEENABLEBLOCKCHANGETRACKING；statementtoenabletheblockchangetrackingfeature.Whatinformationwillbewritteninthechangetrackingfile？（）
单项选择题 Inwhichscenario，willyouissuethefollowingcommand？（）RMAN>REPORTNEEDBACKUPDAYS7；
单项选择题 WhichofthefollowingRMANstructurescandatafromadatafilespan？（）
单项选择题 WhichRMANbackupcommandisusedtocreatetheblock－changetrackingfile？（）
单项选择题 YoureceivedcomplaintsaboutthedegradationofSQLqueryperformance.YouidentifiedtopSQLqueriesthatconsumetime.WhatwouldbeyournextsteptofindoutrecommendationsaboutstatisticscollectionandrestructuringoftheSQLstatementtoimprovequeryperformance？（）A.runSegmentAdvisorB.runSQLTuningAdvisorontopSQLstatementsC.runtheAutomaticWorkloadRepository（AWR）reportD.runtheAutomaticDatabaseDiagnosticMonitor（ADDM）ontopSQLstatements
单项选择题 YouaremaintainingyourdatabaseinOracle10g.YouareperformingthebackupbyusingtheBACKUPASBACKUPSETcommandattheRMANprompt.WhichfilecannotbebackedupbyusingtheBACKUPASBACKUPSETcommand？（）
单项选择题 YouareinstallingOracleDatabase11gonamachine.Whenyouruntheinstaller，theOracleUniversalInstaller（OUI）showsthemessagethatsaysoneoftheproduct-specificprerequisitecheckshasfailed：Checkingavailableswapspacerequirements...Expectedresult：1512MBActualResult：1018MBCheckcomplete.Theoverallresultofthischeckis：Failed<<<<Problem：Thesystemdoesnothavetherequiredswapspace.Whathappenstotheinstallationinthissituation（）A.Itcanbecontinued.B.Itresizestheswapspaceautomaticallywhenyouproceedfurther.C.Itcanbecontinued，buttheinstancecannotbestartedwithoutincreasingtheswapspace.D.Itshowsamessagesayingoneormoreprerequisitecheckshavefailedandtheinstallationcannotproceed.
单项选择题 WhatRMANcommandmustyouusebeforeyoucanbackupadatabaseusingtherecoverycatalog？（）
单项选择题 Afilesystemhasbeencorruptedandneedstoberestored.Whichfilecontainstheufsdumplevelsforthisfilesystem？（）
单项选择题 WhattypeofJavaEEapplicationcanbeupgradedtoWebLogic12cusingtheSmartUpgradetool?（）
单项选择题 Whatisthepurposeoftheuntilchangeoptionoftherestorecommand？（）
单项选择题 Yourdatabaseinstanceisstartedusingtheserverparameterfile（SPFILE）.YouexecutedacommandtochangethevalueoftheLOG_BUFFERinitializationparameter：ALTERSYSTEMSETLOG_BUFFER=32MSCOPE=BOTH；Whatwouldbetheoutcomeofthiscommand（）A.ThecommandsucceedsonlyifAutomaticMemoryManagementisnotenabled.B.Thecommandsucceeds，butyouneedtorestartthedatabaseforchangestotakeeffect.C.Thecommandreturnsanerrorbecausethesizeoftheredologbuffercannotbechangeddynamically.D.TheparametervalueischangedanditcomesintoeffectassoonasspacebecomesavailableintheSystemGlobalArea（SGA）.