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.