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 4

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


gelete

gelete

C.
… Cache Memory = 32K bytes (32 blocks)

D
… Overhead = 65628 bytes