题目内容

[音频]Tom:IamwonderingwhattogivetoourforeignteacherMr.Nortonas _1whenIgotohishomethisSaturdayevening.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'

查看答案

以下哪些操作会改变数据库的内容：

A. 插入
B. 更新
C. 删除
D. 查询

查看答案

向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')

查看答案

李正华同学入学一年后转学了，需要从Student学生表中删除他的信息。以下哪些方式能正确删除他的学生信息？

A. DELETE FROM StudentWHERE StudentName = '李正华'
B. DELETE FROM StudentWHERE ClassID = 'Cs021001' and YEAR(Birth) = 1992
C. DELETE FROM StudentWHERE StudentID = 'St0210010007'
DELETE FROM StudentWHERE ClassID = 'Cs021001' and StudentName LIKE '李%'

查看答案