题目
A.Robert Frost was born in 1874 in Lawrence, educated at San Francisco, and died in Vermont.
B.Robert Frost was born in 1874 in San Francisco, educated at Lawrence, and died in Vermont.
C.Robert Frost was born in 1874 in San Francisco, educated at Vermont, and died in Lawrenc
D.Robert Frost was born in 1874 in Vermont, educated at Lawrence, and died in San Francisco.
第1题
SQL语句:
SELECT*FROM班级WHERE班级号NOT IN;
(SELECT班级号FROM学生)
该语句等价于:
SELECT*FROM班级WHERE NOT______;
(SELECT*FROM学生WHERE班级号=班级.班级号)
第2题
列出工资表中基本工资在1200元~1800元之间的职工信息,应使用的SQL查询语句是______。
A.SELECT*FROM工资WHERE基本工资>=1200 OR基本工资<=1800
B.SELECT*FROM工资WHERE基本工资IN(1200,1800)
C.SELECT*FROM工资WHERE基本工资BETWEEN 1200 AND 1800
D.SELECT*FROM工资WHERE基本工资LIKE(1200,1800)
第3题
检索职工表中工资大于800元的职工号,正确的命令是
A.SELECT职工号WHERE工资>800
B.SELECT职工号FROM职工SET工资>800
C.SELECT职工号FROM职工WHERE工资>800
D.SELECT职工号FROM职工FOR工资>800
第4题
第(23 )~(24 )题基于如下的两个关系:学生关系R,选课关系S.
(23 )执行 SQL 语句: SELECT * FROM R WHERE sno IN (SELECT sno FROM S WHERE cno= “ c1 ” )的结果中的元数和元组数分别应是
A ) 6 , 9
B ) 3 , 2
C ) 5 , 3
D ) 3 , 3
第5题
A.In 1913 in Washington.
B.In 1913 in London.
C.In 1913 in Boston.
D.In 1913 in New York.
第6题
A.“To Autumn”
B.“Mowing”
C.“On His Blindness”
D.“I Wandered Lonely as a Cloud”
第7题
下列SQL语句执行后,执行结果的第一记录的值为()。 SELECT班级.班级名,COUNT(职称)AS人数 FROM班级,教师 WHERE班级.班级号一教师.班级号AND职称=”讲师” GROUP BY班级.班级号 ORDER BY 2
A.信息200801班
B.信息200802班
C.计算机200801班
D.计算机200802班
第8题
A、Emily Dickinson
B、Walt Whitman
C、Robert Frost
D、Ezra Pound
第9题
若要从学生表中检索出1980年1月1日以后(含1月1日)出生的所有学员,可应,用如下 SQL语句 SELECT*FROM student WHERE 请给出恰当的表达式以完成该语句
A.csrq<={^1980-1-1}
B.csrq<{^1980-1-1}
C.csrq>={^1980-1-1}
D.csrq>{^1980-1-1}
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!