Oracle Exam 1Z0-148 Topic 7 Question 9 Discussion

Actual exam question for Oracle's 1Z0-148 exam

Question #: 9
Topic #: 7

Identify the three options which make a PL/SQL function highly suitable for using the RESULT_CACHE clause in

its definition. (Choose three.)

AThe tables which are read in the function are very frequently updated.

BThe code in the function performs more write operations on the database when compared to the read operations.

CThe function has complex business logic depending on more than five tables to compute its return values.

DThe function involves highly computational logic with minimal or no database access.

EThe value returned by the function is deterministic for a given set of input parameters.

FThe logic in the function accesses tables or uses package variables which are modified very rarely.

Show Suggested Answer

Suggested Answer: D, E, F

by Rodolfo at May 09, 2022, 09:08 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!