Oracle OCP 1Z0-050(26题)解析
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Oracle OCP 1Z0-050(26题)解析,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2489字,纯文字阅读大概需要4分钟。
内容图文
![Oracle OCP 1Z0-050(26题)解析](/upload/InfoBanner/zyjiaocheng/922/23f689c59e554a27b6ac1df2ac2f4e7a.jpg)
Oracle OCP 1Z0-050(26题)解析
QUESTION 26:
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.SQL ACCESS_ADVISOR, :task_name, :sql_stmt);
END;
What is the outcome of this block of code?
A. It creates a task and workload but does not execute the task.
B. It produces an error because the SQL Tuning Set has not been created.
C. It produces an error because a template has not been created.
D. It creates a task and workload, and executes the task.
Answer: D
解析:
参考Oracle官方文档:
https://docs.oracle.com/cd/E11882_01/server.112/e41573/advisor.htm#PFGRF94918
Using SQL Access Advisor in Enterprise Manager or API, you can do the following:
-
Recommend materialized views and indexes based on collected, user-supplied, or hypothetical workload information.
-
Recommend partitioning of tables, indexes, and materialized views.
-
Mark, update, and remove recommendations.
In addition, you can use SQL Access Advisor API to do the following:
-
Perform a quick tune using a single SQL statement.
-
Show how to make a materialized view fast refreshable.
-
Show how to change a materialized view so that general query rewrite is possible.
To tune a single SQL statement, the QUICK_TUNE
procedure accepts as its input a task_name
and a SQL statement. The procedure creates a task and workload and executes this task. There is no difference in the results from using QUICK_TUNE
. They are exactly the same as those from using EXECUTE_TASK
, but this approach is easier to use when there is only a single SQL statement to be tuned. The syntax is as follows:
DBMS_ADVISOR.QUICK_TUNE (
advisor_name IN VARCHAR2,
task_name IN VARCHAR2,
attr1 IN CLOB,
attr2 IN VARCHAR2 := NULL,
attr3 IN NUMBER := NULL,
task_or_template IN VARCHAR2 := NULL);
The following example shows how to quick tune a single SQL statement:
VARIABLE task_name VARCHAR2(255);
VARIABLE sql_stmt VARCHAR2(4000);
EXECUTE :sql_stmt := 'SELECT COUNT(*) FROM customers
WHERE cust_state_province =''CA''';
EXECUTE :task_name := 'MY_QUICKTUNE_TASK';
EXECUTE DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR,
:task_name, :sql_stmt);
See Oracle Database PL/SQL Packages and Types Reference for more information regarding the QUICK_TUNE
procedure and its parameters.
内容总结
以上是互联网集市为您收集整理的Oracle OCP 1Z0-050(26题)解析全部内容,希望文章能够帮你解决Oracle OCP 1Z0-050(26题)解析所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。