向已有表中添加新字段的SQL语句是()
A.Create Table
B.Alter Tablr
C.Drop
D.Create Index
A.Create Table
B.Alter Tablr
C.Drop
D.Create Index
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.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.每次向表中添加新记录时,Access会自动插入惟一顺序号
B.被删除的自动编号型字段的值会被重新使用
C.如果删除了表中含有自动编号字段的一个记录后,Access并不会对自动编号型字段进行重新编号
A.删除student表
B.删除student字段
C.删除student表中的记录
D.删除student数据库
A.select*fromuserwherelength(userid)< >8
B.select*fromuserwherelength(userid) >8
C.select*fromuserwherelength(userid)<8
D.select*fromuserwherelength(userid)< >8oruseridisnull
A.selectfirstname+'.'+lastnameas'name'fromemployee
B.selectfirstname+'.'+lastname='name'fromemployee
C.select'name'=firstname+'.'+lastnamefromemployee
D.selectfirstname,lastnamefromemployee