Oracle Database Advanced PL SQL 12c 1z0 148

Question : 7 of 54

Marks: +1, -0

Identify the two correct scenarios where a function can be optimized using the function result cache feature. (Choose two.)

A function which inserts multiple records into a DEPARTMENTS table as part of one-time data setup for an HR application.
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.
A function which deletes all the records from an EMPLOYEES_AUDIT table based on their LOG_DAT
A function which updates the SALARY of all the employees in an EMPLOYEES table by a fixed percentage based on their DESIGNATION.
A function which calculates the factorial of a given number without accessing any table.

Go to Question:

Prev Question

Next Question