更多"设有关系模式:student (sno,sname,age,dept)"的相关试题:
[单项选择]设有关系模式: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,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 ("2004001", "John", 50, "maths")
[单项选择]设有关系模式student(sno,sname,age),则约束“age BETWEEN 20 AND 40”属于哪一类关系完整性规则
A. 实体完整性规则
B. 参照完整性规则
C. 用户定义的完整性规则
D. 引用完整性规则
[单项选择]对于学生信息表:student(sno, sname, sex, age, dept),能够得到年龄在20岁于22岁之间的学生的姓名和学号的语句是
A. SELECT * FROM student WHERE age BETWEEN 20 AND 22
B. SELECT sname, sno FROM student WHERE age BETWEEN 20 AND 22
C. SELECT sname,sno FROM student WHERE age>=20
D. SELECT shame,sno FROM student WHERE age<=22
[单项选择]对于学生信息表:student(sno, sname, sex, age, dept),如果把学生“张明”的姓名改为“张岩”,则正确的语句是