问题 填空题

设有图书管理数据库:
图书(总编号C(6),分类号C(8),书名C(16),作者C(6),出版单位C(20),单价N(6,2))
读者(借书证号C(4),单位C(8),姓名C(6),性别C(2),职称C(6),地址C(20))
借阅(借书证号C(4),总编号C(6),借书日期D(8))
对于图书管理数据库的读者表,为工资属性增加有效性规则(工资大于等于0)和出错提示信息(工资应该大于等于0!)。请对下面的SQL语句填空:
ALTER TABLE 读者 ALTER 工资;
______

答案

参考答案:SET CHECK工资>=0 ERROR“工资应该大于等于0”

解析: SET CHECK设置有效性规则,ERROR指定出错提示信息。

单项选择题
填空题


In the following passage, there are 25 blanks representing words that are missing from the context. You are to put back in each of the blanks the missing word. Write your answers on the ANSWER SHEET. The time for this section is 25 minutes.
Of all the employed workers in the United States, 12.5 million are part of a temporary workforce. The United States Bureau of Labor Statistics counts 9.2 percent of workers as those who have (1) they term "alternative employment arrangements." The government predicts that temporary staffing agencies (2) experience growth of 49 percent by 2010. If numbers increase at the rate (3) , these companies will add 1.9 million new jobs by 2010. That’s more than any (4) industry.
Temporary workers were the first ones to be affected by the recent economic recession, but they are (5) to be the first to regain positions as the economy picks up and companies work to rebuild. Employers use temporary workers as a resource because (6) offer
flexibility and come at a low cost. Many temporaries are categorized as "independent contractors" instead of employees, (7) allows the employer to avoid (8) certain taxes. Because they are not required to offer benefits to temporary workers, companies can save a great deal of money by hiring temps. Usually, temporary workers can qualify (9) benefits if they work for a staffing company for a certain length of time. Most temps, however, do not continue with one company long (10) to qualify for them because they regard the position as a step on the ladder to a (11) position later.
According to Richard Wahlquist, president of the American Staffing Association, 75 (12) of temporary workers hope for transition out of the temporary staffing category (13) a period of time. Wahlquist finds that temporary workers spend about 11 weeks on various assignments before their (14) out of the temporary workforce. Many use temporary positions to gain experience and skills (15) they move on to better jobs. Wahquist says that the temp workforce as a whole turns (16) 400 percent each year.
Tom Dilworth, research director at the Employment Policies Institute, explains (17) some workers like having temporary jobs (18) it affords them a great deal of elasticity with time and everything. Some temps only have a limited (19) of time to work and temp agencies can help coordinate jobs to fit their schedules. Other sometimes-employees use temporary jobs to get an (20) to a company from the inside, to get a foot in the door of a certain business or career. (21) others take temporary positions in hopes their employers will change them over to permanent positions eventually.
Nearly all the industries in the United States use temporary workers. (22) to Tim Costello, coordinator of the North American Alliance for Fair Employment, the growth of temporary labor threatens (23) job security of permanent workers who fear replacement,as well as the temps who are more accustomed to turnover. He predicts that there will continueto (24) a gradual shift from permanent employees to contingent staffing, and that such a (25) in workplace demographics will "lead to lower wages, poorer working conditions, and more instability."