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
Answer: A
参考：http://docs.oracle.com/cd/E11882_01/appdev.112/e10646/oci10new.htm#LNOCI16752
您有频繁执行查询的应用程序，并产生小的和静态的结果集。
您在客户机上配置sqlnet.ora文件为OCI_RESULT_CACHE_MAX_SIZE(OCI结果缓存最大尺寸)参数设置一个非零值。
这种配置的目的是什么？
通过在客户端内存启用查询结果缓存来避免到服务器的往返
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
Answer: A
参考：http://docs.oracle.com/cd/E11882_01/appdev.112/e10646/oci10new.htm#LNOCI16752
您有频繁执行查询的应用程序，并产生小的和静态的结果集。
您在客户机上配置sqlnet.ora文件为OCI_RESULT_CACHE_MAX_SIZE(OCI结果缓存最大尺寸)参数设置一个非零值。
这种配置的目的是什么？
通过在客户端内存启用查询结果缓存来避免到服务器的往返
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2122875/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q37
下一篇：
1Z0-053 V13.02 Q42
请登录后发表评论
登录
全部评论
