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 43 discussion

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

Examine this query executed as SYS and its output:

Which two observations are true based on the output?

  • A. The client-side result cache and the server-side result cache are enabled.
  • B. All distinct query results are cached for the duration of a SYS user session.
  • C. Repetitive SQL queries and PL/SQL function results are cached and automatically used from the cache across all SYS user sessions.
  • D. The result cache exists but which SQL queries are cached depends on the value of the RESULT_CACHE_MODE parameter.
  • E. Repetitive SQL queries executed on permanent non-dictionary objects may have faster response times.
Show Suggested Answer Hide Answer
Suggested Answer: CD 🗳️
by protonik2020 at Aug. 24, 2020, 6:07 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, 9 months ago
Selected Answer: DE
DE is correct according to https://docs.oracle.com/database/121/TGDBA/tune_result_cache.htm#TGDBA640
upvoted 1 times
...
CosminCof
4 years, 6 months ago
I think is DE, A could not be because you cant control client side cache.
upvoted 3 times
...
jcamt
4 years, 7 months ago
C is not the answer because the automatic use of DBMS_RESULT_CACHE depends of the RESULT_CACHE_MODE, I think A and D too https://oracle-base.com/articles/11g/cross-session-plsql-function-result-cache-11gr1
upvoted 1 times
...
gusa
4 years, 9 months ago
The dbms_result_cache package is used to yield the DBA management options of memory used by both SQL Result Cache and PL/SQL function Result Cache. Here are procedures and functions of the dbms_result_cache package
upvoted 1 times
...
protonik2020
4 years, 9 months ago
A,D for me
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