APPEND INTO student VALUES('0401','王芳','女',18)
APPEND student VALUES('0401','王芳','女',18)
INSERT INTO student VALUES('0401','王芳','女',18)
INSERT student VALUES('0401','王芳','女',18)
第1题:
使用SQL语句从表STUDENT中查询所有姓王的同学的信息,正确的命令是:A)SELECT*FROM STUDENT WHERE LEFT(姓名,2)=“王”B)SELECT*FROM STUDENT WHERE RIGHT(姓名,2)=“王”C)SELECT*FROM STUDENT WHERE TRIM(姓名,2)=“王”D)SELECT*FROM STUDENT WHERE STR(姓名,2)=“王”
第2题:
若给出关系Student(S_no,Shame,Sage,S_sex,SD_name,S_add,S_tel),并用SQL语言定义Student关系如下:CREATE Student(S_no CHAR(6), Sname CHAR(30)NOT NULL, Sage CHAR(30), S_sex CHAR(1), SD_name CHAR(20), S_add CHAR(30), S_tel CHAR(20), PRIMARY KEY(S_no));采用(41)向Student中插入记录能被正确地执行。
A.INSERT INTO Smdent(S_no,Sname,Sage,S_sex,SD_name,S_add,S_tel)VALUES('010456','黎敏','18',",",",")
B.INSERT INTO Student(S_no,Sname,Sage,S_sex,S_r)name,S_add,S_tel)VALUES('010456','黎敏','18','男','计算机学院','北京','88661200')
C.INSERT INTO Student(S_no,Sname,Sage,S_sex,SD_name,S_add,S_tel)VALUES(,'黎敏','18','F','计算机学院','北京','88661200')
D.INSERT INTO Student(S_no,Sname,Sage,S_sex,SD_name,S_add,S_tel)VALUES('010456',,'18','F','计算机学院','北京','88661200')
第3题:
使用SQL语句向学生表S(SNO,SN,AGE,SEX)中添加一条新记录,字段学号(SNO)、姓名(SN)、性别(SEX)、年龄(AGE)的值分别为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,’女’)
第4题:
向职工表中插入一条记录,正确的命令是( )。
A.APPEND BLANK 职工 VALUES("33","3305","李运来","2700.00")
B.APPEND INTO 职工 VALUES("33","3305","李运来",2700.00)
C.INSERT INTO 职工 VALUES("33","3305","李运来","2700.00")
D.INSERT INTO 职工 VALUES("33",”3305","李运来",2700.00)
第5题:
根据SQL标准,增加一条记录到表student,学号sno是11301,姓名sname是“snoopy”,年龄age是20。其中student表中包括学号、姓名、年龄、籍贯、系别等属性,并且属性除sno外皆可取空值。下面哪条是参考的?()
A insert into student values(sno=11301, sname=’snoopy’, age =20)
B insert into student(sno,sname,age) values(11301,’snoopy’,20)
C insert into student set sno=11301, sname=’snoopy’, age = 20
D insert into student values (11301, ’snoopy’, 20)
第6题:
向职工表中插入一条记录的正确语句是( )。
A.APPEND BLANK职工VALUES("33","3305","李运来","2700.00")
B.APPEND INTO职工VALUES("33","3305","李运来",2700.00)
C.INSERT INTO职工VALUES("33","3305","李运来","2700.00")
D.INSER INTO职工VALUES("33","3305","李运来",2700.00)
第7题:
向信息系学生视图IS_ STUDENT中插入一个新的学生记录,其中,学号01028,姓名为小红,年龄为18岁,正确的SQL语句是( )。
A.INSERT INTO IS_ STUDENT VALUES('01029','小红',18)
B.INSERT INTO IS_ STUDENT VALUES(01029,'小红',18)
C.SELECT INTO IS_ STUDENT VALUES(01029,小红,18)
D.SELECT INTO IS_ STUDENT VALUES('01029','小红',18)
第8题:
向学生表插入一条记录的正确命令是A)APPEND INTO学生VALUES("10359999",‘张三’,‘男’,‘会计’,{^1983-10-28})B)INSERT INTO学生VALUES("10359999",‘张三’,‘男’,{^1983-10-28},‘会计’)C)APPEND INTO学生VALUES("10359999",‘张三’,‘男’,{^1983-10-28},‘会计’)D)INSERT INTO学生VALUES("10359999",‘张三’,‘男’,{^1983-10-28})
第9题:
向职工表中插入一条记录,正确的命令是
有职工表如下:
职工表(部门号N(4)、职工号C(4)、姓名C(8)、工资N(7,2))
A.APPEND BLANK 职工表 VALUES("1111","1101","王明","1500.00")
B.APPEND INTO 职工表 VALUES("1111","1101","王明",1500.00)
C.INSERT INTO 职工表 VALUES("1111","1101","王明","1500.00")
D.INSERT INTO 职工表 VALUES("1111","1101","王明",1500.00)
第10题:
向学生表插入一条记录的正确命令是( )。
A.APPEND INTO学生VALUES("10359999",'张三','男','会计',{^1983-10-28})
B.INSERT INTO学生VALUES("10359999",'张三','男',{^1983-10-28),'会计')
C.APPEND INTO学生VALUES("10359999",'张三','男',{^1983-10-28},'会计')
D.INSERT INTO学生VALUES("10359999",'张三','男',{^1983-10-28})