未知题型 InwhichsituationsdoestheOracleDataPumpuseexternaltablesandnotthedirectpathloadwhileexportingatable（）

未知题型 YouaremaintainingadatabasethatisinARCHIVELOGmode.Youhaveconfiguredtheflashrecoveryareainyourdatabase.ThedatabaseisinMOUNTEXCLUSIVEmode，andyouwanttoconfiguretheFlashbackDatabasefeature.WhichtwooptionsareNOTrequiredtoconfiguretheFlashbackDatabasefeature？（）A.Openthedatabaseinread-onlymode.B.SettheretentiontargetwiththeDB_FLASHBACK_RETENTION_TARGETinitializationparameter.C.Enabletheblockchangetrackingfeature.D.ExecutetheALTERDATABASEFLASHBACKONstatement.

未知题型 Whichtwointerfacesprovidethecapabilitytostoreobjectsusingakey－valuepair？（）

未知题型 Examinethecommandthatisusedtocreateatable：SQL>CREATETABLEorders（oidNUMBER（6）PRIMARYKEY，odateDATE，ccodeNUMBER（6），oamtNUMBER（10，2））TABLESPACEusers；Whichtwostatementsaretrueabouttheeffectoftheabovecommand（）A.ACHECKconstraintiscreatedontheOIDcolumn.B.ANOTNULLconstraintiscreatedontheOIDcolumn.C.TheORDERStableistheonlyobjectcreatedintheUSERStablespace.D.TheORDERStableandauniqueindexarecreatedintheUSERStablespace.E.TheORDERStableiscreatedintheUSERStablespaceandauniqueindexiscreatedontheOIDcolumnintheSYSTEMtablespace.

未知题型 TheNLS_TERRITORYparameterspecifiesthedefaultconventionstobeusedforwhichofthefollowingglobalizationelements？（）

未知题型 YouareworkingonanOracleDatabase10gdatabase.Becauseofdataloss，youdecidedtoperformaFlashbackDatabaseoperationusingthefollowingcommand：SQL>FLASHBACKDATABASETOTIMESTAMP（SYSDATE5/24）Whichtwostatementsaretrue？（）A.SYSDATEshouldnotbeusedwithTIMESTAMP.B.Thedatabasemusthavemultiplexedredologfiles.C.ThedatabasemustbeintheMOUNTstatetoexecutethecommand.D.ThedatabasemustbeopenedwiththeRESETLOGSoptionaftertheflashbackoperation.E.Theentiredatabaseneedstoberestoredfromthemostrecentbackupbeforetheflashbackoperation.

未知题型 Younoticedthattheindextablespaceinyourdatabaserequiresarecovery.However，insteadofperformingamediarecovery，youdecidedtorecreatetheindexesinanewtablespace.Whichtwooptionswouldyouusetoreducethetimeittakestorecreatetheindexes？（）A.ONLINEB.REVERSEC.PARALLELD.COMPRESSE.NOLOGGINGF.COMPUTESTATISTICS

未知题型 Whichmodifiersandreturntypeswouldbevalidinthedeclarationofaworkingmain（）methodforaJavastandaloneapplication？（）

未知题型 Whatisthenumericalrangeofachar？（）

未知题型 1.classBaseClass{2.privatefloatx=1.of；3.protectedfloatgetVar（）{returnx；}4.}5.classSubClassextendsBaseClass{6.privatefloatx=2.Of；7.//insertcodehere8.}Whichtwoarevalidexamplesofmethodoverridingwheninsertedatline7？（）A.floatgetVar（）{returnx；}B.publicfloatgetVar（）{returnx；}C.publicdoublegetVar（）{returnx；}D.protectedfloatgetVar（）{returnx；}E.publicfloatgetVar（floatf）{returnf；}

未知题型 Stringa=null；a.concat（abc”）；a.concat（def”）；System.out.println（a）；Whatistheresult？（）

未知题型 Youhaveadatabasewiththefollowingtablespaces：SYSTEM，SYSAUX，UNDO，USERS，TEMP.Youwantto"rollback"thedataintheUSERStablespacetothewayitlookedyesterday.Whichtablespacesdoyouneedtoperformapoint-in-timerestoreoperationoninordertocompletethistask？（）A.SYSTEMB.SYSAUXC.UNDOD.USERSE.TEMPF.Thisrestoreisnotpossible

未知题型 WhichtwostatementsaboutRecoveryManager（RMAN）backupsaretrue？（）

未知题型 Inyourdatabase，allthetablespacesarelocallymanaged.YoustartedRecoveryManager（RMAN）usingrecoverycatalogandrestoredthecontrolfilebyusingthefollowingcommand：RMAN>RESTORECONTROLFILE；Whichtwooperationsdoyouneedtoperformafterrestoringthecontrolfilefrombackup？（）A.shutdownandrestarttheinstanceB.addnewtempfilestothetemporarytablespacesafterrecoveryC.performamediarecoveryandopenthedatabasewiththeRESETLOGSoptionD.performamediarecoveryandbringthedatabasetoNOARCHIVELOGmode

未知题型 YouarecreatingaformthatwillaccessanOracle8database.Onwhichthreesourcescanyoubaseadatablock?（）

未知题型 WhichtwostatementsregardingtheFLASHBACK_TRANSACTION_QUERYviewarecorrect?（）

未知题型 Whichtwoarecharacteristicsofuser－managedbackupandrecoveryoperations？（）

未知题型 HowcananOracleWebLogiccluster’scapacitybeincreased？（）

未知题型 Yourdatabaseinstanceisfunctionalforthepastonemonth.TheAutomaticWorkloadRepository（AWR）snapshotretentionissetto7andtheSTATISTICS_LEVELinitializationparameterissettoTYPICAL.Youreceiveacomplaintaboutthepoorperformanceofthedatabasebetween7PMand9PMofthepreviousday.Choosetwoactionsanyofwhichcanbereferredtofirsttodiagnosetheproblem.（）A.UsetheActiveSessionHistoryreport.B.UsetheAWRComparePeriodsreport.C.UseanADDManalysisbetween7PMand9PMofthepreviousday.D.UsetheAWRComparePeriodreportbetween7PMand9PMofthepreviousday.

未知题型 IdentifythreeuniqueintegrationfeaturesofSpringandWebLogicServer.（）