根据SQL标准,创建一个视图abc,通过该视图只能对表student中系dept为‘IS’的记录进行更新操作。下面哪条语句适用?()
A.
create view abc as select * from student where dept=’IS’
B.
create view abc as select * from student where dept=’IS’ with check option
C.
create view abc as student where dept=’IS’
D.
create view abc as select dept=’IS’ from student