OCP-V31-041

QUESTION 41
You have applications that have frequently executed queries, and produce small and static result sets.
You configure the sqlnet.ora file in the client machine to set a nonzero value for the
OCI_RESULT_CACHE_MAX_SIZE parameter.
What is the purpose of this configuration?
A. to avoid round trips to the server by enabling caching of query results in client memory
B. to improve performance by storing a copy of the data from the private SQL area of the PGA
C. to enhance the query performance by creating a cache in the client memory for sorting operations
D. to avoid the storing of query plans and results in the server by creating a cache in the client memory
Correct Answer: A

---

您有经常执行查询的应用程序，并产生小的和静态的结果集。
你的sqlnet.ora配置文件在客户机设置为非零值
oci_result_cache_max_size参数
配置的目的是：
A.通过启用缓存在客户端内存中的查询结果，以避免到服务器的往返

---