|
发信人: reynolds(雷龙.DBA中) 整理人: reynolds(2002-04-02 10:50:59), 站内信件 |
| 1. You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers. You are also the administrator of an Oracle relational database management system (RDBMS) server. This server is used to store your company's financial information. The financial information is updated frequently throughout the day. You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day. You want to create reports on the SQL Server computer by using the minimum amount of disk space. What should you do?
A. Set up SQL server replication to replicate the data from the Oracle server to the SQL server computer. B. Set up the Oracle server as a linked server. Create a view that joins the service contract information and the financial information. C. Set up a data transformation services (DTS) package that imports and transforms the database from the Oracle server to the SQL server computer. Use SQL Server Agent to execute the DTS package throughout the day as needed. D. Set up an Microsoft ActiveX script that connects to the Oracle server and imports the financial information into an SQL Server temporary table. Create a view that joins the service contract information and the temporary table. Answer: B Reason: 仅仅只是需要从Oracle的数据库中提取数据生成报表，因此链接服务器是最佳选择，也符合了题目所要求的所耗用空间最小的要求，在生成报表过程中只消耗Tempdb数据库中的空间。 2. You are the administrator of two SQL Server computers. One server is named SQL7, and other is named SQL2000. SQL7 is running SQL server 7.0 and SQL2000 is running SQL server 2000. The net-libraries on SQL2000 are configured as shown in the exhibit (exhibit not available). SQL7 is configured so that it has the Named Pipes, TCP/IP, NWLink, IPX/SPX and Multiprotocol net libraries. SQL2000 and SQL7 exchange confidential company information. You need to ensure that unauthorized users cannot access this information. Which two actions should you take? (Each correct answer presents part of the solution. Choose two) A. On SQL2000, enable the Multiprotocol net library. B. On SQL2000, select the ‘Force protocol encryption’ check box. C. On SQL7, select the ‘Force protocol encryption’ check box. D. On SQL2000, install a secure sockets layer (SSL) encryption certificate. E. On SQL2000 and SQL7, enable multipoint encryption. Answer: BD Reason: 选择B是显而易见的，在“客户端实用工具”中配置。选择D有些拿捏不准，根据我的实验结果如下——我在SQL服务器上的客户端配置了强行加密后，发现不安装SSSL认证仍然可以打开企业管理器，但是在98的客户端下，就打不开了。由于我没有 其他的客户端了，因此无法进一步验证。仅从以上现象来说，估计D应该可信。 由于懒惰，没有去安装证书颁发机构模块，也就忽略了实验，有空补过吧。 3. You are the administrator of Microsoft Windows 2000 computer. You are preparing to install SQL Server 2000 on the computer. Your company contains a variety of client computers that will connect to the SQL server 2000 computer by using a specific net-library, as shown in the following table. Client computer Net-Library Microsoft Windows 98 Named Pipes Novell NetWare IPX/SPX Apple Macintosh TCP/IP You need to allow the client computers to connect to the SQL Server computer. You also want to minimize the number of configuration changes required on the client computers. Which three actions should you take? (Each correct answer presents part of the solution. Choose three) A. Install SQL server 2000 as a named instance. B. Install SQL server 2000 as the default instance. C. Configure the new instance for Mixed Mode Authentication. D. Configure the new instance for Windows authentication. E. Configure the server to use the named piped, IPX/SPX, and TCP/IP Net-Libraries. F. Configure the server to use the Multiprotocol Net-Library. Answer: B C E Reason: 多协议类型的客户端连接服务器和实例类型是没有任何关系的，因此B就OK啦。在者，多客户端种类连接，WINDOWS认证方式也是不合时宜的，选择C可以适应多种类客户端的需求。至于选择什么样的协议，这个问题让人比较迷惑的是那个Multiprotocol，Multiprotocol协议作用官方解释如下： ====================================================================== The Multiprotocol selection has two key features: Automatic selection of an available network protocol to communicate with an instance of Microsoft® SQL Server™. This is convenient when you want to connect to multiple servers running different network protocols but do not want to reconfigure the client connection for each server. If the client and server Net-Libraries for TCP/IP Sockets, NWLink IPX/SPX, or Named Pipes are installed on the client and server, the Multiprotocol Net-Library will automatically choose the first available network protocol to establish a connection. Client encryption. You can enforce encryption over the Multiprotocol Net-Library on clients running on the Microsoft Windows NT® 4.0, Windows® 2000, Windows 95, or Windows 98 operating system to prevent others from intercepting and viewing sensitive data. The Multiprotocol Net-Library takes advantage of the remote procedure call (RPC) facility of Windows NT 4.0 and Windows 2000, which provides Windows Authentication. For the Multiprotocol Net-Library, clients determine the server address using the server name. ====================================================================== 也就是说：Multiprotocol可以从所配置的客户端协议中自动选择可用的和服务器连接。因此该协议并非必选协议，所以选择E吧。 4. You are the administrator of a SQL server 2000 computer. The server contains a database named inventory. Developers at your company upgrade an inventory tracking application. Users report that when they insert new information in the Locations table, the upgrade application returns the following error message: ‘String or binary data would be truncated. The statement has been terminated.’ When you use SQL Profiler to trace the activity of the application, you receive the results as shown below: Event Class Test Date Application Name SQL:BatchCompleted Set implicit_transactions off MS SQLEM SQL:BatchCompleted Use inventory MS SQLEM Audit Login Network protocol : LPC set quoted Visual Basic SQL:BatchCompleted Insert into locations Visual Basic You examine the design of the locations table as shown in the table design below: Table Schema Customers Orders Employees CustomerID OrderID EmployeeID CompanyName CustomerID LastName ContactName EmployeeID FirstName ContactTitle OrderDate Title Address RequiredDate TitleofCourtsey City ShippedDate BirthDate Region ShipVia HireDate PostalCode Freight Address Country ShipName City Phone ShipAddress Region Fax ShipCity PostalCode ShipRegion Country Suppliers Products Order Details SupplierID ProductID OrderID CompanyName ProductName ProductID ContactName SupplierID UnitPrice ContactTitle CategoryID Quantity Address QuantityPerUnit Discount City UnitPrice Region UnitsInStock PostalCode UnitsOnOrder Country ReorderLevel Phone Discontinued Fax HomePage Categories CategoryID CategoryName Description Picture You need to configure the database to support both versions of the application without affecting server performance. What should you do? A. Alter the data type of the description field to varchar(50). B. Alter the data type of the Special field to varchar(50). C. Alter the data type of the CubicFeet field to float. D. In the locations table, create an INSTEAD OF trigger that truncates the description field at 10 characters when the record is updated. E. In the locations table, create an INSTEAD OF trigger that truncates the Special field at 10 characters when the record is updated. Answer: A Reason: 这道题目看不懂，缺东西！参考参考吧。 5. You are the administrator of an SQL Server 2000 computer. You configure a set of alerts on the server to notify you whenever certain operations fail or encounter errors. The notifications are sent to your Microsoft Windows 2000 Professional computer by using the ‘net send’ command. You successfully test the alerts. After several days, however, you stop receiving notifications when operations fail or encounter an error. You verify that the SQLServerAgent service is started. You need to make sure that you continue to receive alert notifications. What should you do? A. Stop and restart the SQLServerAgent service. B. Clear the application log on the SQL server computer. C. Clear the system log on your Windows 2000 Professional computer. D. Install the SQL Server 2000 administrative tools on your Windows 2000 Professional computer. Answer: B Reason: 日志充满导致程序无法正常运作的例子太多了，由于服务显示为正常，那么最大的疑点就在于日志了，选择B吧。实践工作中也应如此，首先检查服务、然后是相关的日志。 ---- / <>< o /| / <>< (o / |/| ) ) <@ < ( O )( \ |\| <>< ) <>< () \| \ \ 每天在网易游水的鱼 |
|
[关闭][返回] |