單項(xiàng)選擇題

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

你可能感興趣的試題

單項(xiàng)選擇題

Evaluate the following code：
SQL>VARIABLE task_name VARCHAR2（255）； SQL>VARIABLE sql_stmt VARCHAR2（4000）； SQL>BEGIN ：sql_stmt ：= ’SELECT COUNT（*） FROM customers
WHERE cust_state_province =’’CA’’’；：task_name ：= ’MY_QUICKTUNE_TASK’；
DBMS_ADVISOR.QUICK_TUNE（DBMS_ADVISOR.SQLACCESS_ADVISOR，
：task_name，：sql_stmt）；
END；
What is the outcome of this block of code？（）

A. It creates a task and workload， and executes the task.
B. It creates a task and workload but does not execute the task.
C. It produces an error because a template has not been created.
D. It produces an error because the SQL Tuning Set has not been created.

單項(xiàng)選擇題

The SQL Tuning Advisor configuration has default settings in your database instance.
Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task？（）

A. statistics recommendations
B. SQL Profile recommendations
C. Index-related recommendations
D. restructuring of SQL recommendations

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

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？（）

你可能感興趣的試題

The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task？（）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

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？（）

The SQL Tuning Advisor configuration has default settings in your database instance.
Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task？（）