Identify the two correct scenarios where a function can be optimized using the function result cache feature.
A.
A function which inserts multiple records into a DEPARTMENTS table as part of one-time data setup for an HR application.
B.
A function which accesses multiple tables and calculates the commission to be given to a sales representative based on the number of products sold by that representative.
C.
A function which deletes all the records from an EMPLOYEES_AUDIT table based on their LOG_DATE.
D.
A function which updates the SALARY of all the employees in an EMPLOYEES table by a fixed percentage based on their DESIGNATION.
E.
A function which calculates the factorial of a given number without accessing any table.
B and E because D has a data integrity problem when execute the update https://oracle-base.com/articles/11g/cross-session-plsql-function-result-cache-11gr1#:~:text=The%20cross%2Dsession%20PL%2FSQL,function%20with%20the%20same%20parameters.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Angelos_ang
2 years, 4 months agoRakeshpro
2 years, 4 months agoRakeshpro
2 years, 4 months agochrishillinger
2 years, 5 months agoCosminCof
4 years, 1 month agojcamt
4 years, 3 months agoolkaolka
4 years, 6 months agoprotonik2020
4 years, 5 months agoorakell
5 years, 2 months ago