单选题A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take？（）AInitiate an incomplete recovery operation using RMAN.BCopy the table from

第1题：

第2题：

For some years after his graduation, he（）some of his classmates, but as times went by, he dropped them one by one

• A、caught up with
• B、kept in touch with 
• C、kept up
• D、made up with

第3题：

What does Grade of Service (GoS) mean? （）

• A、Number of available subscriber services
• B、Number of unsuccessful call set-ups due to congestion
• C、Channel utilization
• D、Number of successful call set-ups
• E、Number of dropped calls

第4题：

A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take？（）  

• A、 Initiate an incomplete recovery operation using RMAN.
• B、 Copy the table from a development database.
• C、 Advise the user to rekey the data.
• D、 Perform a Flashback Drop operation.
• E、 Perform a Flashback Recovery operation.

第5题：

A full backup of your database named DB1 is created automatically at midnight every day. Differential backups of DB1 occur twice each day at 10:00 and at 16:00. A database snapshot is created every day at noon. A developer reports that he accidentally dropped the Pricelist table in DB1 at 12:30. The last update to Pricelist occurred one week ago. You need to recover the Pricelist table. You want to achieve this goal by using the minimum amount of administrative effort. You must also minimize the amount of data that is lost. What should you do?（）

• A、 Restore the most recent backup into a new database named DB1bak. Apply the most recent differential backup. Copy the Pricelist table from DB1bak to DB1. 
• B、 Delete all database snapshots except the most recent one. Restore DB1 from the most recent database snapshot. 
• C、 Recover DB1 from the most recent backup. Apply the most recent differential backup. 
• D、 Copy the Pricelist table from the most recent database snapshot into DB1.

第6题：

You are the desktop administrator for your company. Your company’s software developers use Windows XP Professional and IIS on their client computers to develop Web-based applications. All client computers use Microsoft Internet Explorer 6. 0 or later as their Web browser. One of the developers reports that he can no longer access the Web-based application on his desktop by using his Web browser. When you attempt to access the application by using your Web browser, you receive the following error message: “Cannot find server or DNS Error.” You verify that the World Wide Web Publishing Service is started on the developer’s computer. You also verify that you are using the correct URL to access the developer’s computer by using your Web browser. You need to ensure that the developer can access the Web application by using his Web browser. How should you configure the developer’s computer?（） 

• A、Start the default Web site.
• B、Start the IIS Admin Service.
• C、Run the IPconfig /registerdns command.
• D、In the default Web site properties，disable the host header setting.

第7题：

You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports. What should you do？（）

• A、Publish the data in the database as an XML Web service by using the FOR XML AUTO clause.
• B、Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service.
• C、Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service.
• D、Have a developer in TestKing.com create an assembly that calls the remote Web service.Create a CLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

For some years after his graduation, he（）some of his classmates, but as times went by, he dropped them one by one

Acaught up with

Bkept in touch with 

Ckept up

Dmade up with

第14题：

Given below is a list of scenarios： 1） A user terminates his session abnormally. 2） The connection between the server and the client application terminates because of a network failure. 3） A schema is accidentally dropped. 4） The tablespace is accidentally dropped from the database. 5） The hard disk gets corrupted and the data files in the disk are lost. 6） The database instance abnormally shuts down because of power failure.  Which scenarios require DBAintervention to perform recovery（）

• A、1， 3， and 6
• B、4， 5， and 6
• C、3， 4， and 5
• D、1， 2， and 6

第15题：

What two things happen when the CRS Publisher Database on an HRDB expansion server fails?（）

• A、All call processing immediately begins using the CRS Subscriber Database. 
• B、Calls in queue are dropped. 
• C、Agent calls are dropped. 
• D、Agents are automatically logged out. 
• E、CRS configuration changes are blocked until the CRS Publisher Database is restored and synchronized with the CRS Subscriber Database. 
• F、Configuration changes are buffered until the CRS Publisher Database is restored.

第16题：

You are the network administrator for Company.  A user named Peter runs Windows 2000 Professional on his portable computer. Peter wants to be able to work at home with files that were created in the office on Company’s network. He mapsdrive X to a shared network folder and configures it to reconnect when he logs on to the network.  Before Peter logs off the network and leaves the office, he attempts to make drive X available offline.   Peter calls you and reports that he does not have the option to make his shared folder available offline.   Peter needs to have the files in drive X available offline.   What should you instructs Peter to do?（）

• A、Ensure that NetBIOS over TCP/IP is enabled on the network server.
• B、Enable Offline Files on the portable computer.
• C、Create an Offline File synchronization schedule.
• D、Create a shortcut to the Offline Files folder.

第17题：

A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases， a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table. You need to achieve this goal without affecting the availability of other data in the database. What should you do？（）

• A、Back up the current transaction log. Restore the database with a different name and stop at the point just before the data loss. Copy the table back into the original database.
• B、Back up the current transaction log. Restore the database to the point just before the data loss.
• C、Restore the database from the existing backup files to a time just before the data loss.
• D、Restore the database to the point of the last full backup.

第18题：

You are the administrator of your company's network. A user named David runs Windows 2000 Professional on his portable computer. David wants to be able to work at home on files that he created at the office and stored on the company network. Prior to logging off the network and leaving the office, David enables offline files.   David calls you from home and reports that copies of his folders and files on the network are not available on his portable computer. What should you instruct David to do, so that he can proceed with his work?（）

• A、Enable file and print sharing. David will be able to access his files at home immediately. 
• B、Synchronize all offline files. David will be able to access his files at home immediately. 
• C、At the office, make all files available offline. David will be able to access his files the next time he logs off the network. 
• D、At the office, create a shortcut to the Offline Files folder. David will be able to access his files the next time he logs off the network. 

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：