Oracle Exam 1Z0-064 Topic 3 Question 11 Discussion

Actual exam question for Oracle's 1Z0-064 exam

Question #: 11
Topic #: 3

You are administrating a database that supports a DSS workload. Syntactically similar queries using joins and aggregate functions are frequently executed by users to fetch data from remote databases by using database links.

Which three tasks should you perform to improve the performance of these queries?

AEnsure that the RESULT_CACHE_MAX_RESULT parameter is set to 100.

BEnsure that the RESULT_CACHE_REMOTE_EXPIRATION parameter is set to a nonzero value for the local instance.

CEnsure that the RESULT_CACHE_MAX_SIZE parameter is set to a nonzero value on the local database instance.

DEnsure that the RESULT_CACHE_MAX_SIZE parameter is set to a nonzero value on both the local and remote database instances.

EEnsure that the RESULT_CACHE_MAX_SIZE parameter is set to a nonzero value on the remote database instance.

FEnsure that the RESULT_CACHE_MAX_MODE parameter is set to FORCE for the local instance.

GEnsure that the RESULT_CACHE_MODE parameter is set to FORCE for remote database instances.

Show Suggested Answer

Suggested Answer: B, C, F

by Delisa at May 09, 2022, 03:09 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-064 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!