题目
A.PPEND INTO S(SNO,SN,SEX,AGEC)VALUES('0401','王芳','女',18)
B.PPEND S VALUES('0401','王芳',18,'女')
C.INSERT INTO S(SNO,SN,SEX,AGE)VALUES('0401','王芳','女',18)
D.INSERT S VALUES('0401','王芳',18,'女')
第1题
使用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,‘女’)
第2题
(28)使用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’,女,)
第3题
A.APPEND INTO S(SNO,SN,SXE,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 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,’女’)
第5题
如果学生表Student是使用下面的SQL语句创建的:
CREATE TABLE Student(SNO C(4) PRIMARY KEY NOT NULL,;
SN C(8),;
SEX C(2),;
AGE N(2) CHECK(AGE>15 AND AGE<30))
下面的SQL语句中可以正确执行的是( )。
A.INSERT INTO STUDENT(SNO,SEX,AGE)VALUES("S9","男",17)
B.INSERT INTO STUDENT(SN,SEX,AGE)VALUES("李安琦","男",20)
C.INSERT INTO STUDENT(SEX,AGE)VALUES("男",20)
D.INSERT INTO STUDENT(SNO,SN)VALUES("S9","安琦",16)
第6题
设有学生表S(SNO,SN)(SNO为学生号,SN为姓名)和学生选修课程表SC(SNO,CNO,CN,G)(CNO为课程号,CN为课程名,G为成绩),试用SQL语句完成以下操作:
建立一个视图V-SSC(SNO,SN,CNO,CN,G),并按CNO升序排序.
第7题
如果学生表STUDENT是使用下面的SQL语句创建的CREATE TABLE STUDENT (SNO C (4) PRIMARY KEY NOT NULL , ;SN C (8) , ;SEX C (2) , ;AGE N (2) CHECK (AGE>15 AND AGE<30 ))下面的SQL语句中可以正确执行的是A)INSERT INTO STUDENT(SNO,SEX,AGE)VALUES("S9","男",17)B)INSERT INTO STUDENT(SN,SEX,AGE)VALUES("李安琦","男",20)C)INSERT INTO STUDENT(SEX,AGE)VALUES("男",20)D)INSERT INTO STUDENT(SNO,SN) VALUES("S9","安琦",16)
第8题
如果学生表STUDENT是使用下面的SQL语句创建的CREATE TABLE STUDENT(SNO C(4)PRIMARY KEY NOT NULL,; SN C(8),; SEX C(2),; AGE N(2)CHECK(AGE>15 AND AGE<30))下面的SQL语句中可以正确执行的是
A.INSERT INTO STUDENT(SNO,SEX,AGE)VALUES(“S9”,“男”,17)
B.INSERT INTO STUDENT(SN,SEX,AGE)VALUES(“李安琦”,“男”,20)
C.INSERT INTO STUDENT(SEX,AGE)VALUES(“男”,20)
D.INSERT INTO STUDENT(SNO,SN)VALUES(“S9”,“安琦”,16)
第9题
A.A.INSERT INTO Student(SNO,SEX,AGE)VALUES("S9","男",17)
B.B.INSERT INTO Student(SN,SEX,AGE)VALUES("李安琦","男",20)
C.C.INSERT INTO Student(SEX,AGE)VALUES("男",20)
D.D.INSERT INTO Student(SNO,SN)VALUES("S9","安琦",16)
第10题
如果学生表STUDENT是使用下面的SQL语句创建的
CREATE TABLE STUDENT(SNO C(4) PRIMARY KEY NOT NULL,;
SN C(8),;
SEX C(2),;
AGE N(2) CHECK(AGE>15 AND AGE<30))
下面的SQL语句中可以正确执行的是
A.INSERT INTO STUDENT(SNO,SEX,AGE)VALUES (“S9”,“男”,17)
B.INSERT INTO STUDENT(SN,SEX,AGE)VALUES (“李安琦”,“男”,20)
C.INSERT INTO STUDENT(SEX,AGE)VALUES (“男”,20)
D.INSERT INTO STUDENT(SNO,SN)VALUES (“S9”,“安琦”,16)
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!