# 1z0-148 — Question 604

**Type:** multiple_response
**Topics:** topic_1

## Question

Examine this function header:
FUNCTION calc_new_sal (emp_id NUMBER) RETURN NUMBER;
You want to ensure that whenever this PL/SQL function is invoked with the same parameter value across active sessions, the result is not recomputed.
If a DML statement is modifying a table which this function depends upon, the function result must be recomputed at that point in time for all sessions calling this function.
Which two actions should you perform?

## Correct Answer

_See scenario._

## Explanation

A and E

**Reference:** examtopics_top_comment

---
Source: https://hiexam.net/q/oracle/1z0-148/604  
Practice (tracked): https://hiexam.net/study/1z0-148/practice