删除视图STUDENT的命令是( )。
A.DELETE STUDENT VIEW
B.DELETE STUDETN
C.DROP STUDENT VIEW
D.DROP VIEW STUDENT
第1题:
删除视图STUDENT的命令是( )。
A.DELETE STUDENT VIEW
B.DELETE STUDETN
C.DROP STUDENT VIEW
D.DROP VIEW STUDENT
第2题:
创建一个名为RS的视图,用来显示所有学生的学号,姓名和平均成绩,下面正确的语句是__
A SELECT STUDENT.学号,STUDENT.姓名,SKB.平均成绩 WHERE STUDENT.学号 = SKB.学号 GROUP BY STUDENT.学号 INTO CURSOR RS
B CREATE VIEW RS AS SELECT STUDENT.学号,STUDENT.姓名,SKB.平均成绩 WHERE STUDENT.学号 = SKB.学号 GROUP BY STUDENT. 学号
C SELECT STUDENT.学号,STUDENT.姓名,SKB 平均成绩 WHERE STUDENT.学号 = SKB.学号 GROUP BY STUDENT.学号 INTO CURSOR RS
D CREATE VIEW RS AS SELECT STUDENT.学号,STUDENT.姓名,AVG(SKB.成绩) AS 平均成绩 WHERE STUDENT.学号 = SKB.学 号 GROUP BY STUDENT.学号
第3题:
一数据库名为student要想打开该数据库,应使用命令A)OPEN student B)OPEN DATA studentC)USE DATA student D)USE student
第4题:
删除视图STUDENT的命令是( )。
A.DELETE STUDENTVIEW
B.DELETE STUDETN
C.DROP STUDENTVIEW
D.DROPVIEW STUDENT
第5题:
由于学号(SN)为00291的学生已毕业,欲在关系“Student”中删除该学生的所有信息,用元组关系演算语言实现应为(53)。
A.GET W(Student): Student. SN = 00291' DELETE W
B.GET W: Student. SN = 00291'in Student DELETE W
C.HOLD W(student): Student. SN = 00291' DELETE W
D.HOLD W: Student. SN = 00291'in Student DELETE W
第6题:
“show databases like ‘student%’”命令可以显示出以下数据库( )
A.student_my
B.studenty
C.mystudent
D.student
第7题:
从student表删除年龄大于30的记录的正确SQL命令是( )。
A.DELETE FOR年龄>30
B.DELETE FROM student WHERE年龄>30
C.DELETE student FOR年龄>30
D.DELETE student WHERE年龄>30
第8题:
删除视图myview的命令是 ______。
A.DELETE myview VIEW
B.DEL ETE myview
C.DROP myview VIEW
D.DROP VIEW myview
第9题:
根据SQL标准,创建一个视图abc,通过该视图只能对表student中系dept为‘IS’的记录进行更新操作。下面哪条语句适用?()
A create view abc as select * from student where dept=’IS’
B create view abc as select * from student where dept=’IS’ with check option
C create view abc as student where dept=’IS’
D create view abc as select dept=’IS’ from student
第10题:
删除视图myview的命令是( )。
A.DELETE myview VlEW
B.DELETE myview
C.DROP myview VIEW
D.DROP VIEW myview