单选题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 timeB Memory,because the 

题目
单选题
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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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 views
  • B、 The alert log file
  • C、 The parameter file
  • D、 The server parameter file
  • E、 Dynamic performance views

正确答案:B

第2题:

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.

正确答案:B

第3题:

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

正确答案:B

第4题:

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.

正确答案:B

第5题:

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?

正确答案:D

第6题:

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.

正确答案:B

第7题:

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.

正确答案:C

第8题:

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?

正确答案:D

第9题:

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

正确答案:B

第10题:

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 file
  • B、Because the progress is reported for each backup set
  • C、Because other RMAN sessions have issued the same BACKUP command
  • D、Because new data files have been added to the database while the RMAN backup is in progress

正确答案:B

更多相关问题