题目内容

视图定义中的 SELECT 子句可以包括下列内容（）。

A. CHECK OPTION
B.INTO 关键字
C.OPTION 子句
D.引用临时表或表变量

查看答案

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

更多问题

下面定义视图的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

查看答案

删除视图的SQL命令是（ C ）

A. delete view
B.edit view
C.drop table
D.alter view

查看答案

下面关于修改视图的SQL语句，那个是正确的（）。

A.alter view VIEW01 as select * from users order by age desc
B.alter view VIEW02 as select name,avg(score) as avgScore from studentScore
C.alter view VIEW03 as select top 10 id,name,password from admin order by id
D.alter view VIEW04 as select * from stuent,class where student.classid=class.classid order by class.classid

查看答案