1.You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales that has two data files and one transaction log file. Each data file is located on its own hard disk and exists in its own filegroup.You perform full database, differential, and transaction log backups on a regular basis. All backups made during a single week are striped across three disk backup devices. A portion of the header information for the current week's backups is shown in the following table. BackupName              BackupType      BackupFinishDate----------------------- --------------- ---------------------------sales_db_20000625       1               2000-06-25 21:57:04.000sales_tl_20000626_1     2               2000-06-26 11:04:22.000sales_tl_20000626_2     2               2000-06-26 15:06:33.000sales_df_20000626       5               2000-06-26 21:15:48.000sales_tl_20000627_1     2               2000-06-27 11:03:39.000sales_tl_20000627_2     2               2000-06-27 15:04:59.000sales_df_20000627       5               2000-06-27 21:31:13.000sales_tl_20000628_1     2               2000-06-28 11:05:16.000 On June 28, 2000, at 1:47 P.M., the hard disk that contains the PRIMARY filegroup fails. You want to recover as much data as possible. What should you do? (Each correct answer presents part of the solution. Choose all that apply.) A:Backup the transaction log by using the NO_LOG option.B:Backup the transaction log by using the NO_TRUNCATE option.C:Restore the most recent full database backup.D:Restore the most recent differential backup.E:Restore all differential backups in sequence.F:Restore all transaction log backups in sequence.G:Restore all transaction logs since the most recent differential backup.Correct Answers:  B, C, D, G 2.You are the administrator of a SQL Server 2000 computer. Your company has 150 client computers that are running UNIX. These client computers require access to the server to use a database named TechInfo. The server is configured with the TCP/IP and Named Pipes Net-Libraries. You need to configure the server to allow the client computers to use the TechInfo database. You also want to minimize the amount of time it takes to configure the server and allow for the tracking of individual user actions. Which two actions should you take? (Each correct answer presents part of the solution. Choose two.) A:Configure Windows Authentication.B:Configure Mixed Mode authentication.C:Create a SQL Server login for each user.D:Create a domain user group login for all of the users.E:Create a single SQL Server login for all of the users.F:Enable the Multiprotocol Net-Library.G:Disable the Named Pipes Net-Library.Correct Answers:  B, C 3.You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. In this database, the Parts table has a primary key that is used to identify each part stored in the company's warehouse. Each part has a unique UPC code that your company's accounting department uses to identify it. The database is configured as shown in the exhibit. (Click the Exhibit button.)You want to maintain referential integrity between the Parts table and the OrderDetails table. You want to minimize the amount of physical I/O that is used within the database.Which two Transact-SQL statements should you execute? (Each correct answer presents part of the solution. Choose two.)A:CREATE UNIQUE INDEX IX_UPC On Parts(UPC)B:CREATE UNIQUE INDEX IX_UPC On OrderDetails(UPC)C:CREATE TRIGGER UPCRI On OrderDetailsFOR INSERT, UPDATE AsIf Not Exists (Select UPC From PartsWhere Parts.UPC = inserted.UPC)BEGIN   ROLLBACK TRANENDD:CREATE TRIGGER UPCRI On PartsFOR INSERT, UPDATE AsIf Not Exists (Select UPC From Parts Where OrderDetails.UPC = inserted.UPC)BEGIN   ROLLBACK TRANENDE:ALTER TABLE dbo.OrderDetails ADD CONSTRAINTFK_OrderDetails_Parts FOREIGN KEY(UPC)REFERENCES dbo.Parts(UPC)F:ALTER TABLE dbo.Parts ADD CONSTRAINTFK_Parts_OrderDetails FOREIGN KEY (UPC) REFERENCES dbo.Parts(UPC)Correct Answers:  A, E 4.You are the administrator of a SQL Server 2000 computer. The server contains confidential information about contracts on which your company has placed bids.Company policy requires that bid information be removed permanently from the database one year after the bid closes. You need to comply with this policy and minimize server overhead.What should you do? A: Create a Data Transformation Services (DTS) package to remove bids that have a closing date older than one year.B: Create a trigger to delete any bids that have a closing date older than one year. Bind the trigger to the Bids table for all INSERT, UPDATE, and DELETE events.C: Create a stored procedure to delete any bids that have a closing date older than one year. Use SQL Server Agent to schedule the stored procedure to run every night.D: Create a view that contains a WHERE clause to exclude bids that have a closing date older than one year.Correct Answers:  C

本新闻共3页,当前在第1页  1  2  3