Which tuning tool

题目

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
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Which tool is based on the AIX trace facility?()

  • A、 no
  • B、 netpmon
  • C、 entstat
  • D、 nfso

正确答案:B

第2题:

Which tool is used to correctly size an IBM virtual tape solution?()

  • A、System Planning Tool (SPT) 
  • B、Tape Magic 
  • C、Capacity Magic 
  • D、TS3500 Slot Calculator

正确答案:B

第3题:

To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?()

A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.

B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.

C. From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.

D. Either B or C


参考答案:A

第4题:

You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set?()

  • A、 DBMS_WORKLOAD_REPOSITORY
  • B、 DBMS_RESOURCE_MANAGER
  • C、 DBMS_SQLTUNE
  • D、 DBMS_ADVISOR

正确答案:C

第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 IBM Resource would best help you determine the proper performance tuning of your System x hardware and the application workload of the software?()

  • A、xREF Sheets
  • B、IBM Sizing Guides
  • C、Configuration & Options Guide - (COG)
  • D、Standalone Solutions Configuration Tool (SSCT)

正确答案:B

第7题:

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

第8题:

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

第9题:

Which component does the SQL Tuning Advisor NOT analyze for the SQL statements?()  

  • A、ADDM
  • B、AWR
  • C、Cursor Cache
  • D、SQL Tuning Sets
  • E、Flash Recovery Area

正确答案:E

第10题:

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

更多相关问题