网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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 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 is run in every maintenance window by the auto－task system?()
A. The Memory AdvisorB. The SQL Tuning AdvisorC. The Undo AdvisorD. The SQL Access Advisor
考题
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）A、The Automatic Memory Manager (AMM)B、The SQL Tuning AdvisorC、The Segment AdvisorD、The SQL Access Advisor SQL
考题
You accepted the recommended SQL Profile by executing the following code： DECLARE sqlprofile_name varchar2（30）； BEGIN sqlprofile_name ：= DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（ task_name = ’my_task’， profile_name = ’my_profile’）； END； Which advisor will analyze this profile？（） A、 SQL Access AdvisorB、 Undo AdvisorC、 Segment AdvisorD、 SQL Tuning Advisor
考题
You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（） A、Memory AdvisorB、Segment AdvisorC、SQL Tuning AdvisorD、SQL Access AdvisorE、Automatic Database Diagnostic Monitor （ADDM）
考题
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
考题
You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）A、 SQL Tuning AdvisorB、 Undo AdvisorC、 ADDMD、 Memory Advisor
考题
While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）A、 Memory AdvisorB、 Segment AdvisorC、 Undo AdvisorD、 SQL Tuning 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 tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature？（） A、 Segment AdvisorB、 SQL Access AdvisorC、 Undo AdvisorD、 SQL Tuning Advisor
考题
You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（） A、SQL Access AdvisorB、 Memory AdvisorC、SQL Tuning AdvisorD、 Segment Advisor
考题
Which tasks are run automatically as part of the Automated Maintenance Task by default？（） A、 Segment AdvisorB、 SQL Access AdvisorC、 Optimizer statistics gatheringD、 Automatic SQL Tuning AdvisorE、 Automatic Database Diagnostics Monitor
考题
To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（） A、 EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning AdvisorB、 EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning AdvisorC、 EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning AdvisorD、 Either B or CE、 All of the above
考题
Which of the following advisors is run in every maintenance window by the auto-task system?（）A、The Memory AdvisorB、The SQL Tuning AdvisorC、The Undo AdvisorD、The SQL Access Advisor
考题
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
考题
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）A、The Automatic Memory Manager (AMM)B、The SQL Tuning AdvisorC、The Segment AdvisorD、The SQL Access Advisor
考题
单选题Which of the following advisors is run in every maintenance window by the auto-task system?（）A
The Memory AdvisorB
The SQL Tuning AdvisorC
The Undo AdvisorD
The SQL Access Advisor
考题
单选题You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table？（）A
The Automatic Memory Manager （AMM）B
The SQL Tuning AdvisorC
The Segment AdvisorD
The SQL Access Advisor
考题
单选题You accepted the recommended SQL Profile by executing the following code： DECLARE sqlprofile_name varchar2（30）； BEGIN sqlprofile_name ：= DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（ task_name = ’my_task’， profile_name = ’my_profile’）； END； Which advisor will analyze this profile？（）A
SQL Access AdvisorB
Undo AdvisorC
Segment AdvisorD
SQL Tuning 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 SQL
考题
单选题While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）A
Memory AdvisorB
Segment AdvisorC
Undo AdvisorD
SQL Tuning Advisor
考题
单选题You observe that a database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine that required size of the database buffer cache？ （）A
Memory AdvisorB
Segment AdvisorC
SQL Tuning AdvisorD
SQL Access AdvisorE
Automatic Database Diagnostic Monitor （ADDM）
考题
单选题You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）A
SQL Tuning AdvisorB
Undo AdvisorC
ADDMD
Memory Advisor
考题
单选题To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（）A
EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning AdvisorB
EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning AdvisorC
EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning AdvisorD
Either B or CE
All of the above
考题
单选题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 tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature？（）A
Segment AdvisorB
SQL Access AdvisorC
Undo AdvisorD
SQL Tuning Advisor
考题
单选题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 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
热门标签
最新试卷