niusouti.com

6.—_______ this in English?—It's a baseball bat.A. Who'sB.What'sC. How'sD. Where's

题目

6.—_______ this in English?

—It's a baseball bat.

A. Who's

B.What's

C. How's

D. Where's


相似考题
更多“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 '%.李%.'


    正确答案:B
    解析: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


    正确答案:B

    此题为主旨题。本文介绍了科学家巴斯德的经历和他研制狂犬病疫苗成功的轶事。

  • 第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


    参考答案:C

  • 第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.


    正确答案:D

  • 第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’)


    正确答案:A
    SELECT SC.S# FROM SC WHERE C.C#=’C 1’,既然从SC中查询学号,后面的条件应该为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.


    正确答案:B
    解析:本题是对关系基本运算与SQL语言转换的考查。题目中关系代数表达式的意思是从关系R,S中选出满足R.C=S.C的列A,B,D,比较4个选项中的SQL语句可知,正确答案为选项B。

  • 第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


    正确答案:C

  • 第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')


    正确答案:A
    解析:选项A不正确,因为选项A查询的结果是集合,应该在等号后用 IN;其他3个选项均正确。

  • 第9题:

    Hello, is Tom in? -()

    • A、Who's speaking, please?
    • B、How's everything going?
    • C、Who's this? 
    • D、Hold on, please. Wrong number!

    正确答案:A

  • 第10题:

    单选题
    English people _____.
    A

    have never discussed who is the world’s greatest poet and greatest dramatist

    B

    never discuss the world’s greatest poets and dramatist

    C

    are sure who is the world’s greatest poet and greatest dramatist

    D

    do not care who is the world’s greatest poet and greatest dramatist


    正确答案: D
    解析:
    细节题。首句就表达了这一观点,“For many Englishmen there can never be any discussion as to who is the world’s greatest poet and greatest dramatist.”这是毋庸置疑的。

  • 第11题:

    单选题
    Everyone knows where the shop is, but who's the owner? ()
    A

    Steve.

    B

    Everyone does.

    C

    At the next door.

    D

    Yes, it‘s a secret.


    正确答案: D
    解析: 暂无解析

  • 第12题:

    单选题
    查询出所有名字以’S’开始的员工()
    A

    select * from emp where ename in 'S%';

    B

    select * from emp where ename='S%';

    C

    select * from emp where ename like 'S%';

    D

    select * from emp where ename like 'S_';


    正确答案: D
    解析: 暂无解析

  • 第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'


    正确答案:A
    有两种方式进行题干所述的查询:连接查询方式和带嵌套的简单查询方式。连接查询方式是在表‘S和SC中按照S.S#=SC.S#和SC.C#=‘MATHS’的条件查找。带嵌套的简单查询方式是先只查询S表,在WHERE子句中限定“选修了课程号为‘MATHS’”…。WHERE子句中又带简单查询的SELECT语句,为SELECT SC.S#FROM SC WHERE SC.C#=‘MATHS’,即在SC表中按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#


    正确答案: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?


    正确答案:A

  • 第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.全部


    正确答案:B
    解析:本题是对SQL语句中的查询诗句的考查。该语句的,般格式为:SELECT[ALL|DISTINCT]目标列表达式>…FROM基本表>…WHILE条件表达式>GROUPBY列名>其中WHILE条件表达式>中的列名为字符时。采用如下形式:WHILEsnameLIKE'王%',字符-(下划线)表示可以跟任意的单个字符相匹配,而字符%(百分号)可以跟任意长的字符串匹配。本题中的所选列向量为字符,且要求学生的第一个字为“王”,后面并没有限定,因此采用字符%(百分号)。由上面分析可知,正确答案为选项B。

  • 第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')


    正确答案:A
    只从一个关系中来实现功能是不可能的。因为涉及到了课程号,学生号,姓名等。需要关系S和SC。

  • 第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\')


    正确答案:D

  • 第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')


    正确答案:A

  • 第20题:

    Everyone knows where the shop is, but who's the owner? ()

    • A、Steve.
    • B、Everyone does.
    • C、At the next door.
    • D、Yes, it‘s a secret.

    正确答案:A

  • 第21题:

    查询选修了课程号为’C2’的学号和姓名,下列可以实现该效果的SQL语句是()

    • A、select s.s#,sname from s where s.s#=(selectsc.s#fromscwherec#=’c2’
    • B、select s.s#,sname from s,s cwhere s.s#=sc.s#andc#=’c2’
    • C、select s.s#,sname from s joinscon s.s#=sc.s#wherec#=’c2’
    • D、select s.s#,sname from s where s.s#in(selectsc.s#fromscwherec#=’c2’)

    正确答案:A,C,D

  • 第22题:

    单选题
    Where is Kate?()
    A

    She's in England.

    B

    She's from London

    C

    She's a nurse in England.  

    D

    She is English


    正确答案: A
    解析: 暂无解析

  • 第23题:

    单选题
    —Mary, who’s ______ woman over there?—She’s my aunt, ______ English teacher.
    A

    the; the

    B

    a; the

    C

    the; an

    D

    a; an


    正确答案: D
    解析:
    句意:—玛丽,那里那个女人是谁?—她是我的阿姨,一个英语老师。本题考查冠词的用法。由over there可知,第一空表示特指,要用定冠词the;第二空表示泛指,但是在单词第一个字母是形容词前要用an,因此选C项。