itgle.com

Evaluatethefollowingfunctioncode:CREATEFUNCTIONget_dept_avg(dept_idNUMBER)RETURNNUMBERRESULT_CACHERELIES_ON(EMPLOYEES)ISavgsalNUMBER(6);BEGINSELECTAVG(SALARY)INTOavgsalFROMEMPLOYEESWHEREDEPARTMENT_ID=dept_id;RETURNavgsal;ENDget_dept_avg;Whichstatementistr

题目

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.


相似考题