已知有student表,studentid为主键,现在表中共有10行记录,studentid列值从1到10创建视图:createviewdbo.view_studentasselect*fromdbo.student接着执行如下命令:deletefromview_studentwhere(studentid=8);然后执行查询命令:select*fromstudent;select*fromview_student;假定上述命令全部执行成功,将各自返回()行记录。()
A.9,9
B.9,10
C.10,10
D.10,9