Oracle
1Z0-146 · Question #42
In which two situations is the body of a result-cached function executed? (Choose two.)
The correct answer is C. if the first time a session on this database instance invokes the function with a parameter value D. if a session executes a data manipulation language (DML) statement on a table or view that was. See the full explanation below for the reasoning.
Question
In which two situations is the body of a result-cached function executed? (Choose two.)
Options
- Aif the memory allocated for the result cache is increased
- Bif a session on this database instance invokes the function with the same parameter values
- Cif the first time a session on this database instance invokes the function with a parameter value
- Dif a session executes a data manipulation language (DML) statement on a table or view that was
How the community answered
(51 responses)- A10% (5)
- B20% (10)
- C71% (36)
Community Discussion
No community discussion yet for this question.