ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-148 All Questions

View all questions & answers for the 1z0-148 exam
Go to Exam

Exam 1z0-148 topic 1 question 47 discussion

Actual exam question from Oracle's 1z0-148
Question #: 47
Topic #: 1
[All 1z0-148 Questions]

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 Hide Answer
Suggested Answer: DE 🗳️
by kahabe59 at March 12, 2020, 1:28 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
chrishillinger
2 years, 8 months ago
Selected Answer: AD
AD is correct
upvoted 1 times
...
CosminCof
4 years, 4 months ago
AD is right
upvoted 3 times
...
Adela_bg
4 years, 10 months ago
A and E are correct
upvoted 1 times
Adela_bg
4 years, 9 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, 1 month 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, 1 month 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, 7 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, 7 months ago
SOrry: answ -> A,D for how i said before
upvoted 2 times
...
...
...
...
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.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago