Related Questions

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 these reports on the SQL Server computer by using the minimum amount of disk space. What should you do?
You are a network administrator for your company. The company is currently configuring its branch offices with a Windows 2000 Server computer at each office. Each branch office has a technical-support department but not a network administrator. You want to configure the remote Windows 2000 Server computers so that whenever a new Microsoft driver becomes available, the branch offices are notified automaticaly when the administrator logs onto the server. What should you do?
If the first two statements are true, the third statement is :
I. The Shop and Save Grocery is south of Greenwood Pharmacy.
II. Rebecca's house is northeast of Greenwood Pharmacy.
III. Rebecca's house is west of the Shop and Save Grocery.
A . . . . . . . . pharmacy is established when the out-patient department and the pharmacy are geographically separate.
The president of your company collects manager's weekly reports in a shared folder on her Windows 2000 Professional computer called reports. Because the reports contain sensitive information, she asks you to prevent users from enabling offline access for the network share that contains the financial report. What should you do?
The question below consists of a set of labelled sentences. These sentences, when properly sequenced form a coherent paragraph. Select the mostlogical order of sentences from among the options. P: But when it comes to negative human rights reports or one on the environment, it rubbishes them.
Q: This kind of behaviour isnt going to solve the problem.
R: Every government is quick to accept reports that give it a pat on the back – as the Indian government was after the latest ease of doing business report.
S: No government likes negative reports on its performance.
You are an 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?
As a network administrator you have been requested to move a printer from your company's Marketing OU to your company's Research OU. After the move you test the printer and find that the local administrator assigned to the Marketing OU still has access and can remove print jobs from it. What can you do to change this?
You get a call from a network administrator who tells you that he typed the following into his router:
Router (config) #router ospf 1Router (config-router) #network 10.0.0.0 255.0.0.0 area 0
He tells you he still can't see any routes in the routing table. What configuration error did the administrator make?
You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?