将Student表中的Sno属性定义为码CREATE TABLE Student(Sno CHAR (9) _______________,Sname CH
将Student表中的Sno属性定义为码
CREATE TABLE Student
(Sno CHAR (9) _______________,
Sname CHAR (20) NOT NULL,
Ssex CHAR (2),
Sage SMALLINT,
Sdept CHAR (2)
);
将Student表中的Sno属性定义为码
CREATE TABLE Student
(Sno CHAR (9) _______________,
Sname CHAR (20) NOT NULL,
Ssex CHAR (2),
Sage SMALLINT,
Sdept CHAR (2)
);
第1题
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)
第2题
A select max(age) from student
B select sno from student where age = max(age)
C select sno from student having age = max(age)
D select sno from student a where a.age<= (select min(b.age) from student b)
第3题
根据SQL标准,查询表student(sno,sname,sex,dept)中所有学生的选修课程数,其中选修记录在表SC(sno,cno,grade)中,两表中sno为关联字段。下面哪条语句合适?()
A select sno,count(cno) from SC
B select sno,count(cno) from student
C select a.sno,count(cno) from student a left outer join SC
D select a.sno,count(cno) from SC left outer join student a
第4题
T.对
F.错
第5题
A.SelectSnofromStudentwhereSno=9527
B.Select*fromStudentwhereSno=9527
C.SelectfromStudentwhereSno=9527
D.Select*fromSnowhereSno=9527
第6题
根据SQL标准,删除表student中对字段sno的唯一性约束,应该使用下面哪条语句? ()
A drop sno from table student
B alter table student drop sno
C alter table student drop unique(sno)
D alter table student drop sno unique
第7题
A.正确
B.错误
第8题
已知有基本表:学生:S(SNO,SNAME,SEX,DEPT,SAGE)
课程:C(CNO,CNAME,PCNO)
选课:SC(SNO,CNO,G)
1.定义学生选课SC表。在定义模式的同时,要完成如下完整性约束定义:
①定义主码②定义参照完整性
2.查询全体学生的详细记录
3.查询全体学生的姓名及其学号。
4.查询年龄在20岁以下的学生姓名和年龄。
5.查询选修2号课程且成绩在90分以上的所有学生
第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)
第11题
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)