问题 单项选择题

设有两个关系: 系(系编号,系名称,系主任),主码是系编号 教师(教工号,姓名,性别,系编号),主码是教工号,外码是系编号 规定当一个系里有教师,就不允许删除这个系。则能够实现这个删除约束的SQL语言外键子句中应该使用短语

A.ON DELETE CASCADES

B.ON DELETE RESTRICTED

C.ON DELETE NULLIFIES

D.ON DELETE DEFAULT

答案

参考答案:B

解析: 显然,系是一个被参照关系,教师是参照关系。若规定当一个系里有教师,就不允许删除这个系,该操作属于受限删除(RESTRICTED)。所以能够实现这个删除约束的SQL语言外键子句中应该使用短语ON DELETE RESTRICTED。

单项选择题

It is no longer just dirty blue-collar jobs in manufacturing that are being sucked offshore but also white-collar service jobs, which used to be considered safe from foreign competition. Telecoms charges have tumbled, allowing workers in far-flung locations to be connected cheaply to customers in the developed world. This has made it possible to offshore services that were once non-tradable. Morgan Stanley’s Mr. Roach has been drawing attention to the fact that the "global labour arbitrage" is moving rapidly to the better kinds of jobs. It is no longer just basic data processing and call centres that are being outsourced to low-wage countries, but also software programming, medical diagnostics, engineering design, law, accounting, finance and business consulting. These can now be delivered electronically from anywhere in the world, exposing skilled white-collar workers to greater competition.
The standard retort to such arguments is that outsourcing abroad is too small to matter much. So far fewer than lm American service-sector jobs have been lost to off-shoring. Forrester Research forecasts that by 2015 a total of 3.4m jobs in services will have moved abroad, but that is tiny compared with the 30m jobs destroyed and created in America every year. The trouble is that such studies allow only for the sorts of jobs that are already being off-shored, when in reality the proportion of jobs that can be moved will rise as IT advances and education improves in emerging economies.

Which of the following could be the best title for the text
[A] Business consulting.
[B] Blue-collar jobs.
[C] Non-tradable services.
[D] White-collar blues.


Alan Blinder, an economist at Princeton University, believes that most economists are underestimating the disruptive effects of off-shoring, and that in future two to three times as many service jobs will be susceptible to off-shoring as in manufacturing. This would imply that at least 30% of all jobs might be at risk. In practice the number of jobs off-shored to China or India is likely to remain fairly modest. Even so, the mere threat that they could be shifted will depress wages.
Moreover, says Mr. Blinder, education offers no protection. Highly skilled accountants, radiologists or computer programmers now have to compete with electronically delivered competition from abroad, whereas humble taxi drivers, janitors and crane operators remain safe from off-shoring. This may help to explain why the real median wage of American graduates has fallen by 6% since 9000, a bigger decline than in average wages.
In the 1980s and early 1990s, the pay gap between low-paid, low-skilled workers and high-paid, high-skilled Workers widened significantly. But since then, according to a study by David Autor, Lawrence Katz and Melissa Kearney, in America, Britain and Germany workers at the bottom as well as at the top have done better than those in the middle-income group. Office cleaning cannot be done by workers in India. It is the easily standardised skilled jobs in the middle, such as accounting, that are now being squeezed hardest. A study by Bradford Jensen and Lori Kletzer, at the Institute for International Economics in Washington D. C., confirms that workers in tradable services that are exposed to foreign competition tend to be more skilled than workers in non-tradable services and tradable manufacturing industries.

单项选择题