• 2022-06-07 问题

    请看如下的创建视图PARTS_VIEW的DDL语句: CREATE OR REPLACE parts_view 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);

    请看如下的创建视图PARTS_VIEW的DDL语句: CREATE OR REPLACE parts_view 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);

  • 1