首页/ 题库 / [单选题]You have application的答案

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?()

单选题
2022-01-03 19:25
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
查看答案

正确答案
A

试题解析