建立表Employee的视图Em_view，正确的SQL命令是

admin2015-08-25 21

问题建立表Employee的视图Em_view，正确的SQL命令是

选项 A、CREATE VIEW Em_view WHLIE SELECT 职工号,工资 FROM Employee
B、CREATE AS Em_view VIEW SELECT 职工号,工资 FROM Employee
C、CREATE VIEW Em_view AS SELECT 职工号,工资 FROM Employee
D、CREATE VIEW Em_view SELECT 职工号,工资 FROM Employee

答案C

解析可以直接用建立视图的SQL命令CREATE VIEW…AS…建立视图，C选项格式正确。

转载请注明原文地址:https://jikaoti.com/ti/mGr0FFFM

本试题收录于：二级VF题库NCRE全国计算机二级分类