创建视图的语句正确的是_____。
A: create view view_1asselect * from tb_joinDepot
B: create table tb_1asselect * from tb_joinDepot
C: create schema sc_1asselect * from tb_joinDepot
D: create column col_1asselect * from tb_joinDepot
A: create view view_1asselect * from tb_joinDepot
B: create table tb_1asselect * from tb_joinDepot
C: create schema sc_1asselect * from tb_joinDepot
D: create column col_1asselect * from tb_joinDepot
举一反三
- 建立信息系选修了1号课程的学生视图，正确的SQL语句为（） A: CREATE VIEW IS_S1 ASSELECT Student.Sno，Sname，Grade FROM Student，SCWHERE Sdept= 'IS' AND Student.Sno=SSno AND SCno= '1'； B: CREATE VIEW IS_S1 (Sno，Sname，Grade) ASSELECT Student.Sno，Sname，Grade FROM Student，SCWHERE Sdept= 'IS' AND SCno= '1'； C: CREATE VIEW IS_S1 (Sno，Sname，Grade) ASSELECT Student.Sno，Sname，GradeFROM Student，SC WHERE Sdept= 'IS' ANDStudent.Sno=SSno AND SCno= '1'
- 有如下SQL语句 CREATE VIEW stock_view ASSELECT*FROM stock WHERE交易所=“深圳” 执行该语句后产生的视图包含的记录个数是 A: 1 B: 2 C: 3 D: 4
- 在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;
- 创建视图stu的语句为:CREATE VIEW ss AS【1】* FROM s_view WHERE score>=60
- 基于表S创建视图R的SQL语句是【 】 A: CREATE R AS SELECT 学号，姓名 FROM S B: CREATE TABLE R AS SELECT 学号，姓名 FROM S C: CREATE VIEW R AS SELECT 学号，姓名 FROM S D: CREATE R FROM SELECT 学号，姓名 AS S