设有关系模式:student(sno,same,age,dept),现利用命令:CREATE VIEWStu ASSELECT*FROMStudent WHE
设有关系模式:student(sno,same,age,dept),现利用命令:CREATE VIEWStu ASSELECT*FROMStudent WHERE dept=“cs”WITHCHECK OPTION创建一个视图。则以下SQL命令中能正确执行的是
A. UPDATEStuSET dept=“maths”
B.UPDATEStuSET dept=“maths”WHEREage>=20
C.INSERT INTOStu VALUES(“2004001”,“John”,30,“cs”)
D.INSERT INTOStu VALUES(“2004001”,“John”,50,“maths”)