网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
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
参考答案
参考解析
解析:
暂无解析
更多 “单选题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 three functions are performed by the SQL Tuning Advisor? ()
A. Building the SQL profileB. Recommending optimization of materialized viewsC. Checking query objects for missing and stale statisticsD. Recommending bitmap, function-based, and B-tree indexesE. Recommending restructuring SQL queries that are using bad plans
考题
In Oracle 11g, which recommendations does the SQL Access Advisor generate?()
A. partitioning recommendationsB. statistics collection recommendationsC. index creation recommendationsD. materialized view recommendationsE. materialized view log recommendations
考题
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
考题
In Oracle 11g, which recommendations does the SQL Access Advisor generate? ()(Choose all that apply.)
A. partitioning recommendationsB. statistics collection recommendationsC. index creation recommendationsD. materialized view recommendationsE. materialized view log recommendations
考题
Which three functions are performed by the SQL Tuning Advisor?() (Choose three.)
A. Building the SQL profileB. Recommending optimization of materialized viewsC. Checking query objects for missing and stale statisticsD. Recommending bitmap, function-based, and B-tree indexesE. Recommending restructuring SQL queries that are using bad plans
考题
Which three functions are performed by the SQL Tuning Advisor?() (Choose three.)A、Building the SQL profileB、Recommending optimization of materialized viewsC、Checking query objects for missing and stale statisticsD、Recommending bitmap, function-based, and B-tree indexesE、Recommending restructuring SQL queries that are using bad plans
考题
Which three functions are performed by the SQL Tuning Advisor?()A、Building and implementing SQL profilesB、Recommending the optimization of materialized viewsC、Checking query objects for missing and stale statisticsD、Recommending bitmap, function-based, and B-tree indexesE、Recommending the restructuring of SQL queries that are using bad plans
考题
Which of the following would BEST optimize a computer that is heavily used? ()A、ScandiskB、DefragC、IndexingD、Chkdsk
考题
The Chief Information Officer (CIO) is preparing a briefing about the reliability of their server environment. There is a need to create a report about which systems had unplanned system outages and how often they occurred. What IBM Director tool can be used to create the report?()A、Capacity ManagerB、Process Management toolC、System Availability toolD、System Reporting tool
考题
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 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 component does the SQL Tuning Advisor NOT analyze for the SQL statements?() A、ADDMB、AWRC、Cursor CacheD、SQL Tuning SetsE、Flash Recovery Area
考题
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
考题
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
考题
In Oracle 11g, which recommendations does the SQL Access Advisor generate?() A、 partitioning recommendationsB、 statistics collection recommendationsC、 index creation recommendationsD、 materialized view recommendationsE、 materialized view log recommendations
考题
In Oracle 11g, which recommendations does the SQL Access Advisor generate? ()(Choose all that apply.)A、partitioning recommendationsB、statistics collection recommendationsC、index creation recommendationsD、materialized view recommendationsE、materialized view log recommendations
考题
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 tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?()A
Set the BACKUP_TAPE_IO_SLAVES parameter to FALSEB
Set the BACKUP_TAPE_IO_SLAVES parameter to TRUEC
Use compression when performing tape backupsD
Configure multiple SBT channels
考题
单选题A customer is running system management software on one of their Windows xSeries servers, and the software seems to slow down their database application over time. The customer is running IBM Director in their environment. Which IBM Director tool can they utilize to guarantee processor time for the different applications and optimize the server performance?()A
Software RejuvenationB
Capacity ManagerC
Capacity Workload ManagerD
Aurema Application Workload Manager
考题
多选题Which three functions are performed by the SQL Tuning Advisor?() (Choose three.)ABuilding the SQL profileBRecommending optimization of materialized viewsCChecking query objects for missing and stale statisticsDRecommending bitmap, function-based, and B-tree indexesERecommending restructuring SQL queries that are using bad plans
考题
单选题You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups.Which action should you take?()A
Set the BACKUP_TAPE_IO_SLAVES parameter to FALSEB
Set the BACKUP_TAPE_IO_SLAVES parameter to TRUEC
Use compression when performing tape backupsD
Configure multiple SBT channels
考题
单选题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 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? ()A
You should use the Database Engine Tuning Advisor tool B
You should use the Windows System Monitor tool C
You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio D
You should use the Activity Monitor tool in Microsoft SQL Server Management Studio
考题
单选题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
考题
单选题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
考题
多选题Which three functions are performed by the SQL Tuning Advisor?()ABuilding the SQL profileBRecommending optimization of materialized viewsCChecking query objects for missing and stale statisticsDRecommending bitmap, function-based, and B-tree indexesERecommending restructuring SQL queries that are using bad plans
考题
单选题Which component does the SQL Tuning Advisor NOT analyze for the SQL statements?()A
ADDMB
AWRC
Cursor CacheD
SQL Tuning SetsE
Flash 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
热门标签
最新试卷