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 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
相关考题：
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
Which of the following commands should be used to view and change the network filesystem tuning parameters available on the system？（）A、 noB、 nfsoC、 vmtuneD、 exportfs
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 SheetsB、IBM Sizing GuidesC、Configuration Options Guide - （COG）D、Standalone Solutions Configuration Tool （SSCT）
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
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
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 component does the SQL Tuning Advisor NOT analyze for the SQL statements？（） A、ADDMB、AWRC、Cursor CacheD、SQL Tuning SetsE、Flash Recovery Area
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_REPOSITORYB、 DBMS_RESOURCE_MANAGERC、 DBMS_SQLTUNED、 DBMS_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
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 ResultsC、 From Advisor Central，choose SQL Advisors，Manual SQL Tuning Advisors，Tuning Task ResultsD、 Either B or C
You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？ （）A、Top SQLB、snapshotsC、SQL Tuning setsD、index access pathE、optimizer statisticsF、materialized view logs
单选题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_REPOSITORYB DBMS_RESOURCE_MANAGERC DBMS_SQLTUNED DBMS_ADVISOR
单选题Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?（）AThe SGA Tuning AdvisorBThe SQL Access AdvisorCThe SQL Tuning AdvisorDThe Memory Advisor
单选题The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）Astatistics recommendationsBSQL Profile recommendationsCIndex-related recommendationsDrestructuring of SQL recommendations
单选题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 tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）ASegment AdvisorBSQL Access AdvisorCUndo AdvisorDSQL Tuning Advisor
单选题To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?（）AFrom the Advisor Central home page, select the tuning task from the Advisor Tasks section.BFrom Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.CFrom Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.DEither B or C
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you have to verify whether the query is blocked. Which tool should you use? （）AYou should use the Database Engine Tuning Advisor tool BYou should use the Windows System Monitor tool CYou should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio DYou should use the Activity Monitor tool in Microsoft SQL Server Management Studio
单选题You need to recommend a tool to manage the SANs. The tool must support the company’s planned changes and technical requirements. Which tool should you recommend？（）ADisk ManagementBShare and Storage ManagementCStorage ExplorerDStorage Manager for SANs
单选题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
单选题You need to identify which tool the help desk users must use to perform administrative tasks. Which tool should you identify？（）ARemoteAppBRemote AssistanceCRemote DesktopDRemote Server Administration Tools （RSAT）
单选题Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）AADDMBAWRCCursor CacheDSQL Tuning SetsEFlash Recovery Area
单选题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 cannot be used as input to the SQL Tuning Advisor？（）AA single SQL statement provided by a userBAn existing SQL Tuning Set （STS）CA preprocessed Database Replay workloadDA schema nameESQL statement identified in EM as using excessive resources