设有关系模式:student(sno,sname,age,dept),现利用命令:
CREATE VIEW stu AS SELECT*FROM student WHERE dept="CS"WITH CHECK OPTION
创建了一个视图。则下TSQL命令巾能正确执行的是______。
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:INSFRT INTO stu VALUES("2004001","John",50,"maths")
设有关系模式: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("200400l","John",50,"maths")
设有关系模式:student(sno,same,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”WHEREage>=20 C:INSERT INTO stu VALUES(“2004001”,“John”,30,“cs”) D:INSERT INTO stu VALUES(“2004001”,“John”,50,“maths”)
设有关系模式: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")
设有关系模式: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("200400l","John",50,"maths")
设有关系模式: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")
设有关系模式: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")