在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. CREATE VIEW book view1(a_sort,a_book) AS SELECT sort,books,count(name)FROM tb_book;
B. CREATE VIEW book view1(a_sort,a_book) AS SELECT sort,books,FROM ib_book;
CREATE VIEW book viewl(a_sort,a_book) AS SELECT sort,books.WHERE FROM tb_ book;
D. 以上都不对
微信支付 
支付宝支付