Which two statements are true about the output in the Exhibit?

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.)

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.)

A.
In total, four blocks are used by the result cache.

B.
Currently 52 KB is allocated to the result cache.

C.
Currently 32 KB is allocated to the result cache.

D.
The result cache can be increased by 65628 bytes.



Leave a Reply 5

Your email address will not be published. Required fields are marked *


leo yu

leo yu

fixed memory cannot be allocated to the result cache? fixed memory is only for the use of result cache management?