单选题A consultant has been asked to do a performance analysis on a database server. Which subsystem should the consultant first analyze and why？（）ACPU，because the database replication process requires a considerable amount of CPU timeBMemory，because the buffer cache requires a large amount of memory to maintain the data in system memoryCDisk，because it is important to configure a sufficient number of disks to match the CPU processing powerDNetwork，because the data returned to the client from the server can be a large subset of the total database
单选题
A consultant has been asked to do a performance analysis on a database server. Which subsystem should the consultant first analyze and why？（）
A
CPU，because the database replication process requires a considerable amount of CPU time
B
Memory，because the buffer cache requires a large amount of memory to maintain the data in system memory
C
Disk，because it is important to configure a sufficient number of disks to match the CPU processing power
D
Network，because the data returned to the client from the server can be a large subset of the total database
参考解析
解析：
暂无解析
相关考题：
An administrator is upgrading memory on the server. Once the server in turned back on, the administrator notices that the memory has not changed. The system board website says the board should accept the new amount of memory.Which of the following should the administrator do FIRST?（）A、Replace memory chips with known good memory chips.B、Reseat the memory chips.C、Update the BIOS.D、Upgrade the server OS
Due to slow response times， a customer purchased additional memory. After the memory was installed，response time was not improved. They complained to the pSeries technical specialist. Which of the following questions should be asked of this customer？（）A、Who recommended the memory purchase？B、Have more users been added since the memory purchase？C、Why were additional CPUs not ordered at the same time as the memory？D、Did a performance analysis of peak periods show a memory bottleneck？
The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have asked to find out the value of the parameters when the instance was started.Which source would you use to locate this information？（）A、 Fixed viewsB、 The alert log fileC、 The parameter fileD、 The server parameter fileE、 Dynamic performance views
A Windows Azure application connects to a SQL Azure database. The database size has increased significantly. Some queries in the application no longer complete. You need to recommend an approach for identifying queries that do not complete. What should you recommend？（）A、 Use the SQL Server Profiler to capture all SQL activities.B、 Use a Dynamic Management View to analyze performance.C、 Use the Database Engine Tuning Advisor to analyze the workload.D、 Use Microsoft SQL Server Management Studio to analyze the SQL logs.
An administrator is upgrading memory on the server. Once the server in turned back on， the administrator notices that the memory has not changed. The system board website says the board should accept the new amount of memory. Which of the following should the administrator do FIRST？（）A、 Replace memory chips with known good memory chips.B、 Reseat the memory chips.C、 Update the BIOS.D、 Upgrade the server OS.
The database on a p5-570 Micro-Partition has grown and backups are not meeting the Service Level Agreement. There are several partitions using the Virtual I/O Server to access the storage array. The database backup has high CPU utilization while the others have low CPU utilization. What adjustment can the technical specialist make to ensure that the Service Level Agreement is achieved？（）A、Add memory to the database partition to improve response time.B、Add additional Host Bus Adapters to the server to improve IO throughput.C、Modify CPU allocations to favor the database partition.D、Increase CPU allocations to the Virtual I/O Server.
An insurance provider maintains a claims database where claims adjusters are adding new claims and updating existing claims everyday. In the evening， a batch process is run to analyze data entered throughout the day. To reduce costs， a shared storage solution is being considered. Which of the following questions should the consultant ask to select the best performing storage configuration that meets their budget requirements？（）A、What database is being used？B、Which client operating systems will access the database？C、Which vendor’s Fibre Channel switch do they prefer？D、What volume of data is analyzed each evening？
management has asked bob to post an introductory welcome page when notes users first open the video application in which one of the following places should bob put the welcome message?（）A、 in a document named welcome B、 in the database about doc C、 in the database using doc D、 in the first page in the database design
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.
View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions: RMAN BACKUP DATABASE FILESPERSET 2; The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?（）A、Because the progress is reported for each data fileB、Because the progress is reported for each backup setC、Because other RMAN sessions have issued the same BACKUP commandD、Because new data files have been added to the database while the RMAN backup is in progress
The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have been asked to find out the value of the parameters when the instance was started. Which source would you use to locate this information？（）A、fixed viewsB、the alert log fileC、the parameter fileD、the server parameter fileE、dynamic performance views
The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA，based on the amount of memory available on the system？（）A、 20% SGA 80% PGAB、 25% SGA 75% PGAC、 50% SGA 50% PGAD、 75% SGA 25% PGAE、 80% SGA 20% PGA
You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. There is a database in the instance, and the day-to-day business of your company requires the database. When reports are executed, slow response time will be experienced by Users. A performance monitoring strategy will be implemented by you so as to have three aspects of data captured and stored: Blocking and deadlock information, Executed Transact-SQL statements Query activity and Counters for disk, CPU, and memory. You are required to utilize the least amount of administrative effort to implement the monitoring process. Which action will you perform to finish the task?（）A、To finish the task, the client-side profiler trace should be utilized. B、To finish the task, the dynamic management views should be utilized.C、To finish the task, the data collector should be utilized. D、To finish the task, the System Monitor counter log trace should be utilized.
单选题Due to slow response times， a customer purchased additional memory. After the memory was installed，response time was not improved. They complained to the pSeries technical specialist. Which of the following questions should be asked of this customer？（）AWho recommended the memory purchase？BHave more users been added since the memory purchase？CWhy were additional CPUs not ordered at the same time as the memory？DDid a performance analysis of peak periods show a memory bottleneck？
单选题management has asked bob to post an introductory welcome page when notes users first open the video application in which one of the following places should bob put the welcome message?（）A in a document named welcome B in the database about doc C in the database using doc D in the first page in the database design
单选题An administrator is upgrading memory on the server. Once the server in turned back on， the administrator notices that the memory has not changed. The system board website says the board should accept the new amount of memory. Which of the following should the administrator do FIRST？（）A Replace memory chips with known good memory chips.B Reseat the memory chips.C Update the BIOS.D Upgrade the server OS.
单选题The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have asked to find out the value of the parameters when the instance was started.Which source would you use to locate this information？（）A Fixed viewsB The alert log fileC The parameter fileD The server parameter fileE Dynamic performance views
单选题Which new key architectural element introduced in WebLogic Server l2c should you take advantage of when designing Disaster Recovery Centers with active - passive mode?（）AMAN Clusters, because they would allow you to synchronously replicate state in low latency networks BWAN Clusters, because they would allow you to asynchronously replicate state in nonlow latency networks. CTransaction Log in the database, because you could avoid synchronizing two replication technologies (database and file) DData Guard, because it is the most effective way to replicate a state across locationsEGoldenGate, because it is the most effective way to replicate a state across locations
单选题Which of the following is the best version of sentences 10 and 11 (reproduced below) ?It is easy to see why this disease has been dismissed and ignored. Its because of it’s vagueness and mystery.AThis disease has been dismissed and ignored because of its vagueness and mystery.BIt is easy to see why this disease has been dismissed and ignored. It’s because of the vagueness and the mystery.CVagueness and mystery dismiss and ignore this disease.DWhy this disease has been dismissed and ignored is because of its vagueness and mystery.EIt is easy for you to see why this disease has been dismissed and ignored. It is because of the vagueness and mystery.
单选题An administrator is upgrading memory on the server. Once the server in turned back on, the administrator notices that the memory has not changed. The system board website says the board should accept the new amount of memory.Which of the following should the administrator do FIRST?（）AReplace memory chips with known good memory chips.BReseat the memory chips.CUpdate the BIOS.DUpgrade the server OS
单选题You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. There is a database in the instance, and the day-to-day business of your company requires the database. When reports are executed, slow response time will be experienced by Users. A performance monitoring strategy will be implemented by you so as to have three aspects of data captured and stored: Blocking and deadlock information, Executed Transact-SQL statements Query activity and Counters for disk, CPU, and memory. You are required to utilize the least amount of administrative effort to implement the monitoring process. Which action will you perform to finish the task?（）ATo finish the task, the client-side profiler trace should be utilized. BTo finish the task, the dynamic management views should be utilized.CTo finish the task, the data collector should be utilized. DTo finish the task, the System Monitor counter log trace should be utilized.
单选题The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA，based on the amount of memory available on the system？（）A 20% SGA 80% PGAB 25% SGA 75% PGAC 50% SGA 50% PGAD 75% SGA 25% PGAE 80% SGA 20% PGA
单选题The database on a p5-570 Micro-Partition has grown and backups are not meeting the Service Level Agreement. There are several partitions using the Virtual I/O Server to access the storage array. The database backup has high CPU utilization while the others have low CPU utilization. What adjustment can the technical specialist make to ensure that the Service Level Agreement is achieved？（）AAdd memory to the database partition to improve response time.BAdd additional Host Bus Adapters to the server to improve IO throughput.CModify CPU allocations to favor the database partition.DIncrease CPU allocations to the Virtual I/O Server.
单选题A Windows Azure application connects to a SQL Azure database. The database size has increased significantly. Some queries in the application no longer complete. You need to recommend an approach for identifying queries that do not complete. What should you recommend？（）A Use the SQL Server Profiler to capture all SQL activities.B Use a Dynamic Management View to analyze performance.C Use the Database Engine Tuning Advisor to analyze the workload.D Use Microsoft SQL Server Management Studio to analyze the SQL logs.
单选题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.
单选题The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have been asked to find out the value of the parameters when the instance was started. Which source would you use to locate this information？（）Afixed viewsBthe alert log fileCthe parameter fileDthe server parameter fileEdynamic performance views
单选题An insurance provider maintains a claims database where claims adjusters are adding new claims and updating existing claims everyday. In the evening， a batch process is run to analyze data entered throughout the day. To reduce costs， a shared storage solution is being considered. Which of the following questions should the consultant ask to select the best performing storage configuration that meets their budget requirements？（）AWhat database is being used？BWhich client operating systems will access the database？CWhich vendor’s Fibre Channel switch do they prefer？DWhat volume of data is analyzed each evening？