单项选择题

A.YouidentifiedtopSQLqueriesthatconsumetime.WhatwouldbeyournextsteptofindoutrecommendationsaboutstatisticscollectionandrestructuringoftheSQLstatementtoimprovequeryperformance?()
A.runSegmentAdvisor
B.runSQLTuningAdvisorontopSQLstatements
C.runtheAutomaticWorkloadRepository(AWR)report
D.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().

单项选择题 YouneedtochangethehostnameandIPaddressofaserver.Withoutmanuallyeditingalloftherequiredfiles,whichcommandcanberuntorestoreasystemconfigurationtoanunconfiguredstate,readytobereconfiguredagainrestoreasystemconfigurationtoanunconfiguredstate,readytobereconfiguredagain?()A./usr/sbin/sys-unconfigB./usr/sbin/unconfigC./sbin/ipconfigD./usr/sbin/set_parmsinitial

单项选择题 YourdatabaseisconfiguredinNOARCHIVELOGmode.Duetoamediafailure,youhavelostoneofthedatafilesbelongingtoaread-onlytablespace.Youknowthatthelastbackupwasperformedafterthetablespacewasmaderead-only.Whichactionshouldyoutaketorestorethemissingdatafileintheminimumamountoftime?()A.Restoreallthedatafilesfromthebackup.B.Restoreonlythelostdatafilefromthebackup.C.Restoreallthedatafilesforthelosttablespacefromthebackup.D.RestoreallthedatafilesforthelosttablespaceandalltheSYSTEMandSYSAUXdatafilesfromthebackup.

单项选择题 WhichstepdoyouneedtoperformtoenableauserwiththeSYSDBAprivilegetologinasSYSDBAiniSQL*Plus?()

单项选择题 Becauseofapoweroutage,instancefailurehasoccurred.Fromwhatpointintheredologdoesrecoverybeginandwheredoesitend?()

单项选择题 YouarepartoftheDBAteamworkingfora&en

单项选择题 IntheareaofPerformanceManagementandDiagnostics,whichfeatureissupportedinOracleEnterpriseManager12C?()

单项选择题 Whichstatementistrueregardingthissetting?()

单项选择题 Youneedtorestoresomefilesfromafilesystem.Thefilesystemwasbackedupfromasnapshot.Whichcommandwillcorrectlyrestorethesefiles?()

单项选择题 Youhavecontrol-fileautobackupsenabled.WhenstartingyourdatabasefromSQL*Plus,youreceivethefollowingerrormessage:SQL>startupORA-01078:failureinprocessingsystemparametersLRM-00109:couldnotopenparameterfile,C:/ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORAUsingRMAN,howwouldyourespondtothiserror?()A.Issuethestartupnomountcommandandthenissuetherestoreparameterfilecommandfromthe RMANprompt.B.IssuethestartupnomountcommandandthenissuetherestorespfilecommandfromtheRMANprompt.C.Issuethestartupnomountcommandandthenissuetherestorespfilefromautobackupcommand fromtheRMANprompt.D.Issuethestartupnomountcommandandthenissuetherestorespfilefrombackupcommand from theRMANprompt.E.IssuetherestorespfilefromautobackupcommandfromtheRMANprompt.

单项选择题 Thesizeofthelargestdatafile,data1.dbf,inyourdatabaseis30MB.Youissuedthe followingcommand:RMAN>CONFIGUREMAXSETSIZE10MB;Whatwillbetheimpactoftheabovesetting?()

单项选择题 Afterexecutingthecommandalterdiskgroupdiskgroup2dropdiskdg2a;youissuethefollowingcommandfromtheASMinstance:Selectgroup_number,count(*)fromv$asm_operation;WhatistheimplicationifthequeryagainstV$ASM_OPERATIONreturnszerorows?()A.Thedropdiskoperationisstillproceedingandyoucannotyetruntheundropdisksoperation.B.Thedropdiskoperationiscompleteandyoucanruntheundropdiskscommandifneeded.C.Thedropdiskoperationiscompleteandyoucannotruntheundropdiskcommand.D.ThequerywillfailsincethereisnotaV$ASM_OPERATIONviewavailableinanASMinstance.E.Noneoftheaboveistrue.