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.

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

单项选择题Thesalesreportneedstodisplaythesalespersonwiththehighestordertotal.Whichbuildreportbuildercomponentwouldyouusetocreateaplaceholdercolumntodisplaythevalue?（）

单项选择题TheDB_BLOCK_CHECKINGinitializationparameterissettoFALSE.Whatlevelofblockcheckingwouldbeperformed？（）

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

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