Related Questions

You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information.BULK INSERT finance.dbo.customersFROM 'd:bulkaccts143_10142000.txt'WITH DATAFILETYPE = 'char', FIELDTERMINATOR = 't', ROWTERMINATOR = 'n', TABLOCK You want to ensure that response times do not slow when new account information is added to the database. What should you do?
In the question below, are given a statement followed by three courses of actions numbered I, II and III. On the basis of the information given, you have to assume everything in the statement to be true, and then decide which of the following suggested courses of actions logically follow(s) for pursuing. Statement: Starting October, all new cars will have pedestrian safety features, including new design of the bonnet, to reduce impact on pedestrians during accidents. Advanced safety features are needed in all vehicles in India as vehicle safety cannot be confined to luxury vehicles only. Around 1.5 lakh people are killed in road accidents every year in the country, nearly 60% of them are pedestrians.  Courses of action: I. The government has set a target to reduce the number of road deaths by half in the next two years. The ministry of road transport and highways has been issuing new safety standards for the automobiles along with eliminating the black spots on national highways.  II. By next month, all new cars will have pedestrian safety feature, including new design of the bonnet, to reduce impact on pedestrians during accidents.  III. Ministry of road transport and Highways is planning to implement all safety features in vehicles with active support of vehicle manufacturers. Electronic stability control (ESC) and autonomous emergency braking (AEB) will be incorporated in new vehicles by 2022.
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 protect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?