题目内容

下列在student表上创建view_stu视图的语句中，正确的是

A. CREATE VIEW view_stu IS SELECT * FROM student;
B. CREATE VIEW view_stu AS SELECT * FROM student;
CREATE VIEW view_stu SELECT * FROM student;
D. CREATE VIEW SELECT * FROM student AS view_stu;

查看答案

搜索结果不匹配？点我反馈

更多问题

A. CREATE VIEW权限
B. USE VIEW权限
C. SHOW VIEW权限
D. CREATE TABLE权限

A. DECLARE VIEW
B. CREATE VIEW
C. SHOW VIEW
D. NEW VIEW

A. SELECT * FROM view_stu2;
B. CALL view_stu2(math,chin,sum);
C. SELECT * FROM view_stu2(math,chin,sum);
D. SELECT view_stu2;

A. 可以建立在单表上
B. 可以建立在两张表的基础上
C. 可以建立在两张或两张以上的表的基础上
D. 视图只能建立在单表上