登陆题目详情
多选题 以下哪些操作会改变数据库的内容
学科：数据库原理与应用
时间：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 '李%'
下载 题海APP
拍照搜题更快捷
- 海量题库
- 无搜索限制
- 快捷拍照搜题
