[音频]Tom:IamwonderingwhattogivetoourforeignteacherMr.Nortonas ___1____whenIgotohishomethisSaturdayevening.Rachel:Mm,howaboutsomethingtoeatordrink?Tom:Yeah,Icangivehimabottleofhardliquor.Rachel:Oh,no.Youmustbecarefulingiving___2___. DoyouknowwhatMr.Nortondrinksusually?Tom:No,Idon’t.Howaboutsomeflowers?Everyonelikesthem.Icanget someroses…Rachel:RosesarecertainlynotforMr.Norton!Theyarefor___3___.Tom:Youareright!ButwhatcanIgivehim.Rachel:Perhaps ___4___ wouldbenice.Tom:Right!I’llgive___5___ toMr.Norton.Thankyousomuch!Rachel:Mypleasure.
从Grade成绩表中对学号尾号为2的学生加两分,以下操作正确的是:
A. UPDATE GradeSET Grade = Grade + 1WHERE StudentID LIKE '%1'
B. UPDATE GradeSET Grade = Grade + 2WHERE StudentID LIKE '%2'
C. UPDATE GradeSET Grade = Grade + 2WHERE StudentID = '%2'
D. UPDATE GradeSET Grade = Grade + 2WHERE StudentID != '%1'
向Student学生表中插入一条学生信息,以下操作正确的是:
A. INSERT INTO Student(StudentID,StudentName,Sex,Birth,HomeAddr,EntranceTime,ClassID)VALUES('St0210010007','李正华','男','1992-8-20','成都市都江堰迎宾大道341号','2010-09-12','Cs021001')
B. INSERT INTO Student(StudentID,StudentName,Sex,Birth,HomeAddr,EntranceTime)VALUES('St0210010007','李正华','男','1992-8-20','成都市都江堰迎宾大道341号','2010-09-12')
C. INSERT INTO Student(StudentID,StudentName,Sex,Birth,HomeAddr)VALUES('St0210010007','李正华','男','1992-8-20','成都市都江堰迎宾大道341号')
D. INSERT INTO Student(StudentID,StudentName,Sex,Birth)VALUES('St0210010007','李正华','男','1992-8-20')