Exam 1z0-148 topic 1 question 47 discussion

Actual exam question from Oracle's 1z0-148

Question #: 47
Topic #: 1

You created a PL/SQL function with the RESULT_CACHE clause, which calculates a percentage of total marks for each student by querying the MARKS table.
Under which two circumstances will the cache for this function not be used and the function body be executed instead?

A. When a user fixes incorrect marks for a student, with an update to the MARKS table, and then executes the function in the same session
B. When the amount of memory allocated for the result cache is increased
C. When the function is executed in a session frequently with the same parameter value
D. When the database administrator disables the result cache during ongoing application patching
E. When the maximum amount of server result cache memory that can be used for a single result is set to 0.

Show Suggested Answer

Suggested Answer: DE 🗳️

by kahabe59 at March 12, 2020, 1:28 p.m.

Comments

Submit Cancel

chrishillinger

2 years, 9 months ago

Selected Answer: AD

AD is correct

upvoted 1 times

...

CosminCof

4 years, 6 months ago

AD is right

upvoted 3 times

...

Adela_bg

4 years, 11 months ago

A and E are correct

upvoted 1 times

Adela_bg

4 years, 11 months ago

My bad - A and D. In E -RESULT_CACHE_MAX_RESULT(Specifies the maximum amount of server result cache memory (in percent) that can be used for a single result. Valid values are between 1 and 100. The default value is 5%. You can set this parameter at the system or session level.) cannot be set to 0

upvoted 1 times

...

kahabe59

5 years, 2 months ago

A and D are correct. Setting parameter RESULT_CACHE_MAX_RESULT to 0 does not disable result caching. Changing table content triggers oracle to invalidate cach entries.

upvoted 3 times

Singer

5 years, 2 months ago

As per https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams206.htm#REFRN10272: RESULT_CACHE_MAX_SIZE specifies the maximum amount of SGA memory (in bytes) that can be used by the Result Cache. Values of this parameter greater than 0 are rounded up to the next multiple of 32 KB. If the value of this parameter is 0, then the feature is disabled. So it must be that A and E are correct, not A and D.

upvoted 2 times

certyk

4 years, 8 months ago

E is not correct because of "Valid values are between 1 and 100. The default value is 5%. You can set this parameter at the system or session level." ref "https://docs.oracle.com/database/121/TGDBA/tune_result_cache.htm" Correct : A,E

upvoted 2 times

certyk

4 years, 8 months ago

SOrry: answ -> A,D for how i said before

upvoted 2 times

...