【简答题】The author's attitude toward the influence of advertisement on people's habits is( ) [A] indifferent [B] negative [C] positive [D] biased
【单选题】已知关系S(S#,SN,AGE,SEX),SC(C#,S#,GRADE),C(C#,CN,TEACHER)。若要检索学生姓名及其选修课程的课程号和成绩,正确的SELECT语句是:
A.
SELECT S.SN,SC.C#,SC.GRADE FROM S,SC WHERE S.S#=SC.S#
【单选题】已知关系S(S#,SNAME,SEX,AGE),SC(S#,C#,GRADE),C(C#,CNAME,TEACHER),若要求查找“由张劲老师执教的数据库课程的平均成绩、最高成绩和最低成绩”,将使用关系( )。
【单选题】已知关系S(S#,SN,AGE,SEX),SC(C#,S#,GRADE),C(C#,CN,TEACHER)。若要检索学生姓名及其选修课程的课程号和成绩,正确的SELECT语句是_________。
A.
SELECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S.S#=SC.GRADE
B.
SELECT S.SN,SC.C#,SC.GRADE FROM S WHERE S.S#=SC.S#
C.
SELECT S.SN,SC.C#,SC.GRADE FROM S.SC
D.
SELECT S.SN,SC.C#,SC.GRADE FROM S,SC WHERE S.S#=SC.S#
【单选题】What is people's attitude toward cosmetic surgery?
A.
They think it is frightening
C.
People's attitude has changed over time
【单选题】已知关系S(S#,SN,AGE,SEX),SC(C#,S#,GRADE),C(C#,CN,TEACHER)。若要检索学生姓名及其选修课程的课程号和成绩,正确的SELECT语句是
A.
SELECT S.SN,SC.C#,SC.GRADE FROM S WHERE S.S#=SC.S#
B.
SELECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S.S#=SC.GRADE
C.
SELECT S.SN,SC.C#,SC.GRADE FROM S.SC
D.
SELECT S.SN,SC.C#,SC.GRADE FROM S,SC WHERE S.S#=SC.S#
【单选题】已知关系S(S#,SNAME,SEX,AGE),若要求查找‘李’姓学生的学生号和姓名,正确的SQL语句是( )。
A.
SELECT S#,SNAME FROM S WHERE SNAME='李%’
B.
SELECT S#,SNAME FROM S WHERE SNAME LIKE ‘李%'
C.
SELECT S#,SNAME FROM S WHERE SNAME=‘%李%’
D.
SELECT S#,SNAME FROM S WHERE SNAME LIKE '%李%'
【单选题】2 (单选题)《中国药典》规定素片的崩解时限为( )分钟