下面查询视图的写法正确的是哪一个?
A: select from 视图名称;
B: select * from 视图名称;
C: create view 视图名称 as select语句;
D: select * 视图名称;
A: select from 视图名称;
B: select * from 视图名称;
C: create view 视图名称 as select语句;
D: select * 视图名称;
举一反三
- 下列【视图】创建语句错误的是? A: CREATE VIEW 视图名 AS SELECT语句; B: CREATE OR REPLACE VIEW 视图名 AS SELECT语句; C: CREATE VIEW 视图名 SELECT语句 WITH CHECK OPTION; D: CREATE VIEW 视图名 AS SELECT语句 WITH CHECK OPTION;
- 请选择正确的视图创建语句() A: create view视图名as select语句 B: create show视图名as select语句 C: create view视图名as insert语句 D: create show视图名as insert语句
- 创建视图的语法格式是:Create view 视图名称( ) select 查询语句
- 不可对视图执行的操作有( ) A: select .. from 视图名称, 从视图表中查询数据 B: delete .. from 视图名称,从视图表中删除数据 C: create index .. on 视图名称( ), 在视图中创建索引
- 在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;