题目内容

You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. The database is configured as shown in the exhibit.
In the last six months, the database has grown by 4 GB. Users report that query response time has slowed. The options set up on the database are shown in the Database Options exhibit.
You want to accelerate query response time. What should you do?

A. Update the database statistics.
B. Add indexes to the foreign key fields.
C. Truncate the transaction log.
D. Run the database maintenance plan wizard.
E. Drop primary keys from all tables.

查看答案
更多问题

You are the administrator of a SQL Server 2000 computer. You create several jobs on the server and schedule them to run during the evening.
You configure an operator on the server and configure the jobs to send an e-mail to this operator if a job fails for any reason.
While testing the jobs, you discover that e-mail messages are not being sent to the operator when a job fails. You use SQL Server Enterprise Manager to confirm that SQL Mail is started.
You need to ensure that e-mail messages are sent to the operator whenever a job fails. What should you do?

A. Configure SQLAgentMail to use a valid MAPI profile
B. Configure SQL Mail to use a mailbox that delegates permissions to the operator
C. Use the net send notification method to send the operator e-mail messages
D. Create a job that executes the xp_startmail stored procedure Configure the job to run whenever SQL Server 2000 starts

Part A
Directions: Read the following four texts. Answer the questions below each text by choosing A, B, C or D. (40 points)
The word conservation has a thrifty(节俭) meaning. To conserve is to save and protect, to leave what we ourselves enjoy in such good condition that others may also share the enjoyment. Our forefathers had no idea the human population would increase faster than the supplies of raw materials; most of them, even until very recently, had the foolish idea that the treasures were "limitless" and "inexhaustible". Most of the citizens of earlier generations knew little or nothing about the complicated and delicate system that runs all through nature, and which means that, as in a living body, an unhealthy condition of one part will sooner or later be harmful to all the others.
Fifty years ago nature study was not part of the school work; scientific forestry was a new idea; timber was still cheap because it could be bought in any quantity from distant woodlands; soil destruction and river floods were not national problems and nobody had yet studied long-term climatic cycles in relation to proper land use; even the word "conservation" had nothing of the meaning that it has for us today.
For the sake of ourselves and those who will come after us, we must now set about repairing the mistakes of our forefathers. Conservation' should, therefore, be made a part of everyone's daily life. To know about the water table in the ground is just as important to us as a knowledge of the basic arithmetic formulas. We need to know why all watersheds need the protection of plant life and why the running current of streams and rivers must be made to yield their full benefit to the soil before they finally escape to the sea. We need to be taught the duty of planting trees as well as of cutting them. We need to know the importance of big, mature trees, because living space for most of man's fellow creatures on this planet is figured not only in square measure of surface but also in cubic volume above the earth. In brief, it should be our goal to restore as much of the original beauty of nature as we can.
The author's attitude towards the current situation in the exploitation of natural resources is______

A. positive
B. neutral
C. suspicious
D. critical

Who Drew Circles in My Field?
In the summer of 1978 an English farmer was driving his tractor through a field of wheat when he discovered that some of his wheat was lying flat on the ground. The flattened wheat formed a circle about six meters across. Around this circle were four smaller circles of flattened wheat. The five circles were in a formation like five dots (点). During the following years, farmers in England found the strange circles in their fields more and more often.
The circles are called "crop circles" because they appear in the fields of grain--usually wheat or corn. The grain in the circles lies flat on the ground but is never broken; it continues to grow, and farmers can later harvest it. Farmers always discover the crop circles in the morning, so the circles probably form. at night. They appear only in the months from May to September.
At first, people thought that the circles were a hoax. Probably young people were making them as a joke, or farmers were making them to attract tourists. To prove that the circles were a hoax, people tried to make circles exactly like the ones that farmers had found. They couldn't do it. They couldn't enter a field of grain without leaving tracks, and they couldn't flatten the grain without breaking it.
Many people believe that beings from outer space are making the circles to communicate (交流) with us from far away and that the crop circles are messages from them.
Scientists who have studied the crop circles suggested several possibilities. Some scientists say that a downward rush of wind leads to the formation of the circles—the same downward rush of air that sometimes causes the an airplane to crash (坠毁). Other scientists say that forces within the earth cause the circles to appear. There is one problem with all these scientific explanations: crop circles often appear in formations, like the five-dot formation. It is hard to believe that any natural force could form. those.
In the summer of 1978, an English farmer discovered in his field that ______.

A. some of his wheat had been damaged
B. some of his wheat had fallen onto the ground
C. his grain was growing up in circles
D. his grain was moved into several circles

旋毛虫感染人是由于

答案查题题库