单选题You work as a database administrator for Certkiller .com. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday’s disk I/O performance. How do you use the baseline metr

第1题：

You work as a database administrator for Certkiller .com. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this？（）

• A、Enable instance failover
• B、Configure shared server
• C、Enable database failover
• D、Enable connect-time failover
• E、Enable Transparent Application Failover （TAF）

第2题：

You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

• A、 mount the new disk group in the ASM instance
• B、 restart the ASM instance and the production database instance
• C、 register the new disk groups in the production database instance
• D、 restart the ASM instance without restarting the production database instance
• E、 include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

第3题：

You work as a database administrator for Supportcenter.cn. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday’s disk I/O performance. How do you use the baseline metrics to achieve your objective？（）

• A、Save the baseline in the database
• B、Save the baseline in the Database Control Home Page
• C、Create a procedure to read and apply the baseline to disk I/O metrics
• D、Apply the baseline to the disk I/O metrics in the Mange Metrics page
• E、Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd

第4题：

You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation.  Which two actions would you take to gain performance？（）

• A、Increase the size of redo log files
• B、Increase the size of redo log buffer
• C、Increase the number of redo log files
• D、Place the redo log files on a separate disk
• E、Decrease the number of redo log groups to two
• F、Increate the number Log Writer （LGWR） process

第5题：

You work as a database administrator at Certkiller .com. In your production database， you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）

• A、 CPU usage
• B、 degree of parallelism
• C、 number of open cursors
• D、 number of sorts performed
• E、 idle time for blocking sessions
• F、 number of disk I/O operations performed
• G、 number of memory I/O operations performed

第6题：

You are the desktop administrator for your company. You are responsible for automating the deployment of Windows XP Professional to new computers in your company. You are preparing a Windows XP Professional computer, which you will use to test disk imaging. You install Windows XP Professional on the test computer and run the Sysprep utility. You use a third-party software package to create a disk image. You apply the disk image to a new computer and then restart the computer. Instead of completing the Windows XP Professional installation, the computer starts the Windows Welcome program, requiring you to enter additional setup information.  Because you will be deploying a large number of computers, you want to ensure that the disk image can be applied without additional user interaction. What should you do?（） 

• A、Use a network-based RIS server to apply the disk image to new computers. 
• B、On the test computer, run the Sysprep -factory command. Re-create the disk image by using the third-party software. 
• C、Use Setup Manager to create a Sysprep answer file. Copy the answer file to a floppy disk, and insert the disk into new computers when the disk image is applied. 
• D、Create an Unattend.txt answer file. Copy the file to the C:/Winnt/System32 folder on the test computer. Run the Sysprep utility and re-create the disk image by using the third-party software.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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.

第14题：

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 performance
• B、write the current database metrics to a database table and create a trigger to compare with future database statistics
• C、write the current database metrics to a flat file and create an operating script to compare with future database statistics
• D、write the current database metrics to a database table and create a procedure to compare with future database statistics
• E、write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics

第15题：

You work as a database administrator for Certkiller .com. You want to be notified when the number of disk I/O increases by 10% of what it was yesterday. You create a baseline metric for yesterday’s disk I/O performance. How do you use the baseline metrics to achieve your objective？（）

• A、Save the baseline in the database
• B、Save the baseline in the Database Control Home Page
• C、Create a procedure to read and apply the baseline to disk I/O metrics
• D、Apply the baseline to the disk I/O metrics in the Mange Metrics page
• E、Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd

第16题：

You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）

• A、Increase the undo return
• B、Create more undo segments
• C、Create another undotablespace
• D、Increase the size of the undotablespace

第17题：

You work with a newly created database. Presently， there is no application load on the database instance. You want to create a baseline for tuning the application， so you decide to collect recommendations that can be implemented to improve application performance.  What action must you take to achieve this？（）  

• A、 Run Segment Advisor
• B、 Run the SQL Tuning Advisor （STA）
• C、 Run the Automatic Workload Repository （AWR） report
• D、 Run the SQL Access Advisor with a hypothetical workload

第18题：

You are the administrator of your company’s network. The software department is preparing to rewrite an accounting application so that it will run on Windows 2000 Professional computers. All of the computers in the software department currently use Windows 98.  You want to configure the computers in the software department so that the users can use both Windows 98 and Windows 2000 Professional during the project. You also want to ensure that the computers are configured for optimal disk performance. In addition you want to ensure that users in the software department can access all of the files on their computers by using either operating system.  What should you do? （）

• A、 Create and format a FAT 32 partition.
• B、 Create and format an NTFS volume.
• C、 Configure Windows 2000 Professional to enable disk compression.
• D、 Configure Windows 2000 Professional to enable dynamic volume

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：