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.
This section is not available anymore. Please use the main Exam Page.1z0-148 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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, 7 months agoRakeshpro
2 years, 8 months agoRakeshpro
2 years, 8 months agochrishillinger
2 years, 9 months agoCosminCof
4 years, 5 months agojcamt
4 years, 7 months agoolkaolka
4 years, 10 months agoprotonik2020
4 years, 9 months agoorakell
5 years, 6 months ago