题目内容（请给出正确答案）

[主观题]

Which statement correctly describes SQL and /SQL*Plus？（）

A. Both SQL and /SQL*plus allow manipulation of values in the database.

B. /SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.

C. /SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.

D. /SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装赏学吧APP，拍照搜题省时又省心！

更多“Which statement correctly desc…”相关的问题

第1题

Which statement correctly describes SQL and /SQL*Plus？（）

A. Both SQL and /SQL*plus allow manipulation of values in the database.

B. /SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.

C. /SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.

D. /SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.

点击查看答案

第2题

You run the SQL Tuning Advisor （STA) to tune a SQL statement that is part of a fixed SQL p

You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile？（）

A. The tuned plan is not added to the SQL plan baseline.

B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.

C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.

D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

点击查看答案

第3题

Which statement describes the effect of the execution of the above PL/SQL block？（）

A. The plan baselines are verified with the SQL profiles.

B. All fixed plan baselines are converted into nonfixed plan baselines.

C. All the nonaccepted SQL profiles are accepted into the plan baseline.

D. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.

点击查看答案

第4题

A．

B．

C．

D．

点击查看答案

第5题

Which statement most accurately describes the implementation of a SQL Access Advisor recommendation？（）

A. SQL Access Advisor recommendations are automatically implemented.

B. Individual SQL Access Advisor recommendations can be scheduled for implementation.

C. All SQL Access Advisor recommendations for a specific task must be implemented at the same time.

D. SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.

E. None of the above.

点击查看答案

第6题

Which three features work together, to allow a SQL statement to have different cursors for the samestatement based on different selectivity ranges？（）

A. Bind Variable Peeking

B. SQL Plan Baselines

C. Adaptive Cursor Sharing

D. Bind variable used in a SQL statement

E. Literals in a SQL statement

点击查看答案

第7题

Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement？（）

A. SQL Repair Advisor

B. SQL Optimizer

C. SQL Access Advisor

D. SQL Tuning Advisor

点击查看答案

第8题

Which of the following cannot be used as input to the SQL Tuning Advisor？（）（Choose all that apply.)

A. A single SQL statement provided by a user

B. An existing SQL Tuning Set (STS)

C. A preprocessed Database Replay workload

D. A schema name

E. SQL statement identified in EM as using excessive resources

点击查看答案

第9题

Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）

A. The SGA Tuning Advisor

B. The SQL Access Advisor

C. The SQL Tuning Advisor

D. The Memory Advisor

点击查看答案

第10题

Which two statements are true regarding the SQL Repair Advisor？（）

A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.

B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.

C. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.

D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

点击查看答案