问题 单项选择题

若用如下的SQL语句创建一个表S: CREATE TABLE S(S# char (16) NOT NULL; SNAME char(8) NOT NULL, SEX char(2), AGE integer) 向表S中插入如下行时,哪一行可以被插入

A.(’991001’,’李明芳’,女,’23’)

B.(’990746’,’张民’,NULL,NUL

C.(NULL,’陈道明’,’男’,35)

D.(’992345’,NULL,’女’,25)

答案

参考答案:B

解析: 根据该表的语法,S#,SName不能为空,因此选项C),D)不能被插入。在选项A)中,由于各列均为字符,所以应用引号表示,而该选项中的“女”没加引号,所以选项A)也不能被插入。

完形填空
完形填空。
     Smiles and tears are part of life. But do you find enough time for    1    ? I'm not asking if you
experience lots of good times. Of course, we should laugh during the happy times. But do you    2    
laugh during the difficult times?
     Erma Bombeck is known for her funny books. But she wrote    3    about a more serious
subject-cancer (癌症) in children. The book is titled, I WANT TO GROW    4   , I WANT TO GROW
UP. Erma talks with many children who    5    cancer and learns important lessons from them. She
learns, for example, that cancer survivors (幸存者) know how to smile at life, though they are
receiving chemotherapy (化疗).
     She tells about the experience of    6    Jessica. Jessica's leg was cut off at the knee because of
cancer. She was learning to wear a prosthesis (假肢). Jessica told about playing soccer. She hit the
ball hard    7    her foot. The ball flew off in one direction (方向)    8    her man-made leg flew another
way. Then the brave girl lay on the floor, laughing happily.
     As the saying goes, "There's a time to cry and a time to laugh." Do you find    9    time to laugh?
     Survivors know    10   . If you can laugh even when you're in trouble, you will make it. Remember,
laugh and the whole world laugh with you. Cry and you cry alone!
(     )1. A. calling      
(     )2. A. either       
(     )3. A. it           
(     )4. A. HAIR         
(     )5. A. has          
(     )6. A. 15 years old 
(     )7. A. in      
( )8. A. while    
(     )9. A. many           
(     )10. A. where to laugh
B. laughing    
B. too         
B. one           
B. NAILS (指甲)  
B. have        
B. 15-years-old 
B. with   
B. whenever    
B. plenty of     
B. who to laugh
C. crying       
C. also         
C. ones         
C. GRASS        
C. had             
C. 15-year-old 
C. under    
C. whether    
C. a lot        
C. how to laugh 
选择题