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

单项选择题 Acustomerstoresenvironmentalsettingsinthedeploymentdescriptorsofanapplication.Whenevertheypromotetheapplicationversionfromtestingtotheproductionenvironment,theyneedtoopenthearchiveandmodifythedeploymentdescriptor.Thisprocessisagainsttheirsecuritypolicy.WhatapproachshouldyourecommendtoleverageWebLogicfeaturessuchthattheydonothavetomodifytheapplicationarchivefordifferentenvironments?（）A.Keepenvironmentaldataintheglobalsettingsofdomainandtheapplicationcanreaditfromthedomainwhereitruns.B.KeepenvironmentaldatainDeploymentPlanXMLfiles.Itallowsyoutochangeparametersinthedeploymentdescriptorwithoutopeningthearchivefile.C.Keepenvironmentaldatainthedatabasebecauseitisthemosteffectivewayofparametrizingtheenvironment.D.Keeparchiveinexplodedformatsothecustomerdoesnothavetoopenthearchivefiles.E.Eliminateallenvironmentalsettingsfromtheapplication.Thereshouldnottobeanyenvironmentalsettingsintheapplication.

单项选择题 Whichsettingchangewouldyouallowtomakeachildobjecttobemovedoutofaparentobject?（）

单项选择题 YouaremaintainingyourdatabaseinOracle10g.Youarenotusingtherecoverycatalogtomaintainthebackupmetadatainformation.Youwanttoenablethereusablesectionofthecontrolfiletoexpanditselfiftheoldestrecordcannotbereused，andwheneveranewrecordisaddedtothereusablesectionofthecontrolfile.WhichvaluewillyousetfortheCONTROL_FILE_RECORD_KEEP_TIMEparameter？（）A.ZeroB.OneormoreC.NONED.DEFAULT

单项选择题 Foraninventoryreport,youcreatedawork_in_progressthatcontainstwocolumns,ID_numberandquantity.Theparentgroupofthework_in_progressisin_inventorywhichcontainsonecolumn,dept_no.Youaddedafilteroffistfifteentototal_inventoryandafilteroflast20forwork_in_progress.Whichrecordswillthereportreturn?（）A.First15dept_novalues.B.Last20ID_noandquantityvalueswiththefirst15dept_novaluesforeachwork_in_progressvalue.C.First15dept_novalueswiththelast20ID_numberandquantityvaluesforeachtotal_inventoryvalue.D.First15dept_novaluesandthelast20ID_noandquantityvalues.E.Thelast20ID_numberandquantityvalues.

单项选择题 Thetransportationdepartmentrequestedashippingcostreporttolisttheresourcesusedbyeachdepartment.Aseparatepageshouldbeproductforeachdepartment.Whichpropertywouldyoumodifytoachievetheseresults?（）

单项选择题 AWebLogicteamisdevelopinganenterpriseapplicationfromtheirdesktopWebLogicenvironment.Alldevelopmentsystemsareconnectedtothesameeightdatasourcesfortesting.AsaWebLogicAdministratorsupportingthisteam,whichtwoactionsshouldyouperformtofreethedevelopersfromcreatingandconfiguringallthedatasourcesontheirdesktopWebLogicenvironment?（）A.ProvidetheteamwithaWebLogicdomaintemplatewiththetestingdatasourcesconfigured.B.Providethedevelopmentteamwithapreconfigureddomainarchivefile.C.Providethedevelopmentteamwiththe[datasource]-jdbc.xmlfiletooverwritetheirlocalcopy.D.Createthedatasourcesonbehalfeachofthedeveloper.E.ProvidethedevelopmentteamwithWLSTscriptstocreateandconfigurethetestingdatasources.

单项选择题 Youcreatethesalesreportandrunitinthelivepreviewer.Afterwhichchangewouldthelivepreviewerrequirethedata?（）

单项选择题 WhilecreatingadatabaseusingDatabaseConfigurationAssistanttool，youcreatedadatabasedefaulttemporarytablespace.Whichactivitywouldcausethedefaulttemporarytablespaceofthedatabasetobeused？（）

单项选择题 YouadministeranOracleDatabase10gandathird-partydatabase.YouuseRecoveryManager（RMAN）toperformbackupandrecoveryoperations.YouhaveconfiguredarecoverycatalogtoactasanRMANrepository.TowhichofthefollowingdatabasescanyouNOTconnectusingtheRMANCONNECTcommand？（）A.targetdatabaseB.auxiliarydatabaseC.third-partydatabaseD.recoverycatalogdatabase

单项选择题 Youwanttomigrateyourapplicationfromthedevelopmentenvironmenttotheproductionenvironment.Whiledoingthetask，youwantthedatabaseobjectsownedbytheuserDEVUSERinthedevelopmentenvironmenttobemovedtotheuserAPPSintheproductionenvironment.WhichoptionofOracleDataPumpImportwouldyouusetoachievethisobjective？（）A.ownerB.touserC.includeD.schemasE.fromuserF.transformG.remap_schemaH.remap_datafileI.reuse_datafilesJ.remap_tablespace

单项选择题 YouwanttomoveallobjectsoftheAPPSuserinthetestdatabasetotheDB_USERschemaoftheproductiondatabase.WhichoptionofIMPDPwouldyouusetoaccomplishthistask（）

单项选择题 Given：11.staticclassA{12.voidprocess（）throwsException{thrownewException（）；}13.}14.staticclassBextendsA{15.voidprocess（）{System.out.println（"B"）；}16.}17.publicstaticvoidmain（String[]args）{18.Aa=newB（）；19.a.process（）；20.}Whatistheresult？（）A.Compilationfailsbecauseofanerrorinline19.B.Anexceptionisthrownatruntime.C.BD.Compilationfailsbecauseofanerrorinline18.E.Compilationfailsbecauseofanerrorinline15.F.Thecoderunswithnooutput.

单项选择题 Youcreatingareportthatwillruninbothcharactermodeandbitmappedenvironments.Youincludesomeprintercodesinyourreport.Whatwillhappenwhenyourunthereportinbitmappedmode?（）

单项选择题 Ifalogfilebecomescorrupted，itmaycausethedatabasetostall.Howwouldyoucorrectsuchasituation？（）