单项选择题

A.Thecachedresultbecomesinvalidwhenanystructuralchangei……

Evaluatethefollowingfunctioncode：CREATEFUNCTIONget_dept_avg（dept_idNUMBER）RETURNNUMBERRESULT_CACHERELIES_ON（EMPLOYEES）ISavgsalNUMBER（6）；BEGINSELECTAVG（SALARY）INTOavgsalFROMEMPLOYEESWHEREDEPARTMENT_ID=dept_id；RETURNavgsal；ENDget_dept_avg；Whichstatementistrueregardingtheabovefunction？（）
A.ThecachedresultbecomesinvalidwhenanystructuralchangeisdonetotheEMPLOYEEStable.
B.Ifthefunctionexecutionresultsinanunhandledexception，theexceptionresultisalsostoredinthecache.
C.Eachtimethefunctionisinvokedinadifferentsession，thecurrentresultintheresultcachegetsoverwritten.
D.Ifthefunctionisinvokedwithadifferentparametervalue，theexistingresultintheresultcache getsoverwrittenbythelatestvalue.

A.ThecachedresultbecomesinvalidwhenanystructuralchangeisdonetotheEMPLOYEEStable.
B.Ifthefunctionexecutionresultsinanunhandledexception，theexceptionresultisalsostoredinthecache.
C.Eachtimethefunctionisinvokedinadifferentsession，thecurrentresultintheresultcachegetsoverwritten.
D.Ifthefunctionisinvokedwithadifferentparametervalue，theexistingresultintheresultcache

<上一题目录下一题>

热门试题

单项选择题YouconfiguredthelargepoolforOraclebackupandrestoreoperations.Asaresult，whichcomponentwouldrequirelessmemory？（）

A.streamspool
B.sharedpool
C.logbuffer
D.keepbuffercache
E.recyclebuffercache

单项选择题Thesalesreportneedstodisplaythesalespersonwiththehighestordertotal.Whichbuildreportbuildercomponentwouldyouusetocreateaplaceholdercolumntodisplaythevalue?（）

A.Reportwizard.
B.Layoutmodel.
C.Datamodel.
D.Lifepreviewer.

单项选择题TheDB_BLOCK_CHECKINGinitializationparameterissettoFALSE.Whatlevelofblockcheckingwouldbeperformed？（）

A.TheOracledatabasewillnotperformblockcheckingforanyofthedatablocks.
B.TheOracledatabasewillperformblockcheckingforthedefaultpermanenttablespaceonly.
C.TheOracledatabasewillperformblockcheckingforthedatablocksinallusertablespaces.
D.TheOracledatabasewillperformblockcheckingforthedatablocksintheSYSTEMtablespaceonly.
E.TheOracledatabasewillperformblockcheckingforthedatablocksintheSYSTEMandSYSAUXtablespaces.

单项选择题您有一台运行WindowsVista的计算机。您在计算机的新分区上安装Windows7。您需要确保计算机总是在默认状态下启动WindowsVista。您应该怎么办？（）

A.运行Bcdedit.exe并指定/default参数
B.运行Bcdedit.exe并指定/bootems参数
C.在Windows7分区的根目录中创建boot.ini文件
D.在WindowsVista分区的根目录中创建boot.ini文件

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Inyourorganization，youhavefourdatabases，SupportCenterDB01，SupportCenterDB02，SupportCenterDB03，andSupportCenterDB04，whicharelocatedinBerlin，Frankfurt，Rammstein，andMunichrespectively，andwhichwerecreatedusingDatabaseConfigurationAssistant（DBCA）.Youwanttoperformadministrativetasksonthesedatabasesthatincludestartupandshutdown，takingregularbackups，andsoon，fromFrankfurtusingOracletools.WhichOraclefilewouldyouenabletoperformthistask？（）A.ControlfileB.PasswordfileC.ParameterfileD.OnlineredologfileE.ListenercontrollerfileF.Serverparameterfile

A.cn.Inyourorganization，youhavefourdatabases，SupportCenterDB01，SupportCenterDB02，SupportCenterDB03，andSupportCenterDB04，whicharelocatedinBerlin，Frankfurt，Rammstein，andMunichrespectively，andwhichwerecreatedusingDatabaseConfigurationAssistant（DBCA）.Youwanttoperformadministrativetasksonthesedatabasesthatincludestartupandshutdown，takingregularbackups，andsoon，fromFrankfurtusingOracletools.WhichOraclefilewouldyouenabletoperformthistask？（）
A.Controlfile
B.Passwordfile
C.Parameterfile
D.Onlineredologfile
E.Listenercontrollerfile
F.Serverparameterfile

单项选择题YouareshrinkingtheSCOTT.EMPtablebyexecutingtheALTERTABLESCOTT.EMPSHRINKSPACECASCADEstatement.WhatisaprerequisiteforshrinkingtheSCOTT.EMPtable？（）

A.Youmustenabletheblockchangetrackingfeature.
B.Youmusthaveenabletheflashbackfeature.
C.YoumustusetheOMFinyourdatabase.
D.YoumustdefinethetablespaceoftheSCOTT.EMPtableforautomaticsegmentspacemanagement.

单项选择题Yourdatabaseblocksizeis4KB.Inthisdatabase，youarerequiredtocreateatablespacewithablocksizeof8KB.Whichistheprerequisiteforcreatingthistablespace？（）

A.TheparameterDB_CACHE_SIZEmustbeamultipleof8.
B.ThevalueoftheparameterSGA_MAX_SIZEmustbeincreased.
C.Thetablespacemustbecreatedwithauniformextentsizeof8KB
D.TheparameterDB_8K_CACHE_SIZEmustbedefinedintheparameterfile.

单项选择题YouneedtocreateaJavaBeanobjectthatisusedonlywithinthecurrentJSPpage.ItmustNOTbeaccessibletoanyotherpageincludingthosethatthispagemightimport.WhichJSPstandardactioncanaccomplishthisgoal？（）

A.<jsp：useBeanid=’pageBean’type=’com.example.MyBean’/>
B.<jsp：useBeanid=’pageBean’class=’com.example.MyBean’/>
C.<jsp：makeBeanid=’pageBean’type=’com.example.MyBean’/>
D.<jsp：makeBeanid=’pageBean’class=’com.example.MyBean’/>

单项选择题1.classAnimal｛AnimalgetOne（）｛returnnewAnimal（）；｝｝2.classDogextendsAnimal｛3. insertcodehere4.｝5.6.classAnimalTest｛7.publicstaticvoidmain（String[]args）｛8.Animal[]animal＝｛newAnimal（），newDog（）｝；9.for（Animala：animal）｛10.Animalx＝a.getOne（）；11.｝12.｝13.｝和代码：3a.DoggetOne（）｛returnnewDog（）；｝3b.AnimalgetOne（）｛returnnewDog（）；｝第3行中插入的哪项将编译且运行无异常？（）A.3a行B.3b行C.3a行或3b行D.既非3a，也非3b

A.classAnimal｛AnimalgetOne（）｛returnnewAnimal（）；｝｝2.classDogextendsAnimal｛3.//insertcodehere4.｝5.6.classAnimalTest｛7.publicstaticvoidmain（String[]args）｛8.Animal[]animal＝｛newAnimal（），newDog（）｝；9.for（Animala：animal）｛10.Animalx＝a.getOne（）；11.｝12.｝13.｝和代码：3a.DoggetOne（）｛returnnewDog（）；｝3b.AnimalgetOne（）｛returnnewDog（）；｝第3行中插入的哪项将编译且运行无异常？（）
A.3a行
B.3b行
C.3a行或3b行
D.既非3a，也非3b

单项选择题classBirds{publicstaticvoidmain（String[]args）{try{thrownewException（）；}catch（Exceptione）{try{thrownewException（）；}catch（Exceptione2）{System.out.print（ inner ）；}System.out.print（ middle ）；}System.out.print（ outer ）；}}结果为：（）A.innerB.innerouterC.middleouterD.innermiddleouter

A.out.print（"inner"）；}System.out.print（"middle"）；}System.out.print（"outer"）；}}结果为：（）
A.inner
B.innerouter
C.middleouter
D.innermiddleouter

单项选择题Inform－basedauthentication，whatmustbeincludedintheHTMLreturnedfromtheURLspecifiedbytheelement？（）

A.abase-64encodedusernameandpassword
B.aformthatPOSTstothej_security_checkURL
C.anappletthatrequeststheusernameandpasswordfromtheuser
D.ahiddenfieldthatsuppliesthelogin-constraintusedbytheapplication

单项选择题Whichactivitysupportsthedataintegrityrequirementsofanapplication？（）

A.UsingHTTPSasaprotocol
B.UsinganLDAPsecurityrealm
C.UsingHTTPBasicauthentication
D.Usingforms-basedauthentication

单项选择题Youneedtocreateaservletfilterthatstoresallrequestheaderstoadatabaseforallrequeststothewebapplication’shomepage index.jsp .WhichHttpServletRequestmethodallowsyoutoretrievealloftherequestheaders？（）A.String[]getHeaderNames（）B.String[]getRequestHeaders（）C.java.util.IteratorgetHeaderNames（）D.java.util.IteratorgetRequestHeaders（）E.java.util.EnumerationgetHeaderNames（）

A.jsp".WhichHttpServletRequestmethodallowsyoutoretrievealloftherequestheaders？（）
A.String[]getHeaderNames（）
B.String[]getRequestHeaders（）
C.java.util.IteratorgetHeaderNames（）
D.java.util.IteratorgetRequestHeaders（）
E.java.util.EnumerationgetHeaderNames（）

单项选择题Youissuedthefollowingcommand：ALTERDATABASEENABLEBLOCKCHANGETRACKING；Whatwillbetheresultofissuingthiscommand？（）

A.Theblockchangetrackingfeatureisenabled，andtheinformationaboutthesystemchangenumberiswritteninthechangetrackingfile.
B.Theblockchangetrackingfeatureisenabled，andtheinformationaboutthelogsequencenumberiswritteninthechangetrackingfile.
C.Theblockchangetrackingfeatureisenabled，andtheinformationabouttheblocksthatarechangedsincethelastbackupiswritteninthechangetrackingfile.
D.Theblockchangetrackingfeatureisenabled，andtheinformationaboutthelocationsofthedatafilesandtheonlineredologfilesarewritteninthechangetrackingfile.

单项选择题Inwhichsituationwouldyouusestaticdatabaseregistrationforalistener（）

A.whenmultipledatabasesaretoberegisteredwiththelistener
B.whenDBAsneedtoconnectremotelytostartupthedatabaseinstance
C.whenusersneedtoconnectthedatabaseinstanceusingthehostnamingmethod
D.whenthedatabaseinstancethatistoberegisteredwiththelistenerisconfiguredinsharedservermode