网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
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.
考题
Which two are attributes of ／SQL*Plus? ()
A. /SQL*Plus commands cannot be abbreviated.B. /SQL*Plus commands are accesses from a browser.C. /SQL*Plus commands are used to manipulate data in tables.D. /SQL*Plus commands manipulate table definitions in the database.E. /SQL*Plus is the Oracle proprietary interface for executing SQL statements.
考题
Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()
A.B.C.D.
考题
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 PeekingB、SQL Plan BaselinesC、Adaptive Cursor SharingD、Bind variable used in a SQL statementE、Literals in a SQL statement
考题
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.
考题
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.
考题
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（） A、 The SGA Tuning AdvisorB、 The SQL Access AdvisorC、 The SQL Tuning AdvisorD、 The Memory Advisor
考题
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 AdvisorB、SQL OptimizerC、SQL Access AdvisorD、SQL Tuning Advisor
考题
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 userB、An existing SQL Tuning Set (STS)C、A preprocessed Database Replay workloadD、A schema nameE、SQL statement identified in EM as using excessive resources
考题
Which of the following cannot be used as input to the SQL Tuning Advisor？（）A、 A single SQL statement provided by a userB、 An existing SQL Tuning Set （STS）C、 A preprocessed Database Replay workloadD、 A schema nameE、 SQL statement identified in EM as using excessive resources
考题
Which two are attributes of iSQL*Plus? （）A、/SQL*Plus commands cannot be abbreviated.B、/SQL*Plus commands are accessed from a browser.C、/SQL*Plus commands are used to manipulate data in tables.D、/SQL*Plus commands manipulate table definitions in the database.E、/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
考题
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.
考题
Examine the following PL/SQL block： SET SERVEROUTPUT ON SET LONG 10000 ECLARE report clob； BEGIN report ：= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE（）； DBMS_OUTPUT.PUT_LINE（report）； END； 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.
考题
Which two are attributes of /SQL*Plus? （）A、/SQL*Plus commands cannot be abbreviated.B、/SQL*Plus commands are accesses from a browser.C、/SQL*Plus commands are used to manipulate data in tables.D、/SQL*Plus commands manipulate table definitions in the database.E、/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
考题
单选题Which /SQL*Plus feature can be used to replace values in the WHERE clause?（）A
Substitution variablesB
Replacement variablesC
Prompt variablesD
Instead-of variablesE
This feature cannot be implemented through /SQL*Plus
考题
多选题Which two are attributes of /SQL*Plus? （）A/SQL*Plus commands cannot be abbreviated.B/SQL*Plus commands are accesses from a browser.C/SQL*Plus commands are used to manipulate data in tables.D/SQL*Plus commands manipulate table definitions in the database.E/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
考题
多选题Which two are attributes of iSQL*Plus? （）A/SQL*Plus commands cannot be abbreviated.B/SQL*Plus commands are accessed from a browser.C/SQL*Plus commands are used to manipulate data in tables.D/SQL*Plus commands manipulate table definitions in the database.E/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
考题
单选题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.
考题
单选题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 AdvisorB
SQL OptimizerC
SQL Access AdvisorD
SQL Tuning Advisor
考题
多选题Which two statements are true regarding the SQL Repair Advisor?（）AThe SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.BThe SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.CThe SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.DThe 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.
考题
单选题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.
考题
单选题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.
考题
单选题Which /SQL*Plus feature can be used to replace values in the WHERE clause?（）A
Substitution variablesB
Replacement variablesC
Prompt variablesD
Instead-of variablesE
This feature cannot be implemented through /SQL*Plus.
考题
单选题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.
考题
单选题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.
考题
多选题From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.AUpdatingBViewingCDeletingDInsertingETruncating
热门标签
最新试卷
