单选题Which of the following is a potential performance tuning recommendation from the SQL Access Advisor？（）ACreate new indexes.BModify existing indexes.CImplement partitioning on a nonpartitioned table.DCreate materialized views.EAll of the above

题目
单选题
Which of the following is a potential performance tuning recommendation from the SQL Access Advisor？（）
A

 Create new indexes.

B

 Modify existing indexes.

C

 Implement partitioning on a nonpartitioned table.

D

 Create materialized views.

E

 All of the above

相似考题

1.Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?()A. Create new indexes.B. Modify existing indexes.C. Implement partitioning on a nonpartitioned table.D. Create materialized views.E. All of the above

2.Which of the following is a performance optimization technology?()A.QoSB.TrunkingC.SpanningD.VoIP

3.Which of the following commands should be used to reset the Virtual Memory Manager tuning parameters to their default values？（）A、 schedtune -tB、 vmtune -RC、 schedtune -rD、 schedtune -D

4.Which of the following protocols should be used to monitor network performance?()A.SNTPB.SMTPC.HTTPD.SNMP

更多“Which of the following is a potential performance tuning rec”相关问题

  • 第1题：

    Using the following information: Performance data from an existing system that a new system will replace; Performance estimates that anticipate future workloads; Micro-partitioning and logical partitioning implementations. Which of the following allows a technical sales representative to create a system design which can be imported into an HMC?（）

    • A、IBMeConfig
    • B、IBM Performance Monitor
    • C、IBM Workload Estimator (WLE)
    • D、IBM System Planning Tool (SPT)

    正确答案:D

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

    正确答案:D

  • 第3题：

    Which of the following would be considered reasonable network maintenance tasks？（Choose allthat apply.）（）

    • A、Ensuring compliance with legal regulations and corporate policies
    • B、Troubleshooting problem reports
    • C、Planning for network expansion
    • D、Providing support to sales and marketing
    • E、Giving presentations to management
    • F、Monitoring and tuning network performance

    正确答案:A,B,C,F

  • 第4题：

    Which of the following are potential sources of EMI?（）

    • A、Strong magnets
    • B、Toaster ovens
    • C、Cordless phones
    • D、Flat panel TVs
    • E、AC power runs

    正确答案:A,E

  • 第5题：

    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

  • 第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 are potential sources of EMI?（）
    A

    Strong magnets

    B

    Toaster ovens

    C

    Cordless phones

    D

    Flat panel TVs

    E

    AC power runs


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

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    单选题
    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
    解析： 暂无解析

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

    单选题
    Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?（）
    A

    Create new indexes.

    B

    Modify existing indexes.

    C

    Implement partitioning on a nonpartitioned table.

    D

    Create materialized views.

    E

    All of the above


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

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    Which of the following commands should be used to view and change the network filesystem tuning parameters available on the system？（）

    • A、 no
    • B、 nfso
    • C、 vmtune
    • D、 exportfs

    正确答案:B

  • 第14题：

    Which of the following technologies has the HIGHEST potential throughput?（）

    • A、DSL
    • B、Fiber
    • C、Satellite
    • D、Cable

    正确答案:B

  • 第15题：

    Which of the following is a performance optimization technology?（）

    • A、QoS
    • B、Trunking
    • C、Spanning
    • D、VoIP

    正确答案:A

  • 第16题：

    Which of the following protocols should be used to monitor network performance?（）

    • A、SNTP
    • B、SMTP
    • C、HTTP
    • D、SNMP

    正确答案:D

  • 第17题：

    Which of the following is a potential performance tuning recommendation from the SQL Access Advisor？（）  

    • A、 Create new indexes.
    • B、 Modify existing indexes.
    • C、 Implement partitioning on a nonpartitioned table.
    • D、 Create materialized views.
    • E、 All of the above

    正确答案:E

  • 第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 SQL


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

  • 第20题：

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


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

  • 第21题：

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


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

  • 第22题：

    多选题
    Which of the following would be considered reasonable network maintenance tasks？（Choose allthat apply.）（）
    A

    Ensuring compliance with legal regulations and corporate policies

    B

    Troubleshooting problem reports

    C

    Planning for network expansion

    D

    Providing support to sales and marketing

    E

    Giving presentations to management

    F

    Monitoring and tuning network performance


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

  • 第23题：

    单选题
    Which of the following is a potential performance tuning recommendation from the SQL Access Advisor？（）
    A

     Create new indexes.

    B

     Modify existing indexes.

    C

     Implement partitioning on a nonpartitioned table.

    D

     Create materialized views.

    E

     All of the above


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

  • 第24题：

    单选题
    Which of the following commands should be used to view and change the network filesystem tuning parameters available on the system？（）
    A

     no

    B

     nfso

    C

     vmtune

    D

     exportfs


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

相关内容