网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（）
A
Memory Advisor
B
Segment Advisor
C
SQL Tuning Advisor
D
SQL Access Advisor
E
Automatic Database Diagnostic Monitor （ADDM）
参考答案
参考解析
解析：
暂无解析
更多 “单选题You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（）A Memory AdvisorB Segment AdvisorC SQL Tuning AdvisorD SQL Access AdvisorE Automatic Database Diagnostic Monitor （ADDM）” 相关考题
考题
An administrator determines that performance has degraded for a WebSphere Commerce database. Which of the following steps should be performed to correct this problem？（）A、Cleanup obsolete dataB、Clear the WebSphere Commerce cacheC、Enable WebSphere Commerce AcceleratorD、Reindex the database tablesE、Run Performance Monitor to monitor SQL statements
考题
The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile，and statistics to diagnose the possible causes of the performance degradation？（）A、by using the SQL access advisorB、by using the Automatic Workload Repository reportC、by running the Automatic Database Diagnostic Monitor （ADDM）D、by using the Automatic Workload Repository Compare Period reportE、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
考题
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? （） A、You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances. B、You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances. C、You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances. D、You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances.
考题
A technician notices a machine’s performance has degraded. The machine has constant errorswhen trying to read data from the drive. Which of the following should be used to repair the disk errors?（）A、DEFRAGB、MSCONFIGC、EDITD、CHKDSK
考题
You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）A、The database performance would be enhanced.B、The redo log files would be get filled more frequently.C、The overall database performance would be degraded.D、The mean time to recover （MTTR） would be increased.
考题
You work as a database administrator for Certkiller .com. In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）A、It degrades the run time and compiler performance.B、It provides better run time and compiler performance.C、It provides better optimization of the statement during parse time.D、It forces the rule based optimizer to be used for statement optimization.E、It provides better run time performance but slightly degraded compiler performance. F、It provides better run time performance but slightly degraded run time performance.
考题
You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem？（）A、The advisory memory has been turned off.B、The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.C、The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.D、The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.E、The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.
考题
You define an alert to be raised when the USERS tablespace usage has reached 80% of the total space. Which area would you refer to， in order to confirm that the alert has been raised due the event？（）A、the alert.log fileB、the DBA_ALERTS viewC、the Database Control Home pageD、the Database Control performance pageE、the Database Control Maintenance page
考题
In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）A、It degrades the run time and compiler performance.B、It provides better run time and compiler performance.C、It provides better optimization of the statement during parse time.D、It forces the rule based optimizer to be used for statement optimization.E、It provides better run time performance but slightly degraded compiler performance.F、It provides better run time performance but slightly degraded run time performance.
考题
You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（） A、Create the database by using a single data file and a single log file.B、Create the database by using a single data file and multiple log files.C、Create the database by using a single log file and multiple filegroups.D、Create the database by using a single log file and a filegroup that has multiple data files.
考题
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. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further. Which tool should you use? （） A、You should use Dynamic Management Views B、You should use SQL Server Resource Governor C、You should use SQL Server Profiler D、You should use Windows System Monitor
考题
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?（）A、It detects any configuration change that caused a performance difference in both time periods.B、It identifies any workload change that caused a performance difference in both time periods.C、It detects the top wait events causing performance degradation.D、It shows the resource usage for CPU, memory, and I/O in both time periods.E、It shows the difference in the size of memory pools in both time periods.F、It gives information about statistics collection in both time periods.
考题
多选题An administrator determines that performance has degraded for a WebSphere Commerce database. Which of the following steps should be performed to correct this problem？（）ACleanup obsolete dataBClear the WebSphere Commerce cacheCEnable WebSphere Commerce AcceleratorDReindex the database tablesERun Performance Monitor to monitor SQL statements
考题
单选题You have created a baseline metric， DISK_IO_BL， for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics？（）A
The baseline， once created， cannot be removed.B
Disable the baseline metrics in the Database Control Manage Metrics page.C
The baseline will be automatically removed once the database performance has been optimized.D
Drop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.
考题
单选题You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（）A
Memory AdvisorB
Segment AdvisorC
SQL Tuning AdvisorD
SQL Access AdvisorE
Automatic Database Diagnostic Monitor （ADDM）
考题
单选题The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）A
by using the SQL access advisorB
by using the Automatic Workload Repository reportC
by running the Automatic Database Diagnostic Monitor （ADDM）D
by using the Automatic Workload Repository Compare Period reportE
by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
考题
多选题You notice that the performance of the database has degraded because of frequent checkpoints. Which twoactions resolve the issue（）ADisable automatic checkpoint tuning.BCheck the size of the redo log file size and increase the size if it is small.CSet the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.DDecrease the number of redo log members if there are more than one redo log members available in eachredo log group.
考题
单选题You define an alert to be raised when the USERS tablespace usage has reached 80%of the total space. Which area would you refer to， in order to confirm that the alert has been raised due the event？（）A
the alert.log fileB
the DBA_ALERTS viewC
the Database Control Home pageD
the Database Control performance pageE
the Database Control Maintenance page
考题
单选题You observe that a database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine that required size of the database buffer cache？ （）A
Memory AdvisorB
Segment AdvisorC
SQL Tuning AdvisorD
SQL Access AdvisorE
Automatic Database Diagnostic Monitor （ADDM）
考题
单选题You work as a database administrator for Supportcenter.cn. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem？（）A
The advisory memory has been turned off.B
The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.C
The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.D
The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.E
The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.
考题
单选题You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）A
create baseline metrics for today’s performanceB
write the current database metrics to a database table and create a trigger to compare with future database statisticsC
write the current database metrics to a flat file and create an operating script to compare with future database statisticsD
write the current database metrics to a database table and create a procedure to compare with future database statisticsE
write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
考题
单选题You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）A
Enable Memory Access Mode, which reads performance data from SGA.B
Use emergency monitoring to fetch data directly from SGA analysis.C
Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.D
Use Active Session History (ASH) data and hang analysis in regular performance monitoring.E
Run ADDM in diagnostic mode.
考题
单选题You manage a SQL Server 2005 database that contains a table with many indexes. You notice that data modification performance has degraded over time. You suspect that some of the indexes are unused. You need to identify which indexes were not used by any queries since the last time SQL Server 2005 started. Which dynamic management view should you use？（）A
sys.dm fts index populationB
sys.dm exec query statsC
sys. dm db index usage statsD
sys.dm db index physical stats
考题
单选题You work as a database administrator for Certkiller .com. In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）A
It degrades the run time and compiler performance.B
It provides better run time and compiler performance.C
It provides better optimization of the statement during parse time.D
It forces the rule based optimizer to be used for statement optimization.E
It provides better run time performance but slightly degraded compiler performance. F
It provides better run time performance but slightly degraded run time performance.
考题
单选题You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）A
The database performance would be enhanced.B
The redo log files would be get filled more frequently.C
The overall database performance would be degraded.D
The mean time to recover （MTTR） would be increased.
考题
单选题Your database performance has degraded due to frequent checkpointing. What would you do in this scenario？（）A
make redo log files smallerB
increase the size of the checkpoint fileC
make the changes as per the advice given by MTTR AdvisorD
make the changes as per the advice given by Checkpoint Advisor
考题
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The server has a very large database named DB1. An application which is constantly available uses DB1. Now you get a report from users, in the report users complain that server has a poor performance. As the technical support, you have to improve the performance of the application by using the Database Engine Tuning Advisor. Besides this, you must make sure that the action of analyzing the workload will not affect the performance of the production server.So what should you do?（）A
On the local server, enable the XP_MSVER stored procedure B
On the remote server, enable the XP_MSVER stored procedure. C
On the production server, use the dta.exe utility along with an XML input file. D
You should configure a test server that has a similar hardware configuration. Use the dta.exe utility on the test server along with an XML input file
考题
单选题In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）A
It degrades the run time and compiler performance.B
It provides better run time and compiler performance.C
It provides better optimization of the statement during parse time.D
It forces the rule based optimizer to be used for statement optimization.E
It provides better run time performance but slightly degraded compiler performance.F
It provides better run time performance but slightly degraded run time performance.
热门标签
最新试卷
