超星 - 项目6之综合在线练习题（客观题）

单选题

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

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

单选题

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

查看答案

判断题