题目内容

You are the administrator of a SQL Server 2000 computer. The server contains a database named sales. Your company uses the database to store the sales department’s responses to requests for price quotations. The database is configured as shown in the exhibit.
Developers in your company create an application used for saving quotations. The application executes the following transact-SQL statement:
UPDATE QuotationSummary
SET CustomerName = ‘Jean-Paul Deloria’
WHERE QuotationID = 12
When the application executes the statement, the developers receive the following error:
Server: Mrh4403, Level 16, Stats 1, Line 1
View or function ‘QuotationSummary’ is not updateable because it contains aggregates:
You want developers to be able to use this UPDATE statement without generating errors. What should you do?

A. Create an INSTEAD OF trigger on the view to update the composite tables.
B. Grant the developers UPDATE permissions on each base table.
C. Add a cascading update trigger on each base table.
D. Create a QuotationSummary table and populate the table with data from the base tables.

查看答案
更多问题

Section A
Directions: In this section, you will hear 8 short conversations and 2 long conversations. At the end of each conversation, one or more questions will be asked about what was said. Both the conversation and the questions will be spoken only once. After each question there will be a pause. During the pause, you must read the four choices marked A, B, C and D, and decide which is the best answer.
(12)

A. 12 dollars.
B. 8 dollars.
C. 20 dollars.
D. 10 dollars.

According to the writer, the memory books she read ______.

A. wouldn't work at once
B. caused new problems
C. didn't help at all
D. made her problem worse

Forty-thousand of the world's young children die every day. This is 15 million a year. Many of these deaths can be prevented. In fact, experts say, techniques now exist to save the lives of half of these children. The techniques are medically effective, simple to use and low cost. The biggest task bas been to inform. parents about these life-saving techniques.
Diarrhea(腹泻)is the main cause of death among children in developing countries. Diarrhea results when the body tries to clear itself of harmful bacteria(细菌). The body does this by getting out liquids, sometimes uncontrollably. If too much water, sugar and salt are lost in this way, the body cannot work normally. The child may die.
The United Nations International Children's Fund, UNICEF, introduces a technique. It uses a simple mixture of sugar and salt in water. The mixture does not stop diarrhea. But if used often as needed, it keeps fluid (体液) levels normal until the body has fought off the harmful bacteria. In Egypt, for example, the treatment was used in a children's health care program in the province of Alexandria. It reduced by one-half the number of deaths caused by diarrhea. The technique bas now been used throughout the country.
According to the passage, a large number of children can be saved only when ________。

A. the life-saving ways are medically effective
B. their parents are rich enough for the life-saving techniques
C. the life-saving techniques are easy to use
D. their parents learn the life-saving techniques

为进一步确诊首先应作哪项检查

A. 腹部B型超声
B. X线腹部立位片
C. 内镜
D. 腹腔穿刺

答案查题题库