问题 填空题

在“学生表”中删除字段“籍贯”的有效性规则命令为;
ALTER TABLE 学生表 ALTER 籍贯

答案

参考答案:DROP CHECK

解析: 利用SQL语句可以删除表中字段的有效性规则,基本命令格式如下:
ALTER TABLE <表名>
ALTER [COLUMN] <字段名 1>[NULL|NOT NULL]
[SET DEFAULT <表达式>]
[SET CHECK<逻辑表达式>[ERROR <字符型文本信息>]]
[DROP DEFAULT]
[DROP CHECK]
其中,ALTER[COLUMN]<字段名 1>指出要修改列的字段名;NULL|NOT NULL指定字段可以为空或不能为空;SET DEFAULT<表达式>重新设置字段的缺省值;SET CHECK<逻辑表达式>[ERROR <字符型文本信息>]重新设置该字段的合法值,要求该字段的原有数据满足合法值;DROP DEFAULT删除默认值:DROP CHECK删除有效性规则。

阅读理解

Laura was married for 6 months. Her husband was using drugs. She didn’t want her son or her unborn baby to live that way, but she was afraid to ask her husband to leave. She left him a note instead. After reading the note, Laura’s husband waited for her to come home and then beat her and

her son.

He smashed(使……碎)dishes, pictures and toys and left the house in a terrible mess(混杂). He said it was all her fault. After Laura cleaned up the mess she went to the hospital. She was badly hurt all over her body, but the baby was fine.

Laura had little education and she never had a good paying job. She was ashamed to ask for help from the police, courts or women’s shelters. Laura wanted her marriage and family to work. Sometimes her husband was very nice to her. She decided to try harder se her children could have a home and a father. Laura joined a church and told a priest(牧师)about her problem.

But her husband kept using drugs and hurting the family. Finally, she told her husband she loved him, but they should live apart for a while. He beat her again. The priest had called and could tell Laura was in trouble. He came over to talk to her, He asked the husband to go out for a while. Laura packed up her kids and left. Her husband went to jail. Laura got a lot of help from groups that help women who have been beaten. Now she is in college, has her own apartment and works on special projects at a women’s shelter. “We got out , and it changed the life for me and my children. You can do it. You can break the cycle.” Laura said.

小题1: Laura’s husband treated her ________.

A.carefully

B.badly

C.coldly

D.carelessly小题2:. Why did Laura not leave her husband in the beginning?

A.Because she loved him very much.

B.Because he could make her live a rich life.

C.Because he was her son’s father.

D.Because she hoped to keep the family.小题3:. Which of the following is NOT true?

A. Now Laura works on a special project at a women’s shelter.

B. Laura had little education and she never had a good paying job.

C. After Laura cleaned up the mess, she went to the church.

D. Laura was ashamed to ask for help from organizations.

小题4:. Which do you think is this passage about?

A.Educational and social problems.

B.Working and housing.

C.Family violence(暴力).

D.Relationship between husband and wife.

选择题