问题 单项选择题

有一个关系:学生(学号,姓名,系别),规定学号的值域是8个数字组成的字符串,这一规则属于

A.实体完整性约束

B.参照完整性约束

C.用户自定义完整性约束

D.关键字完整性约束

答案

参考答案:C

解析: 关系的约束条件也称为关系的数据完整性规则。它是对关系的一些限制和规定。它包括实体完整性、参照完整性和用户定义完整性。实体完整性:这条规定的现实意义是,关系模型对应的是现实世界的数据实体,而关键字是实体惟一性的表现,没有关键字就没有实体,所有关键字不能是空值。这是实体存在的最基本的前提,所以称之为实体完整性。参照完整性;参照完整性规则也可称为引用完整性规则。这条规则是对关系外部关键宇的规定,要求外部关键字的取值必须是客观存在的,即不允许在一个关系中引用另一个关系不存在的元组。用户定义完整性:由用户根据实际情况,对数据库中数据的内容所作的规定称为用户定义的完整性规则。通过这些限制数据库中接受符合完整性约束条件的数据值,不接受违反约束条件的数据,从而保证数据库的数据合理可靠。

完形填空
完形填空。
         Once upon a time , there was a child ready to be born. So     1      he asked God, "They tell me you are
sending me to       2      , but being so small and helpless,     3        am I going to live there?"
        "     4      the many angels (天使), I chose the best one for you. She will be waiting for you and will take
care of you." God replied.
        "But here in heaven (天堂), I do     5       else but sing and smile! That's enough for me to be happy."
        God said, "Your angel will sing and smile for you every day. And you will feel your angel's love and you'll
be    6      ."
        The child said, "And how am I going to be able to understand when people talk to me     7     I don't know
the language that men speak?" God told the child, "Your angel will tell you the most beautiful and sweetest words you will ever hear, and with      8     patience (耐心) and care, your angel will teach you     9      .
        The child said, "I've     10      that on the earth there are bad men, who will protect me?"
        God said, "Your angel will protect you     11     it means risking her life (冒生命危险)."
       "But I will always be sad because I will not see you any more."
       "Your angel will always talk to you about     12      and in face, I will always be next to you."
        At the moment there was much peace in Heaven, but voices from the earth could already be heard, and
the child, in a hurry, asked, "Oh, God, since I am about to    13     now, please tell me my angel's    14      !"
        "It is not hard to remember," God replied     15      . "You will call your angel Mommy."
( )1. A. every day   
( ) 2. A. the earth  
( ) 3. A. where      
( ) 4. A. Between    
( ) 5. A. nothing    
( ) 6. A. lonely     
( ) 7. A. though     
( ) 8. A. no         
( ) 9. A. where to go
( )10. A. heard      
( )11. A. when       
( )12. A. me         
( )13. A. die        
( )14. A. address    
( )15. A. angrily    
B. any day        
B. the moon     
B. how            
B. For            
B. everything     
B happy         
B. whether       
B. little              
B. how to speak    
B. remembered    
B as soon as      
B. you            
B. work           
B. name          
B. sadly      
C. one day        
C. the country    
C. why          
C. Among       
C. anything     
C. excited      
C. after        
C. much          
C. what to say 
C. forgotten    
C. since        
C. us           
C. study        
C. number       
C. softly     
D. some day        
D. the sea         
D. when            
D. With            
D. something         
D. surprised        
D. if               
D. some             
D. Which to choose 
D. said           
D. even if         
D. her             
D. leave           
D. job               
D. shyly          
单项选择题