在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;

下列【视图】创建语句错误的是？ 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;

基于表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

SQL的数据操纵命令是（ ） A: select、insert、delete、update B: create、select、insert、delete C: create、insert、delete、update D: select、insert、delete、alter

下面定义视图的SQL语句，哪一个是错误的？（ ） A: create view VIEW1 as select id,name,sex from users B: create view VIEW2 as select count(*) as studentTotal,classname from student C: create view VIEW3 as select name,price from D: create view VIEW4 as select logdate,price,1.1*parice as ‘涨价’ from shop

建立信息系统学生的视图是（） 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';

【单选题】下列代码为创建图书视图的代码,请选择所缺少的部分代码。 ( _______________ ) v_book (barcode,bookname,author,price,booktype) ( _______________ ) barcode,bookname,author,price,typename FROM tb_bookinfo AS b ,tb_booktype AS t WHERE b.typeid=t.id; A. CREATE VIEW 、 AS SELECT B. CREATE VIEW 、 SELECT C. CREATE TABLE 、 AS SELECT D. CREATE TABLE 、 SELECT

请选择正确的视图创建语句() A: create view视图名as select语句 B: create show视图名as select语句 C: create view视图名as insert语句 D: create show视图名as insert语句

Which of the following is not a system privilege?() A: SELECT B: UPDATE ANY C: CREATE VIEW D: CREATE SESSION

在mysql中,创建视图使用( )语句 A: create table B: create view C: select