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

第1题：

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.

第2题：

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？

第3题：

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.

第4题：

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

第5题：

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.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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.

第14题：

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

第15题：

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

第16题：

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% PGA
• B、 25% SGA  75% PGA
• C、 50% SGA  50% PGA
• D、 75% SGA  25% PGA
• E、 80% SGA  20% PGA

第17题：

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：