网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
The statistics for a poorly performing， dual-processor x365 system are as follows： （1）Processor： 80% for 5-second increments （2）Memory page faults： 360/second average over 15 minutes （3）Disk % disk time： 100% Which of the following will provide the greatest performance improvement？（）
A
Add memory
B
Add a processor
C
Exchange the existing processor for a faster processor
D
Add a faster disk subsystem
参考答案
参考解析
解析：
暂无解析
更多 “单选题The statistics for a poorly performing， dual-processor x365 system are as follows： （1）Processor： 80% for 5-second increments （2）Memory page faults： 360/second average over 15 minutes （3）Disk % disk time： 100% Which of the following will provide the greatest performance improvement？（）A Add memoryB Add a processorC Exchange the existing processor for a faster processorD Add a faster disk subsystem” 相关考题
考题
You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?()
A. Compute the baseline statistics.B. Take an immediate AWR snapshot.C. Decrease the window size for the baseline.D. Decrease the expiration time for the baseline.
考题
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.
考题
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.
考题
交叉分组下频数分析应选择的菜单是（）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
考题
在sqlserver数据库中，通过哪条语句可以检查查询使用的时间和CPU使用情况？（）A、使用set statistics io语句B、使用set statistics time语句C、使用set statistics CPU语句D、使用set statistics time and CPU语句
考题
A 4-way x445 server with 2GB of memory running Windows 2003 Server with Exchange 2003 is performing poorly. Users are complaining of slow response times when accessing their email. Which subsystem should be checked first as a potential bottleneck？（）A、ProcessorsB、Memory subsystemC、Storage subsystemD、Network connectivity
考题
A system administrator has a server that is performing poorly. The vmstat command identifies that high CPU usage is the problem. Which of the following commands can be used to identify the eight most active processes running on the server？（）A、ps -ef -t8B、sar -u -p 8C、vmstat -t 8D、topas -p8 -n0 -d0
考题
The statistics for a poorly performing， dual-processor x365 system are as follows： （1）Processor： 80% for 5-second increments （2）Memory page faults： 360/second average over 15 minutes （3）Disk % disk time： 100% Which of the following will provide the greatest performance improvement？（）A、Add memoryB、Add a processorC、Exchange the existing processor for a faster processorD、Add a faster disk subsystem
考题
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 noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）A、 ONLINEB、 REVERSEC、 PARALLELD、 COMPRESSE、 NOLOGGINGF、 COMPUTE 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.
考题
单选题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
考题
单选题Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity， resulting indegradation of performance. What would be your next step to improve performance？ （）A
Run the SQL Access Advisor.B
Run the Memory Advisor for the sga.C
Run the Memory Advisor for the pga.D
Run the Memory Advisor for the shared pool.E
Run the Memory Advisor for the buffer cache.
考题
单选题Performance monitoring of a poorly performing system indicates a high level of CPU usage. Which tool can be used to help identify which processes are using excessive CPU resources？（）A
sarB
topasC
iostatD
vmstat
考题
单选题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 noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）AONLINEBREVERSECPARALLELDCOMPRESSENOLOGGINGFCOMPUTE STATISTICS
考题
单选题You plan to set up the Automatic Workload Repository （AWR） baseline metric thresholds for a moving window baseline. Which action would you take before performing this task？（）A
Compute the baseline statistics.B
Take an immediate AWR snapshot.C
Decrease the window size for the baseline.D
Decrease the expiration time for the baseline.
考题
单选题在sqlserver数据库中，通过哪条语句可以检查查询使用的时间和CPU使用情况？（）A
使用set statistics io语句B
使用set statistics time语句C
使用set statistics CPU语句D
使用set statistics time and CPU语句
考题
单选题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
考题
单选题Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step to improve performance（）A
Run the SQL Access AdvisorB
Run the Memory Advisor for the sga.C
Run the Memory Advisor for the pga.D
Run the Memory Advisor for the shared pool.E
Run the Memory Advisor for the buffer cache
考题
多选题You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re/x7fcreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re/x7fcreate the indexes？（）AONLINEBREVERSECPARALLELDCOMPRESSENOLOGGINGFCOMPUTE STATISTICS
热门标签
最新试卷