网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “ 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 memoryB、Add a processorC、Add a faster disk subsystemD、Exchange the processor with a faster processor” 相关考题
考题
You executed the following commands: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.
考题
Which three statements are true about SQL plan directives?()
A. They are tied to a specific statement or SQL id.B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.C. They are used to gather only missing statistics.D. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.E. They instruct the optimizer to create only column group statistics.F. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.
考题
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.
考题
在sqlserver数据库中,通过哪条语句可以检查查询使用的时间和CPU使用情况?()
A.使用set statistics io语句B.使用set statistics time语句C.使用set statistics CPU语句D.使用set statistics time and CPU语句
考题
Which command sequence displays queue statistics for an interface?()
A.monitor interface ge-0/0/0 queueB.show interfaces queue ge-0/0/0C.show interfaces ge-0/0/0 statistics extensiveD.show statistics queue detail
考题
交叉分组下频数分析应选择的菜单是（）A、Analyze→Descriptive Statistics→FrequenciesB、Analyze→Descriptive Statistics→DescriptivesC、Analyze→Descriptive Statistics→CrosstabsD、Analyze→Descriptive Statistics→Ratio
考题
比率分析应当选择的操作菜单是（）A、Analyze→Descriptive Statistics→FrequenciesB、Analyze→Descriptive Statistics→DescriptivesC、Analyze→Descriptive Statistics→CrosstabsD、Analyze→Descriptive Statistics→Ratio
考题
All of the following types of statistics are reported by the iostat command tool EXCEPT:（）.A、 Free memoryB、 CPU statistics C、 Disk statistics D、 Terminal statistics
考题
While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）A、It updates the existing SQL profiles with current statisticsB、It makes the statistics information available to GATHER_STATS_JOBC、It initiates the statistics collection process by running GATHER_STATS_JOBD、It logs a warning message in the alert log so that the DBA can perform statistics collection manually
考题
在sqlserver数据库中，通过哪条语句可以检查查询使用的时间和CPU使用情况？（）A、使用set statistics io语句B、使用set statistics time语句C、使用set statistics CPU语句D、使用set statistics time and CPU语句
考题
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
考题
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.
考题
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
考题
While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）A、It updates the existing SQL profiles with current statistics.B、It makes the statistics information available to GATHER_STATS_JOBC、It initiates the statistics collection process by running GATHER_STATS_JOBD、It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
考题
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.
考题
单选题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.
考题
单选题You need to design the retrieval of advertising statistics without compromising security. What should you do?（）A
Design a Notification Services solution that sends the advertising statistics to specified subscribers by e-mail.B
Design a SQL Server Web service that runs a stored procedure to return the statistics on a call from the advertisers application.C
Design a Database Mail solution that sends the advertising statistics to e-mail addresses that are specified in a table.D
Design a stored procedure to return the statistics on a call from the advertisers application.E
Design a user-defined function to return the statistics on a call from the advertisers application.
考题
单选题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
考题
单选题在sqlserver数据库中，通过哪条语句可以检查查询使用的时间和CPU使用情况？（）A
使用set statistics io语句B
使用set statistics time语句C
使用set statistics CPU语句D
使用set statistics time and CPU语句
考题
多选题Which three statements are true about SQL plan directives?（）AThey are tied to a specific statement or SQL id.BThey instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.CThey are used to gather only missing statistics.DThey are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.EThey instruct the optimizer to create only column group statistics.FImprove plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.
考题
单选题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.
考题
单选题Which command sequence displays queue statistics for an interface?（）A
monitor interface ge-0/0/0 queueB
show interfaces queue ge-0/0/0C
show interfaces ge-0/0/0 statistics extensiveD
show statistics queue detail
考题
单选题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
考题
单选题All of the following types of statistics are reported by the iostat command tool EXCEPT:（）.A
Free memoryB
CPU statistics C
Disk statistics D
Terminal statistics
考题
单选题While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）A
It updates the existing SQL profiles with current statistics.B
It makes the statistics information available to GATHER_STATS_JOBC
It initiates the statistics collection process by running GATHER_STATS_JOBD
It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
考题
单选题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.
考题
单选题While tuning a SQL statement， the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation？（）A
It updates the existing SQL profiles with current statisticsB
It makes the statistics information available to GATHER_STATS_JOBC
It initiates the statistics collection process by running GATHER_STATS_JOBD
It logs a warning message in the alert log so that the DBA can perform statistics collection manually
热门标签
最新试卷
