下列语法中，哪个是删除视图的语法（ ） A: DROP VIEW view_name B: DELETE VIEW view_name C: DROP view_name D: DELETE view_name

假如只想显示视图：EMPLOYEE_HIST的名字、视图的定义和视图定义的长度，请问应该使用以下SQL语句中的哪一个 A: SELECT B: * C: FROM D: user_views E: WHERE F: view_name=’EMPLOYEE_HIST’; G: SELECT H: view_name, text, text_length I: FROM J: user_views K: WHERE L: view_name=’EMPLOYEE_HIST’; M: SELECT N: view_name, text, text_length O: FROM VIEW P: user_obiects Q: WHERE R: view_name=’EMPLOYEE_HIST’; S: SELECT VIEW T: view_name, text, text_length U: FROM V: all_objects W: WHERE X: view_name=’EMPLOYEE_HIST’;

查看视图基本信息的命令是什么？ A: describe view_name B: show view_name C: show table view_name D: describe table view_name

下面哪个是错误的助手函数view调用？ A: return view("",["name"=>$myname,"id"=>$myid]); B: return view("",["name"=>myname]); C: return view("user/login"); D: return view("");

在tb_name表中创建一个名为name_view的视图,并设置视图的属性为name、pwduser,执行语句是什么?( ) A: CREATE VIEW name_view(name,pwd,user)AS SELECT name.pwd,user FROM tb_mame; B: SHOW VIEW name_view(name,pwd,user) AS SELECT name,pwd,user FROM tb_mame: C: DROP VIEW name_view(name,pwd,user) AS SELECT name,pwd,user FROM tb_mame: D: SELECT * FROM name_view(name,pwd,user) AS SELECT name,pwd,user FROM tb_ name:

向视图的名称怎样标注?How the name of directional view be marked?

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

下面关于“CREATE VIEW v_goods AS SELECT id, name FROM goods”描述错误的是

下面关于修改视图的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

Where is Tim?In a (1)________.What is another name for New York?The (2)_______.What does Tim say about the view?It's (3)_______.