题海让大学四年没有难题
白天模式登陆

题目详情

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

A. DELETE FROM Student WHERE StudentName = '李正华'

B. DELETE FROM Student WHERE ClassID = 'Cs021001' and YEAR(Birth) = 1992

C. DELETE FROM Student WHERE StudentID = 'St0210010007'

D. DELETE FROM Student WHERE ClassID = 'Cs021001' and StudentName LIKE '李%'

数据库原理与应用课程封面

学科：数据库原理与应用

时间：2023-05-15 14:20:45

相关题目

相关作业

题目1
单选题
从Grade成绩表中对学号尾号为2的学生加两分,以下操作正确的是
A. UPDATE Grade SET Grade = Grade + 1 WHERE StudentID LIKE '%1'B. UPDATE Grade SET Grade = Grade + 2 WHERE StudentID LIKE '%2'C. UPDATE Grade SET Grade = Grade + 2 WHERE StudentID = '%2'D. UPDATE Grade SET Grade = Grade + 2 WHERE StudentID != '%1'
题目2
多选题
以下哪些操作会改变数据库的内容
A. 插入B. 更新C. 删除D. 查询
题目3
多选题
向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' )
题目4
多选题
李正华同学入学一年后转学了,需要从Student学生表中删除他的信息. 以下哪些方式能正确删除他的学生信息
A. DELETE FROM Student WHERE StudentName = '李正华'B. DELETE FROM Student WHERE ClassID = 'Cs021001' and YEAR(Birth) = 1992C. DELETE FROM Student WHERE StudentID = 'St0210010007'D. DELETE FROM Student WHERE ClassID = 'Cs021001' and StudentName LIKE '李%'
Copyright © 2022 津ICP备2021001502号