1Z0-146 · Question #45
The database instance was recently started up. Examine the following parameter settings for the database instance: NAME TYPE VALUE…
The correct answer is B. 1056 KB is allocated for the result cache, but the result cache is disabled. https://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm#ADMIN11202 Look for Specifying the Result Cache Maximum Size: "Note that after starting the database with the result cache disabled, if you use an ALTER SYSTEM statement to set RESULT_CACHE_MAX_SIZE to a…
Question
The database instance was recently started up. Examine the following parameter settings for the database instance:
NAME TYPE VALUE ---------------------- --------- ----------- ......... result_cache_max_result integer 5 result_cache_max_size big integer 0 result_cache_mode string MANUAL result_cache_remote_expiration integer 0 ......... You reset the value for the result_cache_max_size parameter by issuing the following command:
SQL> ALTER SYSTEM SET result_cache_max_size = 1056k SCOPE = BOTH; System altered. Which statement is true in this scenario?
Options
- A1056 KB is allocated for the result cache and the result cache is enabled.
- B1056 KB is allocated for the result cache, but the result cache is disabled.
- CThe results for only the queries that have the RESULT_CACHE hint are cached.
- DThe results for all the queries except those having the NO_RESULT_CACHE hint are cached.
How the community answered
(46 responses)- A7% (3)
- B78% (36)
- C2% (1)
- D13% (6)
Explanation
https://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm#ADMIN11202 Look for Specifying the Result Cache Maximum Size: "Note that after starting the database with the result cache disabled, if you use an ALTER SYSTEM statement to set RESULT_CACHE_MAX_SIZE to a nonzero value but do not restart the database, querying the value of the RESULT_CACHE_MAX_SIZE parameter returns a nonzero value even though the result cache is still disabled."
Topics
Community Discussion
No community discussion yet for this question.