问题 单项选择题

若执行下面列出的操作,哪个操作不能成功执行()

A. 从DEPT中删除部门号='03'的行

B. 在DEPT中插入行('06','计划部','6号楼')

C.将DEPT中部门号='02'的部门号改为'10'

D. 将DEPT中部门号='01'的地址改为'5号楼'

答案

参考答案:C

解析:

本题考查参照完整性的应用。

[解题要点] 分析同上题,雇员信息表的外键是“部门号”,而“部门号”是部门信息表的主键,所以如果把部门信息表中某记录的“部门号”'02'改为'10'。则雇员信息表中'02'部门号在部门信息表中不存在,这将破坏关系的参照完整性。

[考点链接] 实体完整性规则、用户定义的完整性。

阅读理解

阅读理解。

       In 1896, the first modem Olympic Games was held in Athens, Greece. Since then many

countries have successfully held the Olympics, such as the UK, France , Cermany, Canada, the USA ,

Spain and Australia.

       After more than a century the Games returned to its hometown in 2004.

       When people hold the Olympic Games, they always make an emblem (会徽). The emblem of the

2004 Athens Olympic Games is a white circle of oliver branches in the sky.

        

      Now Athens is developing a spirit of peace (和平). An officer said "While in Athens, the world

should be at peace. We hope the peace is not just for a short time. We would like the message from

the Athens Games to help countries come together and solve their problems."

      In 2008, the Olympic Games will be held in China. And China has already made a seal as the

emblem of the Beijing 2008 Olympic Games.The emblem has a single Chinese character on a red seal

and means "Chinese seal-dancing Beijing". Below it, there are the words "Beijing 2008". The character

in the emblem is "Jing". It means "capital" of China and it is also like a runner or a dancer. The running

figure (人形) of the emblem shows the spirit of the Olympics—faster, higher and stronger.

1. In which country was the first modem Olympics held?

A. In Greece. 

B. In China. 

C. In Australia.  

D. In France.

2. What do people always make when they hold the Olympic Games?

A. picture    

B. An emblem 

C. A flag 

D. A map

3. What message does the Athens Olympic Games want to give?

A. War 

B. Luck 

C. Danger 

D. Peace. 

4. How many years have passed when Athens again holds the Olympic Games?     

A. 100

B. 104

C. 108 

D. 112

5. The spirit of the 2008 Olympic Games is _____.

A. history and friendship

B. faster, higher and stronger

C. running and dancing  

D. peace, friendship and development

单项选择题