题目
对于学生信息表S(SNUMBER,SNAME,SEX,AGE,DEPT)(STUDENT 由学号 SNO,姓名SNAME,性别SEX,年龄AGE,所在系DEPT5个属性组成,其中SNUMBER为主码),求年龄20~23岁之间的学生姓名和年龄,正确的语句是()。
A.SELECT SNAME,AGE FROM S WHERE AGE>20 AND AGE<23
B.SELECT SNAME,AGE FROM S WHERE AGE BETWEEN 20 AND 23
C.SELECT *FROM S WHERE. AGE BETWEEN 20 AND 23
D.以上均不正确
第1题
对于学生信息表S(SNUMBER,SNAME,SEX,AGE,DEPT)(STUDENT由学号SN0,姓名SNAME,性别SEX,年龄AGE,所在系DEPT5个属性组成,其中SNUMBER为主码),求年龄20~23岁之间的学生姓名和年龄,正确的语句是()。
A) SELECT SNAME, AGE FROM S WHERE AGE>20 OR AGE<23
B) SELECT SNAME, AGE FROM S WHERE AGE BETWEEN 20 AND 23
C) SELECT * FROM S WHERE AGE BETWEEN 20 AND 23
D) 以上均不正确
第2题
对于学生信息表:student(sno,sname,sex,age,dept),能够得到年龄在20岁到22岁之间的学生的姓名和学号的语句是
A.SELECT * FROM student WHERE age BETWEEN 20 AND 22
B.SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22
C.SELECT sname,sno FROM student WHERE age>=20
D.SELECT sname,sno FROM student WHERE age<=22
第3题
对于学生信息表:student(sno,sname,sex,age,dept),能够得到年龄在20岁到22岁之间的学生的姓名和学号的语句是
A.SELECT*FROM student WHERE age BETWEEN 20 AND 22
B.SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22
C.SELECT sname,sno FROM student WHERE age>=20
D.SELECT sname,sno FROM student WHERE age<=22
第4题
对于学生信息表:student(sno,sname,sex,age,dept),能够得到年龄在20岁于22岁之间的学生的姓名和学号的语句是
A.SELECT * FROM student WHERE age BETWEEN 20 AND 22
B.SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22
C.SELECT sname,sno FROM student WHERE age>=20
D.SELECT sname,sno FROM student WHERE age<=22
第5题
第6题
基于学生.课程数据库中的三个基本表:
学生信息表:s (snumber, sname, sex, age, dept)主码为snumber
课程信息表:c(cnumber, cname,teacher)主码为cnumber
学生选课信息表:sc(snumber, cnumber, grade)主码为(snumber, cnumber)
“从学生选课信息表中找出无成绩的元组”的SQL语句是()。
A)SELECT ﹡FROM sc WHERE grade=NULL
B)SELECT﹡FROM sc WHERE grade IS "
C)SELECT﹡FROM sc WHERE grade IS NULL
D)SELECT﹡FROM sc WHERE grade=''
第7题
对于学生信息表:student(sno,sname,sex,age,dept),能够得到年龄在20岁到22岁之间的学生的姓名和学号的语句是
A.SELECT * FROM student WHERE age BETWEEN 20 AND 22
B.SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22
C.SELECT sname,sno FROM student WHERE age>=20
D.SELECT sname,sno FROM student WHERE age<=22
第8题
对于学生信息表:student(sno, sname, sex, age, dept),能够得到年龄在20岁于22岁之间的学生的姓名和学号的语句是
A.SELECT * FROM student WHERE age BETWEEN 20 AND 22
B.SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22
C.SELECT sname,sno FROM student WHERE age>= 20
D.SELECT sname,sno FROM student WHERE age<= 22
第9题
对于学生信息表:student(sno,sname,sex,age,dept),能够得到年龄在20岁于22岁之间的学生的姓名和学号的语句是
A.SELECT * FROM student WHERE age BETWEEN 20 AND 22
B.SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22
C.SELECT sname,sno FROM student WHERE age>=20
D.SELECT sname,sno FROM student WHERE age<=22
第10题
对于学生信息表:student(sno, sname, sex, age, dept),能够得到年龄在20岁于22岁之间的学生的姓名和学号的语句是
A.SELECT * FROM student WHERE age BETWEEN 20 AND 22
B.SELECT sname, sno FROM student WHERE age BETWEEN 20 AND 22
C.SELECT sname,sno FROM student WHERE age>=20
D.SELECT shame,sno FROM student WHERE age<=22
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!