A: AS
B: SELECT
C: manufacturer_id, COUNT (part_id) TOTAL_PARTS
D: FROM
E: parts
F: GROUP BY manufacturer_id;
G: 基于以上PARTS_VIEW视图，可以使用如下哪个SQL语句A．SELECT *
H: FROM parts_view;
I: UPDATE parts_view
J: SET
K: total_parts=10000
L: WHERE manufacturer_id=3983;
M: DELETE FROM parts_view
N: WHERE
O: manufacturer_id=340394;
P: INSERT INTO parts_view
Q: VALUES (89485, 1009);
举一反三
- 下面定义视图的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
- There are usually three parts in an argumentative essay: theme part, evidence to support points of view, and conclusion.
- 下面关于修改视图的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
- 下列哪条语句可以创建视图( )。 A: create view v_student as select * from student; B: alter view v_student as select * from student; C: drop view v_student as select * from student; D: sp_help view v_student as select * from student;
- 在student表上创建view_stu视图,正确的语句是( )。 A: CREATE VIEW view_stu IS SELECT * FROM student; B: CREATE VIEW view_stu AS SELECT * FROM student; C: CREATE VIEW view_stu SELECT * FROM student; D: CREATE VIEW SELECT * FROM student AS view_stu;
内容
- 0
Freud’s theory of personality is structured into three parts, the id, ego, and______ .
- 1
建立信息系统学生的视图是（） A: CREATE VIEW is_student AS SELECT sno,sname,sage FROM student WHERE sdpt='is'; B: CREATE VIEW is_student SELECT sno,sname,sageFROM WHERE sdpt='is'; C: CREATE VIEW is_student AS select sno,sname,sage FROM WHERE sdpt='is' D: CREATE VIEW is_student AS SELECT sno,sname,sage WHERE sdpt='is';
- 2
下面关于“CREATE VIEW v_goods AS SELECT id, name FROM goods”描述错误的是
- 3
下列【视图】创建语句错误的是？ A: CREATE VIEW 视图名 AS SELECT语句; B: CREATE OR REPLACE VIEW 视图名 AS SELECT语句; C: CREATE VIEW 视图名 SELECT语句 WITH CHECK OPTION; D: CREATE VIEW 视图名 AS SELECT语句 WITH CHECK OPTION;
- 4
使用如下的DDL语句创建一个名为PARTS_VU的视图，请问基于这个视图，可以使用哪个命令 CREATE FORCE VIEW parts_vu (company, contact) A: AS SELECT B: manufacturername, contact_name C: FROM D: inventory E: WITH READ ONLY;A．UPDATE F: DELETE G: SELECT H: INSERT