有如下建立视图语句, CREATE VIEW V_stu_sc AS SELECT STU.SNO , STU.SNAME , STU.SSEX , STU.SAGE , SC.CNO , SC.SCORE FROM STU, SC WHERE STU.SNO=SC.SNO 下面的修改语句不能正确执行的是( )。
A.
update V_stu_sc set sname=‘张三’ where sno=’2005001’
B.
update V_stu_sc set sname=‘张三’,sage=23 where sno=’2005001’
C.
update V_stu_sc set sname=‘张三’,cno=5 where sno=’2005001’
D.
update V_stu_sc set sname=‘张三’,ssex=‘男’ where sno=’2005001’