创建视图st:create view st ______ selcet * from gzqd
举一反三
- 在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;
- 授予用户test创建视图的权限，并允许他继续授权给其他用户创建视图的权限，正确的命令是（） A: grant create view to test B: evoke create view from test C: grant create view to test with admin option D: evoke create view from test with admin option
- 创建视图的语句正确的是_____。 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
- 创建视图stu的语句为:CREATE VIEW ss AS【1】* FROM s_view WHERE score>=60
- 以下创建视图的语句中,正确的是 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