题目内容

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

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 '李%'

查看答案