设有关系模式:student(sno, sname, age, dept),现利用命令:CREATE VIEW stu AS SELECT *FROM stu

Question

设有关系模式：student(sno, sname, age, dept)，现利用命令： CREATE VIEW stu AS SELECT *FROM student WHERE dept="cs"WITH CHECK OPTION 创建了一个视图。则以下SQl命令中能正确执行的是

A．UPDATE stu SET dept="maths"

B．UPDATE stu SET dept="maths"WHERE age＞=20

C．INSERT INTO stu VALUES ("2004001", "John", 30, "cs")

D．INSERT INTO stu VALUES ("2004001", "John", 50, "maths")

Answer 1

正确答案：C