首页 > 计算机类 > 等级考试 > 计算机二级 > MySQL数据库程序设计 > 设有学生表 student ，包含的属性有学号 sno、学生姓名 sname、性别 sex、年龄 age、所在专业 smajor 。下列语句正确的是 ______。

设有学生表 student ，包含的属性有学号 sno、学生姓名 sname、性别 sex、年龄 age、所在专业 smajor 。下列语句正确的是 ______。

A.SELECT sno, sname FROM student ORDER BY snameUnionSELECT SRO, sname FROM student WHERE smajor="CS";
B.SELECT sno, sname FROM student WHERE sex="M"UnionSELECT Sno, shame, sex FROM student WHERE smajor="CS" ；
C.SELECT sno, sname FROM student WHERE sex="M"ORDER BY snameUnionSELECT sno，sname FROM student WHERE Stupor="CS"；
D.SELECT sno, sname FROM student WIlERE sex="M"UnionSELECT sno ，sname FROM student WHERE smajor="CS" ；

查看答案

正确答案： D
答案分析：无

包含此试题的试卷：

计算机二级mysql数据库程序设计练习题（五）

相关的试题

设有关系 Students (学号，姓名，年龄，性别，系别，家庭住址) ，其中，属性 “ 系名”是关系 DESP 的主键，用户要求访问 “家庭地址 ”的某个成分，如邮编、省、市、街道以及门牌号。关系 Students 的主键和外键分别是( )

A.SELECT sno, sname FROM student ORDER BY snameUnionSELECT SRO, sname FROM student WHERE smajor="CS";
B.SELECT sno, sname FROM student WHERE sex="M"UnionSELECT Sno, shame, sex FROM student WHERE smajor="CS" ；
C.SELECT sno, sname FROM student WHERE sex="M"ORDER BY snameUnionSELECT sno，sname FROM student WHERE Stupor="CS"；
D.SELECT sno, sname FROM student WIlERE sex="M"UnionSELECT sno ，sname FROM student WHERE smajor="CS" ；

设有关系 Students (学号，姓名，年龄，性别，系别，家庭住址) ，用户要求访问 “家庭地址 ”的某个成分，如邮编、省、市、街道以及门牌号，则 “家庭地址 ”是一个( )属性。

A.SELECT sno, sname FROM student ORDER BY snameUnionSELECT SRO, sname FROM student WHERE smajor="CS";
B.SELECT sno, sname FROM student WHERE sex="M"UnionSELECT Sno, shame, sex FROM student WHERE smajor="CS" ；
C.SELECT sno, sname FROM student WHERE sex="M"ORDER BY snameUnionSELECT sno，sname FROM student WHERE Stupor="CS"；
D.SELECT sno, sname FROM student WIlERE sex="M"UnionSELECT sno ，sname FROM student WHERE smajor="CS" ；

假定学生关系是S(S#，SNAME，SEX，AGE)，课程关系是 C(C#，CNAME，TEACHER)，学生选课关系是SC(S#，C#，GRADE)。要查找选修 "COMPUTER" 课程的 " 女" 学生姓名，将涉及到关系

A.SELECT sno, sname FROM student ORDER BY snameUnionSELECT SRO, sname FROM student WHERE smajor="CS";
B.SELECT sno, sname FROM student WHERE sex="M"UnionSELECT Sno, shame, sex FROM student WHERE smajor="CS" ；
C.SELECT sno, sname FROM student WHERE sex="M"ORDER BY snameUnionSELECT sno，sname FROM student WHERE Stupor="CS"；
D.SELECT sno, sname FROM student WIlERE sex="M"UnionSELECT sno ，sname FROM student WHERE smajor="CS" ；

检索所有比 "王华 "年龄大的学生姓名、年龄和性别。正确的SELECT 语句是

A.SELECT sno, sname FROM student ORDER BY snameUnionSELECT SRO, sname FROM student WHERE smajor="CS";
B.SELECT sno, sname FROM student WHERE sex="M"UnionSELECT Sno, shame, sex FROM student WHERE smajor="CS" ；
C.SELECT sno, sname FROM student WHERE sex="M"ORDER BY snameUnionSELECT sno，sname FROM student WHERE Stupor="CS"；
D.SELECT sno, sname FROM student WIlERE sex="M"UnionSELECT sno ，sname FROM student WHERE smajor="CS" ；

设有表示学生选课的三张表，学生 S(学号，姓名，性别，年龄，身份证号)，课程C(课号，课名)，选课 SC(学号，课号，成绩)，则表SC的关键字(键或码)为( )

A.SELECT sno, sname FROM student ORDER BY snameUnionSELECT SRO, sname FROM student WHERE smajor="CS";
B.SELECT sno, sname FROM student WHERE sex="M"UnionSELECT Sno, shame, sex FROM student WHERE smajor="CS" ；
C.SELECT sno, sname FROM student WHERE sex="M"ORDER BY snameUnionSELECT sno，sname FROM student WHERE Stupor="CS"；
D.SELECT sno, sname FROM student WIlERE sex="M"UnionSELECT sno ，sname FROM student WHERE smajor="CS" ；

学生表： Student 学生表 ( 学号，姓名，性别，年龄，组织部门 ) Course 课程表 ( 编号，课程名称 ) Sc 选课表 ( 学号，课程编号，成绩 ) 表结构如下： (1). 写一个 SQL语句，查询选修了’计算机原理’的学生学号和姓名 (2). 写一个 SQL语句，查询’周星驰’同学选修了的课程名字 (3). 写一个 SQL语句，查询选修了 5门课程的学生学号和姓名

A.SELECT sno, sname FROM student ORDER BY snameUnionSELECT SRO, sname FROM student WHERE smajor="CS";
B.SELECT sno, sname FROM student WHERE sex="M"UnionSELECT Sno, shame, sex FROM student WHERE smajor="CS" ；
C.SELECT sno, sname FROM student WHERE sex="M"ORDER BY snameUnionSELECT sno，sname FROM student WHERE Stupor="CS"；
D.SELECT sno, sname FROM student WIlERE sex="M"UnionSELECT sno ，sname FROM student WHERE smajor="CS" ；

学生表 student 包含 sname、sex、age 三个属性列，其中 age 的默认值是 20，执行 SQL语句 INSERT INTO student(sex,sname,age) VALUES("M","Lili",); 的结果是 ______。

A.SELECT sno, sname FROM student ORDER BY snameUnionSELECT SRO, sname FROM student WHERE smajor="CS";
B.SELECT sno, sname FROM student WHERE sex="M"UnionSELECT Sno, shame, sex FROM student WHERE smajor="CS" ；
C.SELECT sno, sname FROM student WHERE sex="M"ORDER BY snameUnionSELECT sno，sname FROM student WHERE Stupor="CS"；
D.SELECT sno, sname FROM student WIlERE sex="M"UnionSELECT sno ，sname FROM student WHERE smajor="CS" ；

设有学生表 student(sno,sname,sage,smajor) ，各字段的含义分别是学生学号、姓名、年龄和专业。要求输入一学生记录，学号为 100，姓名为张红，年龄为 20。以下不能完成如上输入要求的语句是 ______。

A.SELECT sno, sname FROM student ORDER BY snameUnionSELECT SRO, sname FROM student WHERE smajor="CS";
B.SELECT sno, sname FROM student WHERE sex="M"UnionSELECT Sno, shame, sex FROM student WHERE smajor="CS" ；
C.SELECT sno, sname FROM student WHERE sex="M"ORDER BY snameUnionSELECT sno，sname FROM student WHERE Stupor="CS"；
D.SELECT sno, sname FROM student WIlERE sex="M"UnionSELECT sno ，sname FROM student WHERE smajor="CS" ；

学生表 student 包含 sname、sex、age 三个属性列，其中 age 的默认值是 20，执行 SQL语句 INSERT INTO student(sex ，sname，age)VALUES("M","Lili",); 的结果是 ______。

A.SELECT sno, sname FROM student ORDER BY snameUnionSELECT SRO, sname FROM student WHERE smajor="CS";
B.SELECT sno, sname FROM student WHERE sex="M"UnionSELECT Sno, shame, sex FROM student WHERE smajor="CS" ；
C.SELECT sno, sname FROM student WHERE sex="M"ORDER BY snameUnionSELECT sno，sname FROM student WHERE Stupor="CS"；
D.SELECT sno, sname FROM student WIlERE sex="M"UnionSELECT sno ，sname FROM student WHERE smajor="CS" ；

查找学生表 student 中姓名的第二个字为 "t" 的学生学号 Sno 和姓名 sname，下面 SQL语句正确的是 ______。

A.SELECT sno, sname FROM student ORDER BY snameUnionSELECT SRO, sname FROM student WHERE smajor="CS";
B.SELECT sno, sname FROM student WHERE sex="M"UnionSELECT Sno, shame, sex FROM student WHERE smajor="CS" ；
C.SELECT sno, sname FROM student WHERE sex="M"ORDER BY snameUnionSELECT sno，sname FROM student WHERE Stupor="CS"；
D.SELECT sno, sname FROM student WIlERE sex="M"UnionSELECT sno ，sname FROM student WHERE smajor="CS" ；

网站内容收集于网络，如有侵犯您的权益，请联系：gl@lm158.com，感谢您的支持
神奇助手题库网