数据库SQL 语言 中," AGE IN(15,35 ) " 短语的正确含义是( ) 。
A:AGE = 15 AND AGE = 35 B:AGE = 15 OR AGE = 35 C:AGE < = 35 AND AGE > = 15 D:AGE < 35 AND AGE > 15
基于这样的三个表,即学生表S、课程表C和学生选课表SC,它们的结构如下:
S(S#,SN,SEX,AGE,DEPT)
C(C#,CN)
SC(S#,C#,GRADE)
其中:S#为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,C#为课程号,
CN为课程名,GRADE为成绩。
检索所有比“王华”年龄大的学生姓名、年龄和性别。正确的SELECT语句是( )。
A:SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE FROM S B:WHERE SN=’王华‘) C:SELECT SN,AGE,SEX FROM S D:WHERE SN=’王华’ E:SELECT SN,AGE,SEX FROM S F:WHEREAGE>(SELECTAGEWHERE SN=’王华’) G:SELECT SN,AGE,SEX FROM S H:WHERE AGE>王华AGE
(26) -(29) 题
假定学生关系是S(S#,SN,SEX,AGE) ,课程关系是C(C#,CNAME,TEACHER) ,学生选课关系是SC(S#,C#,GRADE) 。
检索所有比"王华"年龄大的学生姓名、年龄和性别。正确的SELECT语句是______。
A:SELECT SN,AGE,SEX FROM S
SHERE AGE> (SELECT AGE FROM S)
WHERE SN='王华') B:SELECT SN,AGE,SEX
FROM S
WHERE SN='王华' C:SELECT SN,ACE,SEX FROM S
WHERE AGE>(SELECT ACE
WHERE SN='王华') D:SELECT SN,ACE,SEX FROM S
WHERE ACE>王华 AGE
题中假定学生关系是S(S#,SN.,SEX,AGE),课程关系是C(C#,CNAME,TEACH-ER),学生选课关系是SC(S#,C#,GRADE)。
检索所有比“王华”年龄大的学生的姓名、年龄和性别,正确的SELECT语句是______。
A:SELECT SN,AGE,SEX FROM S
SHERE AGE>(SELECT AGE FROM S
WHERE SN=’王华’) B:SELECT SN,AGE,SEX
FROM S
WHERE SN=’王华’ C:SELECT SN,ACE,SEX FROM S
WHERE AGE>(SELECT ACE
WHERE SN=’王华’) D:SELECT SN,ACE,SEX FROM S
WHERE ACE>王华 AGE
S(S#,sN,SEX,AGE,DEPT)
C(C#,CN)
SC(S#,C#,GRADE)其中;S#为学号,SN为姓名,SEX为性别,AGE为年龄,.DEPT为系别,C#为课程号, CIg为课程名,GRADE为成绩。检索所有比“王华”年龄大的学生姓名、年龄和性别正确的SELECT语句是 ______。
A:SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE FROM:S WHERE SN='王华') B:SELECT SN,AGE,SEX FROM S WHERE SN='王华'。 C:SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE WHERE SN='王华') D:SELECT SN,AGE,SEX FROM S WHERE AGE>王华 AGE
S(S#,SN,SEX,AGE,DEPT)
C(C#,CN)
SC(S#,C#,GRADE)
其中:S#为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,C#为课程号,
CN为课程名,GRADE为成绩。检索所有比“王华”年龄大的学生姓名、年龄和性别。
正确的SELECT语句是_______。
A:SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE FROM S WHERESN='王华') B:SELECT SN,AGE,SEX FROM S WHERE SN='王华' C:SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE WHERE SN='王华') D:SELECT SN,AGE,SEX FROM S WHERE AGE>王华 AGE
S(S#,SN,SEX,AGE,DEPT)
C(C#,CN)
SC(S#,C#,GRADE)
其中:S#为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,C#为课程号,
CN为课程名,GRADE为成绩。检索所有比“王华”年龄大的学生姓名、年龄和性别。
正确的SELECT语句是______。
A:SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE FROM S WHERE SN=‘王华’) B:SELECT SN,AGE,SEX FROM S WHERE SN=‘王华’ C:SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE WHERE SN=‘王华’) D:SELECT SN,AGE,SEX FROM S WHERE AGE>王华 AGE
S(S#,SN,SEX,AGE,DEPT)
C(C#,CN)
SC(S#,C#,GRADE)
其中:S#为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,C#为课程号,CN为课程名,GRADE为成绩。检索所有比“王华”年龄大的学生姓名、年龄和性别。
正确的SELECT语句是______。
A:SELECT SN,AGE,SEX FROM SWHERE AGE>(SELECT AGE FROM S WHERE SN='王华') B:SELECT SN,AGE,SEX FROM SWHERE SN='王华' C:SELECT SN,AGE,SEX FROM SWHERE AGE>(SELECT AGE WHERE SN='王华') D:SELECT SN,AGE,SEX FROM SWHERE AGE>王华AGE
S(S#,SN,SEX,AGE,DEPT) C(C#,CN) SC(S#,C#,GRADE) 其中:S#为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,C#为课程号, CN为课程名,GRADE为成绩。检索所有比“王华”年龄大的学生姓名、年龄和性别。 正确的SELECT语句是______。
A:SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE FROM S WHERE SN=‘王华’) B:SELECT SN,AGE,SEX FROM S WHERE SN=‘王华’ C:SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE WHERE SN=‘王华’) D:SELECT SN,AGE,SEX FROM S WHERE AGE>王华 AGE
使用 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,’女’)