Which statement is true in this scenario?

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?

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?

A.
1056 KB is allocated for the result cache and the result cache is enabled.

B.
1056 KB is allocated for the result cache, but the result cache is disabled.

C.
The results for only the queries that have the RESULT_CACHE hint are cached.

D.
The results for all the queries except those having the NO_RESULT_CACHE hint are cached.

Show Hint

Leave a Reply 3

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

Vova M.

Vova M.

If RESULT_CACHE_MAX_SIZE is 0 upon instance startup, the result cache is disabled. To reenable it you must set RESULT_CACHE_MAX_SIZE to a nonzero value (or remove this parameter from the text initialization parameter file to get the default maximum size) and then restart the database.

Reply