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

admin2015-08-25 41

问题建立表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://www.kaotiyun.com/show/5qEp777K

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