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.
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.
相关考题：
You want to upgrade 100 computers from Windows 98 to Windows 2000 Professional. You use setup manager to create the unattended.txt file. The hardware on each computer is configured identically. You upgrade 10 of the computers. You notice that the monitors on the 10 computers go blank after Windows 2000 Professional loads. You restart one of the computers in Safe Mode, and find that the monitor appears to be working. Which change should you make to unattend.txt to configure your video settings correctly?Click the appropriate line on the Unattend.txt Notepad screen.
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?() A. the SQL text SQLB. the execution planC. the execution contextD. the execution frequencyE. the system change number (SCN)
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.() A. Change in the Oracle Database versionB. Change in your network infrastructureC. Change in the hardware configuration of the database serverD. Migration of database storage from non-ASM to ASM storageE. Database and operating system upgrade
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.Which method or feature should you use?() A. Compare Period ADDM reportB. AWR Compare Period reportC. Active Session History (ASH) reportD. Taking a new snapshot and comparing it with a preserved snapshot
You have a computer that runs Windows Vista Ultimate.You open the Windows System Performance Rating tool and receive a Windows Experience Index base score of 1.0. The subscores are as follows:·Processor: 4.7·Memory (RAM): 3.6·Graphics: 1.0·Gaming Graphics: 1.0·Primary Hard Disk: 3.0You upgrade your video adapter card with a new card that meets the minimum requirements for Windows Aero.You open the System Performance and Rating tool and notice the base score and subscores have not changed.You need to enable Windows Aero.What should you do?（）A.AB.BC.CD.D
You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).Users report that it takes a long time to open shared files on Server1. Users do not report this performance problem when they open files on other servers.You notice the following performance statistics on Server1:You need to optimize the performance of Server1.What should you do?（）A. Add more ram.B. Upgrade the processor.C. Increase the size of the PageFile.D. Disable Data Execution Prevention (DEP).
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process？（）A、 the SQL textB、 the execution planC、 the execution contextD、 the execution frequencyE、 the system change number （SCN）
You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）A、 redo log filesB、 password fileC、 control fileD、 change tracking file
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）A、Change in the Oracle Database versionB、Change in your network infrastructureC、Change in the hardware configuration of the database serverD、Migration of database storage from non-ASM to ASM storageE、Database and operating system upgrade
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?（）A、the SQL text SQLB、the execution planC、the execution contextD、the execution frequencyE、the system change number (SCN)
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 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. Today you notice that applications that run on the server have poor performances. You doubt that this has something to do with table scans. You have to capture the appropriate information by using an appropriate Windows System Monitor object. In the options below, which performance object should you use? （） A、You should use SQLServer:Buffer ManagerB、You should use SQLServer:Memory Manager C、You should use SQLServer:Databases D、You should use SQLServer:Access Methods
多选题A user named Tom reports that an application on his Windows 2000 Professional computer is running slowly. You notice Tom’s computer has 64 MB of RAM and 100 MB of free disk space. What should you do to improve the performance of his system？ （）AAdd Tom to the Power user group.BSet the total paging file to 75 % of physical memory.CPerform a disk analysis and use the disk defragmenter if recommended.DUse Disk cleanup to delete temporary files and unnecessary program files.EEnsure that the Performance Options windows is optimized for background services.
单选题M: Excuse me, I'm sorry to bother you. ______ a 10 note? W: Sorry, I can't unless you buy something here.ACan you change meBCan you change itCCan't you changeDCan't you change it
单选题You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）ACompare Period ADDM reportBAWR Compare Period reportCActive Session History (ASH) reportDTaking a new snapshot and comparing it with a preserved snapshot
单选题You have completed an OSPF implementation, and you are verifying OSPF operation. During this verification, you notice that the OSPF route of 172.16.10.0 is repeatedly appearing and disappearing from the routing table. Further investigation finds that the OSPF CPU utilization is very high and the routers are constantly performing SPF calculations. You determine that 172.16.20.2 is the source of the 172.16.10.0 route. Using the show ip ospf database router 172.16.20.1 command, you notice that when this show command is performed repeatedly, the contents of the LSA change every few seconds. What could be the cause of this problem?（）AOSPF authentication errors between some of the routersBTwo routers have the same OSPF router IDCIssues with mistuned OSPF timersDOSPF LSA pacing issues between some of the routersEOSPF neighbor adjacency problems between some of the routers
单选题You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）A redo log filesB password fileC control fileD change tracking file
单选题Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users’queries. Which component of the Oracle Instance would you change to improve performance？（）AJava poolBLarge poolCShared poolDStreams poolELibrary cacheFRedo log bufferGData dictionary cacheHDatabase buffer cache
多选题You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process？（）Athe SQL textBthe execution planCthe execution contextDthe execution frequencyEthe system change number （SCN）
单选题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? （）AYou should use Dynamic Management Views BYou should use SQL Server Resource Governor CYou should use SQL Server Profiler DYou should use Windows System Monitor
单选题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?（）AEnable Memory Access Mode, which reads performance data from SGA.BUse emergency monitoring to fetch data directly from SGA analysis.CRun Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.DUse Active Session History (ASH) data and hang analysis in regular performance monitoring.ERun ADDM in diagnostic mode.
多选题You are a network administrator for ExamSheet.net's Windows 2000 network. A user named Sandra has a Windows 2000 Professional computer with a single hard disk with two partitions configured as drive C and D. A pagefile has been configured on Drive C:. Sandra reports that applications on her Windows 2000 Professional computer are running slowly. You notice that Sandra's computer has 64 MB of RAM. Her hard drive contains 70 MB of free disk space on drive C and 160 MB of free disk space on drive D.You want to improve the performance of Sandra's computer. What should you do?（）AMove the paging file to drive DBUse Disk Cleanup to delete temporary files and unnecessary program filesCPerform a disk analysis， and use the disk defragmenter if recommendedDEnsure that the Performance Options window is optimized for applicationsEEnsure that the Performance Options services.
单选题You work as a network engineer at TestKing.com. TestKing users have noticed extremely slow network performance, intermittent connectivity, and connection loss. After entering the show interfaces command, you notice that the Ethernet interface is configured as 100 Mbps full-duplex and that there is evidence of late collisions. What could be the cause of this problem?（）Aduplex mismatchBa routing loopCtrunking mode mismatchDimproperly configured root bridgeEimproperly configured static VLAN
多选题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?（）AIt detects any configuration change that caused a performance difference in both time periods.BIt identifies any workload change that caused a performance difference in both time periods.CIt detects the top wait events causing performance degradation.DIt shows the resource usage for CPU, memory, and I/O in both time periods.EIt shows the difference in the size of memory pools in both time periods.FIt gives information about statistics collection in both time periods.
单选题When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）A The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETB The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGETC The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory ManagementD The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management
单选题Your Windows 2000 Professional computer contains a 166 MHz processor 64 MB of RAM and 750 MB of free disk space. You have installed a number of applications on your computer including a word processing program， a spreadsheet program， a third party scientific application and a multimedia player. You notice that when you have several of these applications open simultaneously the performance of your computer is noticeably slower. You run system monitor notice that the processor time and queue counters are showing high readings was blue and red line touching 100%. What should you do to solve this problem？（）AUse diskprode to modify existing disk sector values.BUpgrade your processor.CIncrease the amount of free disk space.DIncrease the amount of RAM.