单项选择题 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）.

单项选择题 Whileperformingthebackupoftheflashrecoveryarea,younoticethatoneofthearchivedredologfilesismissing.Youhavemultipledestinationsforarchivedredologfiles.Whatimplicationsdoesithaveonthebackupoftheflashrecoveryarea?（）A.Thebackupfailsbecauseoneofthearchivedredologfilesismissing.B.Thebackupsucceedsbutitwouldbewithoutthemissingarchivedlog.C.Duringbackup,youarepromptedforthealternativedestinationforthemissingarchivedredologfile.D.Thebackupsucceedsbecauseitfailsovertooneofthealternativearchivedredologdestinations.

单项选择题 WebLogicNodeManagercanbeusedtomanagethelifecycleofWebLogicservers.WebLogicNodeManagerisinstalledandstarted（）.