以下定义的4个视图中,能够进行更新操作的是( )。
A.
CREATE VIEW S_AVG(,平均分) AS SELECT ,AVG(分数) FROM score WHERE 分数IS NOT NULL GROUP BY ;
B.
CREATE VIEW S_FEMALE(姓名,出生日期) AS SELECT 姓名,出生日期 FROM student WHERE 性别='女';
C.
CREATE VIEW S_MALE(,姓名) AS SELECT ,姓名 FROM student WHERE 班号='09031';
D.
CREATE VIEW S_G(,姓名,课程名,分数) AS SELECT S.,姓名,课程名,分数 FROM S, SC, C WHERE S.=SC. AND SC. 课程号 = C. 课程号;