6.—_______ this in English?
—It's a baseball bat.
A. Who's
B.What's
C. How's
D. Where's
第1题:
若要求查找‘李’姓学生的学生号和姓名,正确的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题:
This passage is mainly about______.
A. how Louis Pasteur's friend died
B. Louis Pasteur's experience and achievement in curing rabies
C. how Louis Pasteur's arm and leg were disabled
D. Louis Pasteur cured a boy who had been badly bitten by a mad dog
此题为主旨题。本文介绍了科学家巴斯德的经历和他研制狂犬病疫苗成功的轶事。
第3题:
—_____? —She's our history teacher.
A.Where is she from
B.Where does the woman work
C.Who is she
D.How is the woman
第4题:
设有关系R(A,B,C)和S(C,D),与关系代数表达式ΠA,B,D(σR,C=S.C(R×S))等价的SQL语句是______。
A.SELECT*FROMR,S WHERE R.C=S.C
B.SELECT A,B,D FROM R,S WHERE R.C=S.C
C.SELECT A,B,D FROM R,S WHERE R=S
D.SELECT A,B FROM R WHERE(SELECT D FROM S WHERE R.C=S.
第5题:
查询选修了课程号为“C1”的学生的姓名和年龄,若用下列SQL的SELECT语句表达 时,错误的是( )。A.SELECT SNAME,AGE FROM S WHERE S .S#=(SELECT SC.S# FROM SC WHERE C.C#=’C 1’) B.SELECT SNAME,AGE FROM S,SC WHERE S.S#=SC.S# AND SC.C#=’C 1’ C.SELECT SNAME,AGE FROM S,SC WHERE S.S#=SC.S# AND SC.C#=’CI’ ORDER B Y S.S# D.SELECT SNAME,AGE FROM S WHERE S.S#=(SELECT SC.S# FROM SC WHERE SC.C#=’C 1’)
第6题:
设有关系R(A,B,C)和S(C,D)。与关系代数表达式πA,B,D(σR.C=S.C(R×S)等价的SQL语句是
A.SELECT*FROM R,S WHERE R.C=S.C
B.SELECT A,B,D FROM R,S WHERE R.C=S.C
C.SELE4T 1,2,8 FROM R,S WHERE R=S
D.SELECT A,B FROM R WHERE(SELECT D FROM S WHERE R.C=S.
第7题:
检索学生姓名及其所选修课程的课程号和成绩。正确的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 WHERE S.S#=SC.S#
D.SELECT S.SN,SC.C#,SC.GRADE FROM S,SC
第8题:
查询选修了课程号为“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 FROMS,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.SELECTS.S#,SNAME FROM S WHERE S.S# IN(SELECT SC. S# FROM SC WHERE C#='C2')
第9题:
Hello, is Tom in? -()
第10题:
have never discussed who is the world’s greatest poet and greatest dramatist
never discuss the world’s greatest poets and dramatist
are sure who is the world’s greatest poet and greatest dramatist
do not care who is the world’s greatest poet and greatest dramatist
第11题:
Steve.
Everyone does.
At the next door.
Yes, it‘s a secret.
第12题:
select * from emp where ename in 'S%';
select * from emp where ename='S%';
select * from emp where ename like 'S%';
select * from emp where ename like 'S_';
第13题:
查询选修了课程号为“MATHS”的学生的姓名和年龄,若用下列SQL的SELECT语句表达时,错误的是( )。
A) SELECT SNAME,AGE FROM S WHERE S. S# =(SELECT SC. S# FROM SC WHERE
c.c# ='MATHS ')
B ) SELECT SNAME, AGE FROM S WHERE S. S# =(SELECT SC. S# FROM SC WHERE
SC. C# =' MATHS ')
C) SELECT SNAME, AGE FROM S, SC WHERE S. S# =SC. S# AND SC. C# ='MATHS'
ORDER BY S. S#
D)SELECT SNAME, AGE FROM S, SC WHERE S. S# =SC. S# AND SC. C# ='MATHS'
第14题:
( 3 2 )查询学生姓名及其所选修课程的课程号和成绩,正确的 SQL 语句是
A ) SELECT S . SNAME , SC.C# , GRADE FROM S WHERE S . S # = SC . S#
B ) SELECT S . SNAME , SC.C #, GRADE FROM SC WHERE S . S # = = SC . S#
C ) SELECT S . SNAME , SC.C# , GRADE FROM S , SC WHERE S . S# = SC . S#
D ) SELECT S . SNAME , SC.C# , GRADE FROM S , SC WHERE S .S# = SC . C#
第15题:
A:( ).
B:Hi. My name's Rose. Are you from London?
A. Hello, I'm Paul. What's your name?
B. Hello, who are you? What's your name?
C. Where are you from?
第16题:
若要求查找姓名中第一个字为‘王’的学生号和姓名。下面列出的SQL语句中,哪个(些)是正确的?
Ⅰ.SELECT S#,SNAME FROM S WHERE SNAME='王%'
Ⅱ.SELECT S#,SNAME FROM S WHERE SNAMELIKE'王%'
Ⅲ.SELECT S#,SNAME FROM S WHERE SNAMELIKE'王'
A.Ⅰ
B.Ⅱ
C.Ⅲ
D.全部
第17题:
查询选修了课程号为“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')
第18题:
查询选修了课程号为\'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 BYS.S#
D.SELECT S.S#,SNAME FROM S WHERE S.S# IN(SELECT SC.S# FROM SC WHERE C#=\'C2\')
第19题:
查询选修了课程号为'C2'的学生号和姓名,若用下列SQL的SELECT语句表达时,错误的是( )。
A.SELECT S.S#,SNAME FROM S WHERE S.S# =(SELECT S C.S# FROM SC WHERE C#='C2')
B.SELECT S.S#,SNAME FROM S,SC WHERE S.S#==S C.S# AND C#='C2'
C.SELECT S.S#,SNAME FROM S,SC WHERE S.S#=S C.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')
第20题:
Everyone knows where the shop is, but who's the owner? ()
第21题:
查询选修了课程号为’C2’的学号和姓名,下列可以实现该效果的SQL语句是()
第22题:
She's in England.
She's from London
She's a nurse in England.
She is English
第23题:
the; the
a; the
the; an
a; an