You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.

Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.

What should you do?

You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.

You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.

You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.

What should you do?

You are the administrator of a SQL Server 2000 computer. The server contains a database that stores inventory data. Another database administrator has created a number of scheduled jobs to maintain the inventory database. Each weeknight the following jobs occur.

-- A BULK INSERT job imports data at 10:00 P.M.

-- Indexes are rebuilt at 10:15 P.M.

-- Data integrity checks are performed at 10:30 P.M.

-- A differential backup is performed at 10:45 P.M.

-- A DBCC SHRINKDATABASE job runs at 11:00 P.M.

You notice that the final job often fails and returns the following error message: "Server Msg 3140, Level 16, State 3. Could not adjust the space allocation for file 'inventory_data'."

You need to ensure that the final job runs without errors. What should you do?

You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The database is configured as shown in the exhibit.

Users frequently need details about parts. Users search for data by using the following query.

SELECT   Parts.SKU, Locations.Description, Manufacturer.Name,

       PartsLocations.Qty, PartsLocations.LastInventoried

FROM    Parts

INNER JOIN Manufacturer ON Parts.ManufacturerID=

       Manufacturer.ManufacturerID

INNER JOIN  PartsLocation ON Parts.PartID = Parts.Location.PartsID

INNER JOIN  Locations ON Parts.LocationID= Locations.LocationID

WHERE SKU?

You need to accelerate query response time. What should you do?

You are the database administrator for an accounting company. You are installing SQL Server 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database applications that your company has purchased. Each application uses a separate database.

During the installation, you specify SQL_Latin1_General_CP1_CI_AI as the default collation for the SQL server computer. After completing the installation, you discover that one of the new applications, named Financials, is sorting information incorrectly.

You contact the application vendor and discover that the Financials application requires the SQL_Latin1_CP437_BIN collation. You need to configure the correct collation for the applications without diminishing the performance of the SQL Server computer.

What should you do?

You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.

Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.

What should you do?

server’s msdb database in an e-mail message to the administrator of another SQL Server computer.

You create a job that contains the following steps:

--Detach the msdb database

--Send the database to the administrator in an e-mail message

--Reattach the msdb database

You test the job, and it fails on the first step. You need to ensure that the msdb database is mailed to the administrator every night.

What should you do?

You are the administrator of a SQL Server 2000 computer. Each evening after business hours, you perform. database maintenance tasks. You create a Data Transformation Services package to populate the data warehouse. MAPI is not installed on the server.

You want to schedule the DTS package to run each night. You want to attend to other duties while the DTS package is executing. You also want to be notified if the DTS package fails.

What should you do?