假如只想显示视图：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: 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’;
举一反三
- 在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:
- 下列语法中，哪个是删除视图的语法（ ） A: DROP VIEW view_name B: DELETE VIEW view_name C: DROP view_name D: DELETE view_name
- 下面定义视图的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语句，那个是正确的（ ）。 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
- 下列哪些SQL语句可以查询出User表中name为张三的记录（）。 A: SELECT * FROM User WHERE name = ’张三’ B: SELECT * FROM User WHERE name = ’张三’ LIMIT 0，1 C: SELECT * FROM User WHERE name LIKE ’张三’ D: SELECT * FROM User WHERE name LIKE ’%张三%’