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 Advisor
  • B、 The SQL Access Advisor
  • C、 The SQL Tuning Advisor
  • D、 The Memory Advisor
相似考题

1.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

2.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

3. 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

4.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

参考答案和解析
正确答案:C
更多“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”相关问题

  • 第1题：

    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 Advisor
    • B、Segment Advisor
    • C、SQL Tuning Advisor
    • D、SQL Access Advisor
    • E、Automatic Database Diagnostic Monitor （ADDM）

    正确答案:A

  • 第2题：

    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 Advisor
    • B、 Segment Advisor
    • C、 Undo Advisor
    • D、 SQL Tuning Advisor

    正确答案:C

  • 第3题：

    Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature？（）  

    • A、 Segment Advisor
    • B、 SQL Access Advisor
    • C、 Undo Advisor
    • D、 SQL Tuning Advisor

    正确答案:B

  • 第4题：

    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 Advisor
    • B、 Memory Advisor
    • C、SQL Tuning Advisor
    • D、 Segment Advisor

    正确答案:A

  • 第5题：

    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 Advisor
    • B、 EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor
    • C、 EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor
    • D、 Either B or C
    • E、 All of the above

    正确答案:D

  • 第6题：

    Which of the following cannot be used as input to the SQL Tuning Advisor？（）

    • 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

    正确答案:C,D

  • 第7题：

    单选题
    Which of the following advisors is run in every maintenance window by the auto-task system?（）
    A

    The Memory Advisor

    B

    The SQL Tuning Advisor

    C

    The Undo Advisor

    D

    The SQL Access Advisor


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    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 Advisor

    B

     Undo Advisor

    C

     Segment Advisor

    D

     SQL Tuning Advisor


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    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 Advisor

    B

     Segment Advisor

    C

     SQL Tuning Advisor

    D

     SQL Access Advisor

    E

     Automatic Database Diagnostic Monitor （ADDM）


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    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 Advisor

    B

     EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor

    C

     EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor

    D

     Either B or C

    E

     All of the above


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature？（）
    A

     Segment Advisor

    B

     SQL Access Advisor

    C

     Undo Advisor

    D

     SQL Tuning Advisor


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第13题：

    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 Advisor
    • B、 Undo Advisor
    • C、 ADDM
    • D、 Memory Advisor

    正确答案:D

  • 第14题：

    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

    正确答案:D

  • 第15题：

    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

    正确答案:C,D

  • 第16题：

    Which tasks are run automatically as part of the Automated Maintenance Task by default？（） 

    • A、 Segment Advisor
    • B、 SQL Access Advisor
    • C、 Optimizer statistics gathering
    • D、 Automatic SQL Tuning Advisor
    • E、 Automatic Database Diagnostics Monitor

    正确答案:A,C,D

  • 第17题：

    Which of the following advisors is run in every maintenance window by the auto-task system?（）

    • A、The Memory Advisor
    • B、The SQL Tuning Advisor
    • C、The Undo Advisor
    • D、The SQL Access Advisor

    正确答案:B

  • 第18题：

    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 Advisor
    • C、The Segment Advisor
    • D、The SQL Access Advisor

    正确答案:D

  • 第19题：

    单选题
    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 Advisor

    C

     The Segment Advisor

    D

     The SQL Access Advisor


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    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 Advisor

    B

     Segment Advisor

    C

     Undo Advisor

    D

     SQL Tuning Advisor


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    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 Advisor

    B

     Undo Advisor

    C

     ADDM

    D

     Memory Advisor


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

相关内容