CUUG内部OCP题库解析-053-文档5

1、CUUG内部OCP题库解析-053-文档5题库新特点：oracle 11g版本的ocp 053认证考试是所有这几科里数量最多的考试了，cuug整理了近期的053考题，并进行了讲解。下面的题是（053考试-第5个文档）里的一些考题。其他题找相关文档，或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档2 7/17/1937.During the installation of Oracle Database 11g, you do not setORACLE_BASE explicitly. Yo u selected the option to create a database as partof the installation. How would this environment variable setting affect theinstallation?A. The installation terminates with an error.B. The installation proceeds with the d

2、efault value without warnings anderrors.C. The installation proceeds with the default value but it would not be anOFA-compliant database.D. The installation proceeds with the default value but a message would begenerated in the alert log file.Answer: D38.The SQL Tuning Advisor configuration has default settings in your databaseinstance. Which recommendation is automatically implemented after the SQLTuning Advisor is run as part of the automatic maintenance task?A. statistics recommendationsB. SQ

3、L Profile recommendations C. Index-related recommendationsD. restructuring of SQL recommendations Answer: B对照第35题的题目35.You want the Automatic SQL Tuning process to stop accepting andimplementing the recommended SQL profiles automatically. Which actionwould you perform to achieve this?A. Edit the automatic maintenance window group configuration.B. Set the CURSOR_SHARING parameter to EXACT for the database instance.C. Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure toset ACCEPT_SQL_PROFI

4、LES to FALSE.D. Set the SQLTUNE_CATEGORY parameter to DEFAULT for the databaseinstance. Answer: C使用DBMS_SQLTUNE包进行SQL优化，大致可以分为四个步骤： 创建优化任务 执行优化任务 显示优化任务的结果按照建议执行39.View the Exhibit to examine the Automatic SQL Tuning result details. Whichaction would you suggest for the selected SQL statement in the Exhibit?A. Accept the recommended SQL profile.B. Collect statistics for the related objects.C. Run the Access Advisor for the SQL statement.D. Run the Segment Advisor for recommendations.Answer: C40.

5、Evaluate the following code: SQLVARIABLE task_name VARCHAR2(255);SQLVARIABLE sql_stmt VARCHAR2(4000);SQLBEGIN: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 templat

6、e has not been created.D. It produces an error because the SQL Tuning Set has not been created.Answer: A40.手工生成SQL Access Advisor 示例2、Quick TuneIf you just wantto tune an individual statement you can use the QUICK_TUNEprocedureas follows.-如果仅仅是调整一个独立的语句，可以使用QUICK_TUNE过程：BEGINDBMS_ADVISOR.quick_tune(advisor_name = DBMS_ADVISOR.SQLACCESS_ADVISOR,task_name =emp_quick_tune, attr1 = SELECT e.*FROM emp e WHERE UPPER(e.ename) = SMITH);END;41.You have applications that have frequently executed queries,

7、and producesmall and static result sets. Yo u configure the sqlnet.ora file in the clientmachine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZEparameter.What is the purpose of this configuration?A. to avoid round trips to the server by enabling caching of query results inclient memoryB. to improve performance by storing a copy of the data from the private SQLarea of the PGAC. to enhance the query performance by creating a cache in the clientmemory for sorting operationsD. to avoid the

8、storing of query plans and results in the server by creating acache in the client memoryAnswer: A 题意： 您有经常执行查询的应用程序，并产生小的和静态的结果集。你的sqlnet.ora配置文件在客户机设置为非零值oci_result_cache_max_size参数配置的目的是：A.通过启用缓存在客户端内存中的查询结果，以避免到服务器的往返OCI 客户机查询高速缓存在Oracle Database11g 中，可以使用Oracle 调用接口(OCI) 客户机查询高速缓存对客 户机内存中的查询结果集启用高速缓存。高速缓存结果集数据以透明方式与服务器端上的所有更改保持一致。由于高速缓存中保存有相应信息，因此利用此功能的应用程序会提高查询的性能。此外，使用高速缓存的查询可避免在发送查询和获取结果时在客户机和服务器之间进行往返。处理查询所用的服务器CPU 会减少，从而提高了服务器的可扩展性。在使用客户端查询高速缓存之前，请确定应用程序是否会受益于此功能。当您的应用程序生成重复的结果集、小型结果集、静

9、态结果集或频繁执行的查询时，客户端高速缓存非常有用。客户机和服务器结果高速缓存是独立的，可独立启用或禁用它们。注：可以使用client_result_cache_stats$视图或v$client_result_cache_stats 视图来监 视客户机查询高速缓存。使用客户端缓存优点如下：(1) 将服务器端查询高速缓存扩展到客户端内存(2) 通过消除客户机与服务器之间的往返可以提高性能(3) 利用客户端内存(4) 通过节省服务器CPU 资源提高服务器的可扩展性(5) 服务器上的结果集发生更改时会自动刷新结果高速缓存(6) 尤其适用于查找表使用客户端查询高速缓存可通过以下方式使用客户端查询高速缓存： 设置初始化参数 CLIENT_RESULT_CACHE_SIZE CLIENT_RESULT_CACHE_LAG 使用客户机配置文件 OCI_RESULT_CACHE_MAX_SIZE OCI_RESULT_CACHE_MAX_RSET_SIZE OCI_RESULT_CACHE_MAX_RSET_ROWSCLIENT_RESULT_CACHE_SIZE ：非零值表示启用客户机结果高速缓存。这是客户机每个进程的结果集高速缓存的最大大小（以字节表示）。所有OCI 客户机进程都可达到此最大值，可以使用OCI_RESULT_CACHE_MAX_SIZE参数覆盖此值。CLIENT_RESULT_CACHE_LAG ：自客户机与服务器之间的最后一次往返后的最长时间（以毫秒为单位），在此之前OCI 客户机查询执行一次往返以获得与在客户机上高速缓存的查询相关的所有数据库更改。客户机配置文件是可选的，并且可覆盖服务器初始化参数文件中的高速缓存参 数集。参数值可以包含于sqlnet.ora 文件中。42.You plan to use SQL Performan

《CUUG内部OCP题库解析-053-文档5》由会员j***分享，可在线阅读，更多相关《CUUG内部OCP题库解析-053-文档5》请在金锄头文库上搜索。