单项选择题

用SQL命令生成含有字段职工号、姓名的视图,下列语句正确的是______。

A.CREATE VIEW ZG w AS SELECT职工号,姓名FROM职工
B.CREATE QUERY ZG w AS SELECT职工号,姓名FROM职工
C.CREATE VIEW ZG w AS SELECT职工号,姓名
D.CREATE QUERY ZG w AS SELECT职工号,姓名