无锡立信职教中心校2007-----2008年第二学期
计算机英语 期末考试练习卷
使用班级：联大05161 考试时间：100分钟
姓名 班级 学号
注：卷面整洁分2’
一、 写出下列专业词汇的中文形式 (2’*10) upload freeware
PC Desk-sized computer DOS prompt Input device BIOS Control panel Terminal
Default value Operating System ESC SQL Directory Password Modem dial ASP script Request response Session application Language connection class类 average object property 二、 写出下列专业词汇的英文形式（2’*10） 文件夹 显示器 硬盘 下载 程序 代码 显卡 声卡
管理员 计算机语言 写盘 读盘 病毒 传真 主机 主板 虚拟内存 命令 数据库 备份 选择 删除 调试 运行
局域网 计算机辅助设计 端口 在线 序列号 服务器
三、选词填空(1’*8)
许可证 出错信息 方法 扩展内存 调制解调器 因特网服务提供商 风扇 微软 图形用户界面 移动用户 卸载 光驱 路径 桌面 账号 协议 上传 液晶显示器 method mobile user ISP CD-ROM agreement modem GUI Microsoft upload LCD fan error message uninstall license path account desktop extended memory
五、判断 (2’*10)
1Folder in the Windows responses with directory in the DOS.
2The central processing unit is the heart of a computer. 3ROM can be written. 4RAM can be written and read.
5Click with right button is to open a shortcut menu. 6Assemble Language is a high level language.
7More than two symbols are used in the machine language. 8Software is independent of hardware.
9An operating system is the highest layer of software on a computer. 10CPU is a combination of arithmetic unit and control unit. 11Scanner is one kind of input device.
12The function of input device is to accept data .
13Office Automation can greatly in prove our working efficiently. 14SQL server is one kind of database system.
15Multimedia is made from a mix of hardware and software ,machine and people. 16Multimedia isn’t any one thing ,but is a complex entity.
17Computer can solve big problems by following a series of simple steps. 18Computer data can be transmitted through a telephone line.
19Windows is different from DOS mainly because of its pictures and graphics.
第 1 页 共 2 页 练习卷
六、用SQL语句写出下列命令 (12’) 成绩 学号 姓名 语文 数学 班级 档案 学号 姓名 性别 年龄 1查询成绩表中数学大于80分的所有记录
2查询成绩表中语文、数学都大于70分的所有记录
3查询成绩表中语文在70分~80分之间的记录，并按数学降序排列
4查询成绩表中姓“王”的记录
5在成绩表中按“班级”查出各班数学平均成绩
6查询成绩表中语文大于80或数学大于70的记录，要求将相同记录去除。
7查询所有学生的班级和年龄
8在成绩表中，查询“张三” 、“李四” 、“王五” 、“周六” 、“李七”的语文、数学成绩
七Translate the following Screen English. (2’*9) Turn off any attached device.
Read the following license agreement first.
Exit all the other applications before continuing with this installation.
Restart your computer to finish Setup.
Hard disk install failure.
Invalid boot diskette.
Press ESC to skip memory test.
Bad command or file name.
Not enough memory.
The line is busy , try again later.
In fact , multimedia is just two media :sound and moving pictures.
The CD serves as multimedia ’s main storage and exchange medium.
Standard CMOS Features
Auto detection
advanced CMOS Features
boot device
set supervisor password
Create DOS Partition or Logical DOS Drive
Set active Partition
Delete Partition or Logical DOS Drive
Create(delete) primary DOS Partition
Create(delete) extended DOS Partition
Create(delete) logical DOS drive(s) in the extended dos Partition
第 2 页 共 2 页 练习卷