Oracle
1Z0-146 · Question #45
1Z0-146 Question #45: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #45. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-146 to see the answer
You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.