单选题All of the following types of statistics are reported by the iostat command tool EXCEPT:（）.AFree memoryBCPU statistics CDisk statistics DTerminal statistics

第1题：

比率分析应当选择的操作菜单是（）

• A、Analyze→Descriptive Statistics→Frequencies
• B、Analyze→Descriptive Statistics→Descriptives
• C、Analyze→Descriptive Statistics→Crosstabs
• D、Analyze→Descriptive Statistics→Ratio

第2题：

在sqlserver数据库中，通过哪条语句可以检查查询使用的时间和CPU使用情况？（）

• A、使用set statistics io语句
• B、使用set statistics time语句
• C、使用set statistics CPU语句
• D、使用set statistics time and CPU语句

第3题：

The statistics for a poorly performing x366 system are as follows：      （1）Processor： 90% for 5 second increments   （2）Memory page faults： 20/second average over 15 minutes      （3）Disk： disk time 1%  Which of the following will provide the greatest performance improvement？（）

• A、Add memory
• B、Add a processor
• C、Add a faster disk subsystem
• D、Exchange the processor with a faster processor

第4题：

Examine the command： SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）；  Which statementdescribes the effect of the above command（）

• A、Automatic statistics collection is stopped for the CUSTOMERS table.
• B、Statistics for the CUSTOMERS table are locked and cannot be overwritten.
• C、Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
• D、Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics

第5题：

Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）

• A、Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
• B、Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
• C、Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
• D、Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
• E、Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

第6题：

Examine the command：  SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）； Which statement describes the effect of the above command（）

• A、Automatic statistics collection is stopped for the CUSTOMERS table.
• B、Statistics for the CUSTOMERS table are locked and cannot be overwritten.
• C、Existing statistics for the CUSTOMERS table become unusable for the query optimizer.
• D、Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

All of the following types of statistics are reported by the iostat command tool EXCEPT:（）.

• A、 Free memory
• B、 CPU statistics 
• C、 Disk statistics 
• D、 Terminal statistics

第14题：

The WebSphere Application Server provides a Dynamic Cache Monitor.  Which of the following can be monitored using this tool？（）

• A、Servlet Response Times
• B、Cache Statistics
• C、Database Connection Pool Statistics
• D、Disk Statistics

第15题：

Which command sequence displays queue statistics for an interface?（）

• A、monitor interface ge-0/0/0 queue
• B、show interfaces queue ge-0/0/0
• C、show interfaces ge-0/0/0 statistics extensive
• D、show statistics queue detail

第16题：

You executed the following commands：   SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false； SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’，’false’）； SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS（’SH’， ’CUSTOMERS’）；   Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session？（）

• A、 The statistics are stored in the pending statistics table in the data dictionary.
• B、 The statistics are treated as the current statistics by the optimizer for all sessions.
• C、 The statistics are treated as the current statistics by the optimizer for the current sessions only.
• D、 The statistics are temporary and used by the optimizer for all sessions until this session terminates.

第17题：

The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor all objects.  Which statement is true in this scenario（）

• A、The statistics collection continues until all objects are processed.
• B、The job is terminated and the statistics collected are restored to a time before the job started.
• C、This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.
• D、The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened

第18题：

The job to gather optimizer statistics for objects runs as part of the automatic maintenance window inyour database instance. At a certain point of time， the maintenance window closes before the statisticsare gathered for all objects.  Which statement is true in this scenario（）

• A、The statistics collection continues until all objects are processed.
• B、The job is terminated and the statistics collected are restored to a time before the job started.
• C、This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.
• D、The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：