You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. Users report that several storage locations in the UnitsStored field contain negative numbers. You examine the database's table structure. The table properties are configured as shown in the exhibit.
You correct all the negative numbers in the table. You must prevent the database from storing negative numbers. You also want to minimize use of server resources and physical I/O.
Which transact-SQL statement should you execute?
ALTER TABLE dbo.storagelocations ADD CONSTRAINTS CK_storagelocations_UnitsStored CHECK (UnitsStored>= 0)
B. CREATE TRIGGER CK_UnitsStored On StorageLocations FOR INSERT, UPDATE AS IF INSERTED, UnitsStored < 0 ROLLBACK TRAN
CREATE TABLE ck_unitsstored As @Units >= 0 GO Sp_bindrule ‘OK_UnitsStored’, ‘StorageLocations, UnitsStored’ GO
D. CREATE PROC UpdateUnitsStored (StorageLocationID int, @UnitsStored bigint)AS IF @UnitsStored < 0 DATSERROR (50099, 17) ELSE UPDATE storaheLocations SET UnitsStored = @UnitsStored WHERE StorageLocationID = @storageLocationID
查看答案
关于司法制度与法律职业的表述,下列哪些选项是正确的?A.关于从事法律职业的条件:①曾因犯罪受过刑关于司法制度与法律职业的表述,下列哪些选项是正确的?
A. 关于从事法律职业的条件:①曾因犯罪受过刑事处罚者不能担任公证员;②年龄二十三周岁者可以担任检察官。①正确、②不正确
B. 关于律师承办业务:①律师承办业务,应告知委托人可能出现的法律风险;②律师承办业务,可根据情况决定是否向委托人通报委托事项办理进展情况。①正确、②不正确
C. 关于检察制度的发展和特征:①资本主义国家的检察机关多隶属于行政机关的司法行政部门;②我国实行的是检察长负责和检察委员会集体领导相结合的检察院负责制。①正确、②不正确
D. 关于我国的法官制度:①法官之间有夫妻关系、直系血亲关系、三代以内旁系血亲以及近姻亲关系的,不得同时担任同一法院的院长、副院长和审判员、助理审判员;②法官的考核内容包括审判工作实绩、思想品德、审判业务和法学理论水平、工作态度和审判作风,重点考核工作态度和审判作风。①正确、②不正确
Natural foods, for example, vegetables, fruits and grains which have been grown in soil that is rich in organic matter. In simple terms, this means that the soil has been nourished by unused vegetable matter, which provides it with essential vitamins and minerals. This in itself is a natural process compared with the use of chemicals and fertilizers, the main purpose of which is to increase the amount—but not the quality—of foods grown in commercial farming areas.
Natural foods also include animals which have been allowed to feed and move freely in healthy pastures. Compare this with what happens in the mass production of poultry: there are battery farms, for ex- ample, where thousands of chickens live crowded together in one building and are fed on food which is little better than rubbish. Chickens kept in this way are not only tasteless as food; they also produce eggs which lack important vitamins.
There are other aspects of healthy eating which are now receiving increasing attention from experts on diet. Take, for example, the question of sugar, this is actually a non-essential food! Although a natural alternative, such as honey, can be used to sweeten food if this is necessary, we can in fact do without it. It is not that sugar is harmful in itself. But it does seem to be an additive: the quantity we use has grown steadily over the last two centuries and in Britain today each person consumes an average of 200 pounds a year! Yet all it does is provide us with energy, in the form. of calories. There are no vitamins in it, no minerals and no fibre.
It is significant that nowadays fibre is considered to be an important part of a healthy diet. In white bread, for example, the fibre has been removed. But it is present in unrefined flour and of course in vegetable. It is interesting to note that in countries where the national diet contains large quantities of unrefined flour and vegetable, certain diseases are comparatively rare. Hence the emphasis placed on the eating of wholemeal bread and more vegetables by modern experts on healthy eating.
Recently, some people are interested in natural foods because ______.
A. these foods are fresh and sweet
B. they want to change their eating habits
C. these foods do not contain chemical additives and have not been affected by chemical fertilizers
D. they don't like the processed foods
Section B
Directions: There are 2 passages in this section. Each passage is followed by some questions or unfinished statements. For each of them there are four choices marked A, B, C and D. You should decide on the best choice.
December 25 is celebrated as the birthday of Christ. No one is certain why this day was chosen. It was chosen probably because, according to the calendar then in use, December 25 was the time of the year when winter days begin to grow longer in the Northern Hemisphere. The sun-worshippers had celebrated this day as the promise of spring.
Over the years, a number of special customs associated with Christmas have grown up. Many of these have been introduced from Europe, while others have their origin in America.
Christmas music is loved by all who hear and sing it every year. Christmas songs, bells, and merry music have been a part of Christmas for centuries. The Christmas tree is the symbol of the spirit of Christmas in many homes. Trees were not used in English homes until a German prince married Queen Victoria. The prince had the first decorated Christmas tree set up at Windsor Castle in 1841. The first Christmas trees in the New World were introduced by Hessian soldiers in 1776, during the Revolutionary War. Later German immigrants brought the tradition into wider use in the United States.
The custom of decorating a community tree for outdoor display began in the early 1900's and is a favorite custom all over America today. Since 1933, Rockerfeller Plaza, in New York City, has put up a giant tree, beautifully decorated with lights. The trees are about 30 meters tall. Some 7,000 colored lights have been used to light them. Each year at Washington, D.C., there is a national tree lighting ceremony. The President of the United States pulls the switch that lights the brightly decorated new community Christmas tree on the White House lawn.
Some families open their presents on Christmas Eve; others wait for the next morning. Some boys' and girls' presents are placed in stockings and hung at the foot of their beds; others find their gifts under the Christmas tree.
Greeting cards began in England. One of the first artists to design and send a Christmas card in 1843 was John C. Horsley. The cards were printed in black and white and colored by hand. About 1000 of them were sold in London that year. At about the same time, another English artist, William Egley, designed a card and had it printed. He sent it to his friend with the now familiar message "A Merry Christmas and a Happy New Year".
A German immigrant, Louis Prang, designed and sold colored Christmas cards in 1874. In less than 10 years his shop was turning out 5,000,000 cards a year.
Today greeting cards have become a big industry and billions of cards are sent all over the world every Christmas. Whatever language the greetings are written in, the message is the same—a wish for peace and goodwill among all people.
A number of special customs associated with Christmas have been introduced ______.
A. from Germany
B. from Europe
C. from America
D. from both Europe and America
听力原文: Martin is a medical student. Every summer vacation he works as a guide for a travel agency. In order to get as many customers as possible, Martin prepared a speech to attract them. On the morning of the first day, when he saw a woman coming towards the door of tire agency, he immediately opened the door for her and began to describe the tour. "The bus leaves Fairfield at 9:30. It's air-conditioned and very comfortable. We first take you down to the old harbor. From there we drive along the coast and through an old residential area. At 12:30, we go to the Park Restaurant for a first-class meal. Then we go to the zoo in the park. From 3 till 5 we show you the shops in the old town, where you can buy traditional handicrafts, jewellery and pottery. We then go to the area where you can visit the natural history museum and the art gallery. Finally we come back along 8th Avenue, past the concert hall and theaters. You can count on a really wonderful day. "At last he stopped. The woman smiled and thanked him very much. Then she said she had lived in the town all her life and thought his description was very good. However, she only wanted to know what time the next bus left for Green Valley.
(33)
A. He informed the tourists of their itinerary.
B. He tried to sell a tour.
C. He answered the questions from the tourists.
D. He talked about the scenic spots on the tour.