与“SELECT*FROM学生INTO DBF A”等价的语句是______。
A:SELECT*FROM学生INTO A B:SELECT*FROM学生INTO TABLE A C:SELECT*FROM学生TO TABLE A D:SELECT*FROM学生TO DBF A
与“SELECT*FROM教师表INTO DBF A”等价的语句是______。
A:SELECT*FROM教师表TO DBF A B:SELECT*FROM教师表TO TABLE A C:SELECT*FROM教师表INTO TABLE A D:SELECT*FROM教师表INTO A
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#,SNAME,SEX,AGE)
SC(S#,C#,GRADE)
C(C#,CNAME,TEACHER)查询选修了课程号为’C2’的学生号和姓名,若用下列SQL的SELECT语句表达时,哪一个是错误的?
A:SELECT S.S#,SNAME FROM S WHERE S.S#=(SELECT SC.S# FROM SC WHERE C#=’C2’) B:SELECT S.S#,SNAME FROM S,SC WHERE S.S#=SC.S# AND C#=’C2’ C:SELECT S.S#,SNAME FROM S,SC WHERE S.S#=SC.S# AND C#=’C2’ ORDER BY S.S# D:SELECT S.S#,SNAME FROM S WHERE S.S# IN (SELECT SC.S# FROM SC WHERE C#=’C2’)
与“SELECT*FROM学生INTO DBF A”等价的语句是( )。
A:SELECT*FROM学生INTO A B:SELECT*FROM学生INTO TABLE A C:SELECT*FROM学生TO TABLE A D:SELECT*FROM学生TO DBF A
与“SELECT*FROM 教师表 INTO DBFA”等价的语句是()。
A:SELECT*FROM 教师表 TO DBF A B:SELECT*FROM 教师表 TO TABLE A C:SELECT*FROM 教师表 INTO TABLE A D:SELECT*FROM 教师表 INTO A
与“SELECT * FROM 教师表 INTO DBF A”等价的语句是()。
A:SELECT * FROM 教师表 TO DBF A B:SELECT * FROM 教师表 TO TABLE A C:SELECT * FROM 教师表 INTO TABLE A D:SELECT * FROM 教师表 INTO A