Oracle
1Z0-146 · Question #110
You executed this command to gather information about the memory allocation for storing query results: SQL> execute dbms_result_cache.memory_report View the Exhibit and examine the output for the…
The correct answer is C. Currently 32 KB is allocated to the result cache. D. The result cache can be increased by 65628 bytes. See the full explanation below for the reasoning.
Question
You executed this command to gather information about the memory allocation for storing query results:
SQL> execute dbms_result_cache.memory_report View the Exhibit and examine the output for the execution of the DBMS_RESULT_CACHE.MEMORY_REPORT procedure. Which two statements are true about the output in the Exhibit? (Choose two.)
Exhibit
Options
- AIn total, four blocks are used by the result cache.
- BCurrently 52 KB is allocated to the result cache.
- CCurrently 32 KB is allocated to the result cache.
- DThe result cache can be increased by 65628 bytes.
How the community answered
(23 responses)- A13% (3)
- B4% (1)
- C83% (19)
Community Discussion
No community discussion yet for this question.