【单选题】
在SQL Server 2008中,下列关于通配符的操作中,范围最大的是___。
A. name LIKE′abc#′
B. name LIKE ′abc_d%′
C. name LIKE′abc%′
D. name LIKE′%abc%′
查看试卷,进入试卷练习
微信扫一扫,开始刷题
答案
D
解析
暂无解析
相关试题
【单选题】
与表达式:成绩BETWEEN 0 AND 100 等效的表达式是___。
A. 成绩>0 and 100
B. 成绩>=0 and <=100
C. 成绩>=0 and 成绩<=100
D. 成绩>0 and 成绩<100
【单选题】
SQL中查询保存结果到表语句的是___。
A. INSERT INTO
B. GROUP BY
C. ORDER BY
D. INSERT JION
【单选题】
两表连接,包括左表的所有行,不包括右表的不匹配行的外连接称为___。
A. 内连接
B. 左外连接
C. 右外连接
D. 全连接
【单选题】
 如果统计所有职工的总工资,用到的聚合函数是___。 
A. SUM  
B. COUNT 
C. FIRST 
D. STDEV
【单选题】
“Create Unique Index AAA On学生表(学号)”将在学生表上创建名为AAA的___。     
A. 惟一索引  
B. 聚集索引     
C. 复合索引    
D. 唯一聚集索引 
【单选题】
sp_help属于哪一种存储过程___?   
A.  、系统存储过程 
B.  、 用户定义存储过程 
C.  、 扩展存储过程 
D.  、 其他 
【单选题】
存储过程中定义输出参数使用的关键字是___。
A.  、input 
B.  、 output 
C.  、 extend 
D.  、 outlook 
【单选题】
用于显示存储过程的参数及其数据类型的系统存储过程是___。
A.  、sp_helptext 
B.  、sp_renamedb 
C.  、sp_help 
D.  、 sp_rename 
【单选题】
在SQL Server中,触发器不具有___类型。   
A.  INSERT触发器 
B.  UPDATE触发器
C.  DELETE触发器 
D.  、SELECT触发器 
【单选题】
关于触发器,下列说法错误的是___。
A. 触发器是一种特殊类型的存储过程
B. DDL触发器包括INSERT触发器、UPDATE触发器、DELETE触发器等基本触发器
C. 触发器可以同步数据库中的相关数据表,进行级联更改
D. DDL触发器和DML触发器可以通过CREATE TRIGGER语句来创建,都是为了响应事件而被激发的。
【单选题】
可以响应INSERT语句的触发器是___。
A. INSERT触发器
B. DELETE触发器
C. UPDATE触发器
D. DDL触发器
【单选题】
可以响应CREATE TABLE语句的触发器是___。
A. INSERT触发器
B. DELETE触发器
C. UPDATE触发器
D. DDL触发器
【单选题】
触发器可以建在___中。
A. 表
B. 过程
C. 数据库
D. 函数
【单选题】
删除触发器mytri的正确命令是___。
A. DELECT mytri
B. TRUNCATE mytri
C. DROP mytri
D. REMMOVE mytri
【单选题】
用户使用SQL Server时,通常需要考虑两个安全性阶段___。
A. 登录验证、操作验证
B. 身份验证、权限认证
C. 操作验证、登录验证
D. 权限认证、身份验证
【单选题】
在SQL Server中,每个数据库一般都有两个默认的用户,他们是___。
A. DBO和GUEST
B. MASTER和ADMIN
C. ADMINISTRATOR和GUEST
D. SA和DBO
【单选题】
允许被授权用户可以把权限转授给别人的关键词是___。
A. Deny
B. Grant
C. Revoke
D. With grant option
【单选题】
为便于对用户及权限的管理,可以将一组具有相同权限的用户组织在一起,这一组具有相同权限的用户就称为___。
A. 系统用户
B. DBA
C. 角色
D. 数据库用户
【单选题】
数据库应用程序开发中,概念设计阶段描述数据库概念模型的最主要方法是___。
A. E-R模型
B. 编写数据字典
C. 建立逻辑数据模型
D. 建立概念模型
【单选题】
关系数据库规范化是为解决关系数据库中___问题而引入的。
A. 插入异常、删除异常和数据冗余
B. 提高查询速度
C. 减少数据操作的复杂性
D. 保证数据的安全性和完整性。
【单选题】
关系数据库设计理论中,起核心作用的是___。
A. 范式
B. 模式设计
C. 函数依赖
D. 数据完整性
【单选题】
在现实世界中客观存在并能相互区别的事物称为___。
A. 实体
B. 实体集
C. 字段
D. 记录
【单选题】
在数据库设计的需求阶段中,业务流图一般采用___表示。
A. 程序结构图
B. 数据流图
C. 程序框架
D. E-R图
【单选题】
在数据库设计的___阶段中,用E-R图来描述信息结构。
A. 需求分析
B. 概念结构设计
C. 逻辑结构设计
D. 物理结构设计
【单选题】
CRH5型动车组广播中途站开车一报为( )播报,中途站开车二报为( )播报;CRH380B型动车组广播中途站开车一报为( )播报,中途站开车二报为( )播报。___
A. 手动 手动 自动 自动
B. 手动 自动 手动 自动
C. 手动 自动 自动 自动
D. 手动 手动 手动 自动
【单选题】
全路统一的站车专用无线通信频率___。
A. 467.200MHZ
B. 457.950MHZ
C. 457.200MHZ
D. 467.950MHZ
【单选题】
《客规》中规定旅客的基本义务是:___
A. 依据车票票面记载的内容乘车;
B. 要求承运人提供与车票等级相适应的服务并保障其旅行安全;
C. 对运送期间因承运人过错造成的随身携带物品损失有权要求承运人赔偿。
D. 对所造成铁路或者其他旅客的损失予以赔偿
【单选题】
CRH380B型动车组全列共有紧急制动阀___个。
A. 18
B. 19
C. 20
D. 21
【单选题】
总公司《动车组列车服务质量规范》中规定动车组列车停靠低站台时,到站前___提前锁闭辅助板指示锁并打开翻板,开车后及时将翻板及辅助板指示锁复位。
A. 乘务人员
B. 列车长
C. 随车机械师
D. 服务员
【单选题】
总公司《动车组列车服务质量规范》中规定列车运行中,车门、___锁闭状态良好。定期巡视,保持通道畅通。
A. 垃圾箱
B. 气密窗
C. 端门
D. 防火隔断门
【单选题】
总公司《动车组列车服务质量规范》中规定女性发不过肩,刘海长不遮眉,短发不短于___。
A. 2寸
B. 5寸
C. 5厘米
D. 7厘米
【单选题】
总公司《动车组列车服务质量规范》中规定餐车加热、供应餐食时,服务人员戴口罩、手套;女性穿___。
A. 裙子
B. 衬衫
C. 裤子
D. 围裙
【单选题】
总公司运输局关于印发《视力残疾旅客携带导盲犬进站乘车若干规定(试行)》的通知要求为保障旅客出行安全,乘坐同一趟列车时间超过___小时的需与具备照看导盲犬能力的成年人同行。
A. 12
B. 13
C. 14
D. 15
【单选题】
总公司《动车组列车服务质量规范》中规定清洁厕所时,作业人员___。
A. 胶皮手套
B. 一次性手套
C. 不能佩戴手套
D. 保洁专用手套
【单选题】
旅客办理改签发到城市相同的车票时,开车前48小时(不含)以上,可改签___
A. 预售期内的其他列车
B. 开车前的其他列车
C. 开车后至票面日期当日24:00之间的其他列车D.票面日期次日及以后的列车
【单选题】
原车票开车前___以上时,旅客可办理变更到站及乘车日期、车次、席位的车票改签。
A. 20分钟
B. 30分钟
C. 1个小时
D. 48小时
【单选题】
《动车组列车服务质量规范》中规定公共区域的电源插座保证符合___的旅行必需的小型电器正常使用
A. 额定范围
B. 允许范围
C. 规定范围
D. 标示范围
【单选题】
旅客办理变更到站不收取___
A. 改签费
B. 手续费
C. 补票费
D. 退票费
【单选题】
办理车票改签时,新车票高于原车票的,___
A. 不补不退
B. 补收差额
C. 退还差额
D. 不予办理
【单选题】
旅客在开车前___(不含)以上退票的,补收取退票费
A. 2小时
B. 24小时
C. 48小时
D. 15天
推荐试题
【单选题】
( ) 36. What can we infer from the last paragraph? A. People should practice random kindness to those in need. B. People who receive kindness are likely to offer it to others. C. People should practice random kindness to strangers they meet. D. People who receive kindness are likely to pay it back to the giver.
A. A
B. B
C. C
D. D
【单选题】
( ) 37.The greatest river for navigation is ___________. A. the Nile B. the Amazon C. the Mekong D. the Mississippi
A. A
B. B
C. C
D. D
【单选题】
( ) 38. From a dam, people can use the water for ___________. A. keeping the rivers clean B. only making electricity C. irrigation and making electricity D. washing clothes
A. A
B. B
C. C
D. D
【单选题】
( ) 39. The water in the river is polluted because of _____________. A. people's drinking water too much B. people's swimming in the river too much C. chemicals and other materials D. people's building a dam across a river
A. A
B. B
C. C
D. D
【单选题】
( ) 40. The best title of the passage is ___________. A. Rivers in Cities B. The importance of Rivers C. Transportation D. Natural Resources
A. A
B. B
C. C
D. D
【单选题】
) 1. Even Tony’s six-year-old son asked him ______ smoking. A. stops B. stopped C. to stop D. stopping
A. A
B. B
C. C
D. D
【单选题】
2.—What do you think of the lecture of Li Yang’s Crazy English? — I think it’s _______ , but someone thinks it’s much too ________. A. wonderful enough; bored B. enough wonderful; boring C. enough wonderful; bored D. wonderful enough; boring
A. A
B. B
C. C
D. D
【单选题】
3.—He didn’t go to the lecture this morning, did he?    — _____ .Though he was not feeling very well. A. No, he didnt B. Yes; he did C. No, he did D. Yes, he didnt
A. A
B. B
C. C
D. D
【单选题】
4. If you read a lot, your life ______ full of pleasure. A. will be B. is C. be D. was
A. A
B. B
C. C
D. D
【单选题】
5. The black bag _________ be Annas. She has a blue one. A. should B. cant C. wouldnt D. could
A. A
B. B
C. C
D. D
【单选题】
6. Susan, why are you still here? They are all ready to start. Im sorry, but I _________ when to start. A. dont tell B. wasnt told C. didnt tell D. havent told
A. A
B. B
C. C
D. D
【单选题】
7.—Why dont you choose the red tie?    —For me, it doesn’t _____ my shirt very well. A. fix B. accept C. compare D. match
A. A
B. B
C. C
D. D
【单选题】
8. — Could you tell me ______? I must find him. — Sorry.I don’t know.But he was here just now. A. where Tom was B. where Tom is C. where has Tom gone D. where can I find Tom
A. A
B. B
C. C
D. D
【单选题】
9. —What did Mr Green say to you? — What a heavy rain! How did you come here? He asked________. A. at all B. in fact C. in surprise D. as a result
A. A
B. B
C. C
D. D
【单选题】
10. I often see Tom on the playground.When I passed the playground yesterday, I saw him . A. play; playing B. to play; play C. playing; to play D. playing; play
A. A
B. B
C. C
D. D
【单选题】
11. — Mum, could I have ____________ to drink? — Oh, dear.You can only drink some water.There is _________ in the kitchen. A. anything; else something B. anything; something else C. something; else nothing D. something; nothing else
A. A
B. B
C. C
D. D
【单选题】
12. We all know that learning a foreign language _______ time and effort. A. requires B. reduces C. removes D. repeats
A. A
B. B
C. C
D. D
【单选题】
13. Her son __________ Coke, but now he __________ milk. A. is used to drinking; used to drink B. used to drink; uses to drink C. used to drink; is used to drinking D. is used to drink; is drinking
A. A
B. B
C. C
D. D
【单选题】
14. I don’t know the teacher is talking with Miss Wang. A. what B. whom C. who D. which
A. A
B. B
C. C
D. D
【单选题】
15.Millie does __________ that many people are thankful to her. A. such an important and helpful job B. so important and helpful work C. a very important and helpful job D. such an important and helpful work
A. A
B. B
C. C
D. D
【单选题】
16. I think eating more vegetables is good _______ our health. —Yes, I agree _______ you. A. at, to B. for, with C. to, to D. for, to
A. A
B. B
C. C
D. D
【单选题】
17. I often go on holiday with my parents _____ summer. A. in B. at C. on D. of
A. A
B. B
C. C
D. D
【单选题】
18. I called you at 4:00 yesterday afternoon, but nobody answered. Sorry, I ______ with my friends at that time. A. had swum B. swam C. would swim D. was swimming
A. A
B. B
C. C
D. D
【单选题】
19.––Who is on the playground? ---__________.    A. Never B. None C. No one D. A lot
A. A
B. B
C. C
D. D
【单选题】
20. The schoolboy ______ a blind man cross the street yesterday. A. helps B. helped C. will help D. has helped
A. A
B. B
C. C
D. D
【单选题】
21. —The 2010 World Expo which will last 184 days will be held in Shanghai on May 1st. —________exciting news! We shall try our best to support it. A. How B. How an C. What D. What an
A. A
B. B
C. C
D. D
【单选题】
22. They preferred ______ in bed rather than _____ horses.    A. to lie; to ride B. lying; riding C. lying; ride D. to lie; ride
A. A
B. B
C. C
D. D
【单选题】
23. —What was Jim wearing at the party? — Nothing _______. He was in his usual shirt and jeans. A. special B. simple C. important D. interesting
A. A
B. B
C. C
D. D
【单选题】
24. The 2016 Olympic Games ________ in Brazil. Would you like to go there? Maybe, if possible. A. are held B. will be held C. were held D. have been held
A. A
B. B
C. C
D. D
【单选题】
25. — David, look at the man in white over there.Can you tell me _______ ? —He is a doctor.    A. who is he B. who he is C.what does he do D. what he does
A. A
B. B
C. C
D. D
【单选题】
( ) 26.With help from a Mr. H, you can__________. A. stop wearing your watch B. get new books and objects C. finish your homework on time D. know when parents or teachers are near
A. A
B. B
C. C
D. D
【单选题】
( ) 27. A PENGO WATCH CONTROL can help you to ______________. A. repair your TV B. put away your books and objects C. become a James Bond D. get a daily weather report
A. A
B. B
C. C
D. D
【单选题】
( ) 28. You can get your Mr. H for___________. A. $299 B. $499 C. $199 D. $99
A. A
B. B
C. C
D. D
【单选题】
( ) 29. When was canned food invented? A. In 1870.          B. In 1810. C. In 1902.          D. In 1926.
A. A
B. B
C. C
D. D
【单选题】
( ) 30. After the trip to the Arctic, Clarence Birdseye invented ____________. A. canned food             B. can openers C. frozen food           D. air conditioning
A. A
B. B
C. C
D. D
【单选题】
( ) 31. Changes in weather _____________ in Willis Carrier's company. A. helped to keep food           B. made rooms comfortable C. caused health problems        D. hurt printing paper
A. A
B. B
C. C
D. D
【单选题】
( ) 32. According to the passage, which of the following may lead to inventions? A. People's needs.             B. Public support. C. Modern technology.          D. Practical suggestions.
A. A
B. B
C. C
D. D
【单选题】
( ) 33. What is the writer's main purpose(目的)in writing this passage?    A.To tell the readers his life story.    B.To tell people what kind of person his father was.    C.To tell the readers what present he got from his father.    D. To let people know how poor he was.
A. A
B. B
C. C
D. D
【单选题】
( ) 34. Why did the father not ask his son not to do this and do that?    A.Because he felt quite confident of his son.    B.Because he was born from a poor family.    C.Because he was a man of few words.    D.Because he didn't want to be much too strict with his son.
A. A
B. B
C. C
D. D
【单选题】
( ) 35. What would someone learn from this passage?    A.How to live by oneself. B.How to stand on one's own feet.    C.What a good father should do. D.What the self-important is like.
A. A
B. B
C. C
D. D