问题 单项选择题

下列叙述中,错误的是______。

A.SQL中的UPDATE语句可以修改一条记录

B.SQL中的UPDATE语句可以修改多条记录

C.SQL中的UPDATE语句可以用子子询提供要修改的值

D.SQL中的UPDATE语句可以修改子查询的结果

答案

参考答案:D

解析: SQL中的UPDATE语句可以用WHERE指定的条件来修改一条记录和多条记录,如果WHERE子句省略,则可以修改表中所有记录;也可用子查询的结果作为要修改的值,还可用子查询选择要修改的行,但UPDATE 语句不能修改子查询的结果。

完形填空
完形填空。
     One Friday night, a poor young man stood at the train station. He played his violin and many people put  1  
into the hat in front of him.  
     The next day, the young man came to the station  2 . But this time he took out a large piece of paper  3  
some words on it. It said"Last night a lady  4  Mrs Sang put an important thing into my hat  5 . Please come
for it."  
    After about an hour, a middle-aged woman ran to the young man in a hurry and said, "You do come here.
I know that you're a(n)  6  man and will certainly come here." They had a talk and the young man made sure
she was the owner. Then he took out a lottery ticket and  7  it to the woman. Her husband bought a lottery
ticket every day. Yesterday when she knew the lottery ticket he bought won, she was very  8 . The prize of
the lottery ticket was $ 500,000. When she walked past the young man, she took out $50 and put it in the
hat.  9 , the lottery ticket was also thrown in.  
     Later, someone asked the young man, "You play the violin every day to make money. Why didn't you just
take the prize of the lottery ticket for yourself?" the young man said, "Although I don't have much money, I
live happily. But if I  10  honesty, I won't be happy forever." 
( )1. A. money    
( )2. A. instead  
( )3. A. for      
( )4. A. introduced
( )5. A. by mistake
( )6. A. crazy    
( )7. A. gave     
( )8. A. surprising
( )9. A. But      
( )10. A. have    
B. tickets   
B. differently
B. with      
B. spelled   
B. for mistake
B. cool      
B. lent      
B. happy     
B. However   
B. win       
C. paper   
C. again   
C. over    
C. named   
C. on mistake
C. honest  
C. offered  
C. exciting 
C. Therefore 
C. lose    
单项选择题