以下创建视图的语句中,正确的是
A: CREATE st_view AS SELECT sid,sname,ssex FROM stu
B: CREATE VIEW st_view SELECT sid,sname,ssex FROM stu
C: CREATE VIEW st_view AS sid,sname,ssex FROM stu
D: CREATE VIEW st_view AS SELECT sid,sname,ssex FROM stu
A: CREATE st_view AS SELECT sid,sname,ssex FROM stu
B: CREATE VIEW st_view SELECT sid,sname,ssex FROM stu
C: CREATE VIEW st_view AS sid,sname,ssex FROM stu
D: CREATE VIEW st_view AS SELECT sid,sname,ssex FROM stu
举一反三
- 建立信息系统学生的视图是（） A: CREATE VIEW is_student AS SELECT sno,sname,sage FROM student WHERE sdpt='is'; B: CREATE VIEW is_student SELECT sno,sname,sageFROM WHERE sdpt='is'; C: CREATE VIEW is_student AS select sno,sname,sage FROM WHERE sdpt='is' D: CREATE VIEW is_student AS SELECT sno,sname,sage WHERE sdpt='is';
- 在student表上创建view_stu视图,正确的语句是( )。 A: CREATE VIEW view_stu IS SELECT * FROM student; B: CREATE VIEW view_stu AS SELECT * FROM student; C: CREATE VIEW view_stu SELECT * FROM student; D: CREATE VIEW SELECT * FROM student AS view_stu;
- 针对数据库S_T，以下创建视图的命令不正确的是（ ）。 A: create view view1asselect sno,avg(grade)from scgroup by sno B: create view view2asselect sno,sname,sdeptfrom studentwhere sdept='CS' C: create view view3asselect sno,sage+20from studentwhere ssex='女' D: create view view4asselect student.sno,sname,sc.sno,cno,grade from sc,studentwhere sc.sno=student.sno and cno='1'
- 创建视图st:create view st ______ selcet * from gzqd
- 下列哪条语句可以创建视图( )。 A: create view v_student as select * from student; B: alter view v_student as select * from student; C: drop view v_student as select * from student; D: sp_help view v_student as select * from student;