在Visual FoxPro中,使用SQL命令将学生表STUDENT中的学生年龄AGE字段的值增加1岁,应该使用的命令
A.REPLACE AGE WITH AGE+1
B.UPDATE STUDENT AGE WITH AGE+1
C.UPDATE SET AGE WITH AGE+I
D.UPDATE STUDENT SET AGE=AGE+1
A.REPLACE AGE WITH AGE+1
B.UPDATE STUDENT AGE WITH AGE+1
C.UPDATE SET AGE WITH AGE+I
D.UPDATE STUDENT SET AGE=AGE+1
A.REPLACE AGE WITH AGE+1
B.MODIFY STUDENT SET AGE=AGE+1
C.ALTER STUDENT SET AGE WITH AGE+1
D.UPDATE STUDENT SET AGE=AGE+1
UPDATE student____.
A.REPLACE STUDENT年龄一年龄+1
B.REPLACE STUDENT年龄WITH年龄+1
C.UPDATE STUDENT SET年龄一年龄+1
D.UPDATE STUDENT年龄WITH年龄+1
A)UPDATE STUDENT SET年龄=年龄+1
B) UDDATE STUDENT年龄WITH年龄+1
C)REPLACE STUDENT年龄=年龄+1
D)REPLACE STUDENT年龄WITH年龄+1
A.APPEND INTO S (SNO,SN,SEX,AGE) VALUES (’0401’,’王芳’,’女’,18)
B.APPEND S VALUES (’0401’,’王芳’ ,18,’女’)
C.INSERT INTO S (SNO,SN,SEX,AGE) VALUES (’0401’,’王芳’,’女’,18)
D.INSERT S VALUES (’0401’,’王芳’,18,’女’)
A.删除一个字段
B.修改一个字段
C.增加一个新字段
D.增加一条新记录
A.INSERT命令可以将一条新记录插入表中
B.UPDATE命令可以更新表中已存在的记录
C.DEl.ETE命令可以删除表中已存在的记录
D.SELECT命令不能与GRUP BY一起使用
A. INSERT INTO STUDENT(SN,SEX,AGE)VALUES(”王磊”,”男”,20)
B. INSERT INTO STUDENT(SN0,SEX,AGE)VALUES(”S9”,”男”,17)
C. INSERT INTO STUDENT(SEX,AGE)VALUES(”男”,20)
D. INSERT INTO STUDENT(SN0,SN,AGE)VALUES(”S9”,”王磊”,14)
A.SELECT O
B.USE学生
C.SELECT学生
D.SELECT student