2022河南软件水平考试考试考前冲刺卷.docx

2022河南软件水平考试考试考前冲刺卷本卷共分为1大题50小题，作答时间为180分钟，总分100分，60分及格。一、单项选择题（共50题，每题2分。每题的备选项中，只有一个最符合题意） 1.在OSI参考模型中，实现节点到节点的流量控制、分组路由等功能的协议层是 。A数据链路层B网络层C传输层D会话层2.Open Shortest Path First(OSPF)is a (72) routing algorithm that (73) work done on theOSI IS-IS intradomain routing protocol. This routing, as compared to distance-vector routing,requires (74) processing power. The (75) algorithm is used to calculate mutes. OSPFrouting table updates only take place when necessary, (76) at regular intervals.ABellman-FordBFord-FulkersonCDijkstraDRIP3.某CPU的主振频率为100 MHz，平均每个机器周期包含4个主振周期。各类指令的平均机器周期数和使用频度如表2.9所示，则该计算机系统的速度为平均约 (8) 兆指令/秒。若某项事务处理工作所要执行的机器指令数是控制程序(以访内、比较与转移等其他指令为主)220000条指令和业务程序(以包括乘除在内的算术逻辑运算为主)90000条指令，且指令使用频度基本如表2.9所示，则该计算机系统的事务处理能力约为 (9) 项/秒。若其他条件不变，仅提高主振频率至150 MHz，则此时该计算机速度为平均约 (10) 兆指令/秒，对上述事务的处理能力约为 (11) 项/秒。若主频仍为100 MHz，但由于采用了流水线和专用硬件等措施，使各类指令的每条指令平均机器周期数都变为1.25，则此时计算机的速度平均约 (12) 兆指令/秒。 表2.9 各类指令的平均机器周期数和使用频度 指令类别平均机器周期数/指令使用频度访内存2.525%一般算术逻辑运算1.2540%比较与转移等1.525%乘除155%其他55% A1B5C10D15E20F33.3G50H66.7I100J2004.ATM(异步传输模式)网络是一种使用信元作为传输数据的单位的网络，并且信元大小是固定的53字节。信元传输采用 (90) 。当信元从用户端进入网络中第一个交换机后，信元头中修改的部分是 (91) 。当进行VP交换时，VPI和VCI的变化情况是 (92) 。当需要传输压缩的视频流数据时，采用的服务类别最好是 (93) 。当AAL层采用AAL5协议传输数据时，可以达到的有效数据传输率(除去开销)为 (94) 。A) VCI B) GFC C) CLP D) PT 5.设某单位路由器建立了以下的路由表，若收到分组的目的IP地址为128.96.37.151，则转发的口是 (62) ，若收到分组的目的IP是128.96.35.151，则转发的端口是 (63) ，若该路由器是该单位的与Internet接人路由器，则该单位分得的IP地址是 (64) 。在一个网络中子网数目划分增多时，可供分配给主机的正常IP地址总数目会 (65) 。当我们将主机地址设置为192.1680.1.2时，则主机访问Internet时 (66) 。 目的IP子网掩码转发端口128.96.36.0255.255.255.128E1128.96.36.128255.255.255.128E2128.96.37.0255.255.255.128R2128.9637.128255.255.255.128R3Default-R4A) 加1 B) 减1 C) 增加 D) 减少 6.Open Shortest Path First(OSPF)is a (72) routing algorithm that (73) work done on theOSI IS-IS intradomain routing protocol. This routing, as compared to distance-vector routing,requires (74) processing power. The (75) algorithm is used to calculate mutes. OSPFrouting table updates only take place when necessary, (76) at regular intervals.Abut ratherBrather tooCrather thanDrather that7.在Linux操作系统中，以RPM方式安装的Apache服务器，其配置文件默认存储在 目录中。A/var/www/htmlB/var/www/usageC/etc/httpd/confD/Var/log/httpd8.某CPU的主振频率为100 MHz，平均每个机器周期包含4个主振周期。各类指令的平均机器周期数和使用频度如表2.9所示，则该计算机系统的速度为平均约 (8) 兆指令/秒。若某项事务处理工作所要执行的机器指令数是控制程序(以访内、比较与转移等其他指令为主)220000条指令和业务程序(以包括乘除在内的算术逻辑运算为主)90000条指令，且指令使用频度基本如表2.9所示，则该计算机系统的事务处理能力约为 (9) 项/秒。若其他条件不变，仅提高主振频率至150 MHz，则此时该计算机速度为平均约 (10) 兆指令/秒，对上述事务的处理能力约为 (11) 项/秒。若主频仍为100 MHz，但由于采用了流水线和专用硬件等措施，使各类指令的每条指令平均机器周期数都变为1.25，则此时计算机的速度平均约 (12) 兆指令/秒。 表2.9 各类指令的平均机器周期数和使用频度 指令类别平均机器周期数/指令使用频度访内存2.525%一般算术逻辑运算1.2540%比较与转移等1.525%乘除155%其他55% A1B5C10D15E20F33.3G50H66.7I100J2009.Windows组网是指把Windows终端和服务器连接起米。采用 工具可实现域的创建和管理。ALDAPBBDCCRPCDPDC10.ATM(异步传输模式)网络是一种使用信元作为传输数据的单位的网络，并且信元大小是固定的53字节。信元传输采用 (90) 。当信元从用户端进入网络中第一个交换机后，信元头中修改的部分是 (91) 。当进行VP交换时，VPI和VCI的变化情况是 (92) 。当需要传输压缩的视频流数据时，采用的服务类别最好是 (93) 。当AAL层采用AAL5协议传输数据时，可以达到的有效数据传输率(除去开销)为 (94) 。A) VPI变化，VCI不变 B) VPI不变，VCI变化 C) VPI变化，VCI变化 D) VPI不变，VCI不变 11.设某单位路由器建立了以下的路由表，若收到分组的目的IP地址为128.96.37.151，则转发的口是 (62) ，若收到分组的目的IP是128.96.35.151，则转发的端口是 (63) ，若该路由器是该单位的与Internet接人路由器，则该单位分得的IP地址是 (64) 。在一个网络中子网数目划分增多时，可供分配给主机的正常IP地址总数目会 (65) 。当我们将主机地址设置为192.1680.1.2时，则主机访问Internet时 (66) 。 目的IP子网掩码转发端口128.96.36.0255.255.255.128E1128.96.36.128255.255.255.128E2128.96.37.0255.255.255.128R2128.9637.128255.255.255.128R3Default-R4A) 直接访问 B) 不能访问 C) 需要经过网关进行地址转换 D) 需要路由器允许 12.ATM(异步传输模式)网络是一种使用信元作为传输数据的单位的网络，并且信元大小是固定的53字节。信元传输采用 (90) 。当信元从用户端进入网络中第一个交换机后，信元头中修改的部分是 (91) 。当进行VP交换时，VPI和VCI的变化情况是 (92) 。当需要传输压缩的视频流数据时，采用的服务类别最好是 (93) 。当AAL层采用AAL5协议传输数据时，可以达到的有效数据传输率(除去开销)为 (94) 。A) CBR B) ABR C) UBR D) rt-VBR 13.ATM(异步传输模式)网络是一种使用信元作为传输数据的单位的网络，并且信元大小是固定的53字节。信元传输采用 (90) 。当信元从用户端进入网络中第一个交换机后，信元头中修改的部分是 (91) 。当进行VP交换时，VPI和VCI的变化情况是 (92) 。当需要传输压缩的视频流数据时，采用的服务类别最好是 (93) 。当AAL层采用AAL5协议传输数据时，可以达到的有效数据传输率(除去开销)为 (94) 。A) 85% B) 87% C) 89% D) 90% 14.给定关系模式R(U，F)，U=A,B,C,D,E，F=BA，DA，AE，ACB，其候选关键字为 (40) ，则分解=R1(ABCE)，R2(CD)满足 (41) 。AABDBADECACDDCD15.Typically, these are concern with the establishment of (66) the network and with the control of the flow of messages across this channel. The provision of such facilities is only part of the network requirements, however, since in many applications the communicating computers may be of different types. This means that they may use different programming languages and, more importantly, different forms of (67) interface between user(application)program, normally referred to, as application processes or APs, and the underlying communication services may be (68) For example, one computer may be a small single -user computer, while another may be a large (69) system. In the earlier days of computer communication, these issues meantthat only closed communities of computers ( that is, from the same manufacturer) could communicate with each other in a meaningful way. IBMs Systems Network. Architecture (SNA) and DECs Digital Network Architecture (DNA) are just two examples of Communication software packages produced by manufacturers to allow their systems to be int erconnected together. These proprietary packages, however, of which there am still many inexistence, do not address the problem of universal interconnect ability, or open systems interconnection. In an attempt to alleviate this problem, (70) , in the late 1970s, formulated a reference model to provide a common basis ( or the coordination of standards developments and to allow existing and evolving standards activities to beplaced into perspective with one another.A. communication channel access B. protocols C. data channel D. public communication 16.数据的独立性是指 (28) 是相互独立的；它又可分为 (29) 。A. 内存数据独立性和外存数据独立性 B. 逻辑数据独立性和物理数据独立性 C. 数据库数据独立性和数据库外数据独立性 D. 结构化数据独立性和非结构化数据独立性 17.在需求分析阶段，需求调查的内容是 (57) ，需求分析的结果是 (58) 。A信息要求、处理要求B安全性与完整性要求C信息要求、安全性要求D信息要求、处理要求、安全性与完整性要求18.数据库系统必须控制事务的并发执行，保证数据库 (45) 。假设事务T1、T2分别对数据A和B进行的操作如下图所示，事务T1与T2间的并发调度为可串行化调度的是 (46) 。 *A处于一致的状态B不存在冗余的信息C操作不出现死循环D备份的完整性19.结构化查询语言SQL是一种 (41) 语言，其主要功能有 (42) ，它的典型句型为 SELECT A1，A2，An FROM r1，r2，rm WHERE F 其中A1，A2，An、r1，r2，rm和F分别是 (43) 。 关系模式SCS(Sno，Cno，Score)中，Sno是学生的学号，Cno是课程号，Score为成绩。若要查询每门课程的平均成绩，且要求查询结果按平均成绩升序排列。平均成绩相同时，按课程号降序排列，可用SQL语言写为 (44) 。若查询结果仅限于平均分数超过85分的，则应 (45) 。A. 人工智能 B. 关系数据库 C. 函数型 D. 高级算法 20.杀毒软件报告发现病毒Macro.Melissa，由该病毒名称可以推断病毒类型是 (8) ，这类病毒主要感染目标是 (9) 。A文件型B引导型C目录型D宏病毒21.设有员工实体Employee(员工号，姓名，性别，年龄，电话，家庭住址，家庭成员，关系，联系电话)。其中，“家庭住址”包括邮编、省、市、街道信息；“家庭成员，关系，联系电话”分别记录了员工亲属的姓名、与员工的关系以及联系电话，且一个员工允许有多个家庭成员。 员工实体Employee的主键为 (33) ；“家庭住址”是一个 (34) 属性；该关系属于 (35) ；为使数据库模式设计更合理，对于员工关系模式Employee (36) 。A员工号B员工号，家庭成员C姓名D姓名，家庭成员22.数据的独立性是指 (28) 是相互独立的；它又可分为 (29) 。A. 数据的存储位置和数据值 B. 操作系统和数据库中的数据 C. 用户的应用程序和存储在外存上的数据库中的数据 D. 以上均不对 23.给定关系模式R(U，F)，U=A,B,C,D,E，F=BA，DA，AE，ACB，其候选关键字为 (40) ，则分解=R1(ABCE)，R2(CD)满足 (41) 。A具有无损连接性、保持函数依赖B不具有无损连接性、保持函数依赖C具有无损连接性、不保持函数依赖D不具有无损连接性、不保持函数依赖24.在需求分析阶段，需求调查的内容是 (57) ，需求分析的结果是 (58) 。A数据流图B数据字典C数据流图、数据字典DE-R图25.Typically, these are concern with the establishment of (66) the network and with the control of the flow of messages across this channel. The provision of such facilities is only part of the network requirements, however, since in many applications the communicating computers may be of different types. This means that they may use different programming languages and, more importantly, different forms of (67) interface between user(application)program, normally referred to, as application processes or APs, and the underlying communication services may be (68) For example, one computer may be a small single -user computer, while another may be a large (69) system. In the earlier days of computer communication, these issues meantthat only closed communities of computers ( that is, from the same manufacturer) could communicate with each other in a meaningful way. IBMs Systems Network. Architecture (SNA) and DECs Digital Network Architecture (DNA) are just two examples of Communication software packages produced by manufacturers to allow their systems to be int erconnected together. These proprietary packages, however, of which there am still many inexistence, do not address the problem of universal interconnect ability, or open systems interconnection. In an attempt to alleviate this problem, (70) , in the late 1970s, formulated a reference model to provide a common basis ( or the coordination of standards developments and to allow existing and evolving standards activities to beplaced into perspective with one another.A. database B. data representationC. protocols D. data communication 26.结构化查询语言SQL是一种 (41) 语言，其主要功能有 (42) ，它的典型句型为 SELECT A1，A2，An FROM r1，r2，rm WHERE F 其中A1，A2，An、r1，r2，rm和F分别是 (43) 。 关系模式SCS(Sno，Cno，Score)中，Sno是学生的学号，Cno是课程号，Score为成绩。若要查询每门课程的平均成绩，且要求查询结果按平均成绩升序排列。平均成绩相同时，按课程号降序排列，可用SQL语言写为 (44) 。若查询结果仅限于平均分数超过85分的，则应 (45) 。A. 数据定义、数据操作、数据安全 B. 数据安全、数据编辑、数据并发控制 C. 数据定义、数据操作、数据控制 D. 数据查询、数据更新、数据输入输出 27.杀毒软件报告发现病毒Macro.Melissa，由该病毒名称可以推断病毒类型是 (8) ，这类病毒主要感染目标是 (9) 。AEXE或COM可执行文件BWord或Excel文件CDLL系统文件D磁盘引导区28.数据库系统必须控制事务的并发执行，保证数据库 (45) 。假设事务T1、T2分别对数据A和B进行的操作如下图所示，事务T1与T2间的并发调度为可串行化调度的是 (46) 。 * * 29.设有员工实体Employee(员工号，姓名，性别，年龄，电话，家庭住址，家庭成员，关系，联系电话)。其中，“家庭住址”包括邮编、省、市、街道信息；“家庭成员，关系，联系电话”分别记录了员工亲属的姓名、与员工的关系以及联系电话，且一个员工允许有多个家庭成员。 员工实体Employee的主键为 (33) ；“家庭住址”是一个 (34) 属性；该关系属于 (35) ；为使数据库模式设计更合理，对于员工关系模式Employee (36) 。A简单B多值C复合D派生30.Typically, these are concern with the establishment of (66) the network and with the control of the flow of messages across this channel. The provision of such facilities is only part of the network requirements, however, since in many applications the communicating computers may be of different types. This means that they may use different programming languages and, more importantly, different forms of (67) interface between user(application)program, normally referred to, as application processes or APs, and the underlying communication services may be (68) For example, one computer may be a small single -user computer, while another may be a large (69) system. In the earlier days of computer communication, these issues meantthat only closed communities of computers ( that is, from the same manufacturer) could communicate with each other in a meaningful way. IBMs Systems Network. Architecture (SNA) and DECs Digital Network Architecture (DNA) are just two examples of Communication software packages produced by manufacturers to allow their systems to be int erconnected together. These proprietary packages, however, of which there am still many inexistence, do not address the problem of universal interconnect ability, or open systems interconnection. In an attempt to alleviate this problem, (70) , in the late 1970s, formulated a reference model to provide a common basis ( or the coordination of standards developments and to allow existing and evolving standards activities to beplaced into perspective with one another.A. same B. similar C. different D. dependent 31.结构化查询语言SQL是一种 (41) 语言，其主要功能有 (42) ，它的典型句型为 SELECT A1，A2，An FROM r1，r2，rm WHERE F 其中A1，A2，An、r1，r2，rm和F分别是 (43) 。 关系模式SCS(Sno，Cno，Score)中，Sno是学生的学号，Cno是课程号，Score为成绩。若要查询每门课程的平均成绩，且要求查询结果按平均成绩升序排列。平均成绩相同时，按课程号降序排列，可用SQL语言写为 (44) 。若查询结果仅限于平均分数超过85分的，则应 (45) 。A. 目标表列名、基本表名、逻辑表达式 B. 目标表列名、基本表名、数值表达式 C. 基本表名、目标表列名、逻辑表达式 D. 基本表名、目标表列名、数值表达式 32.设有员工实体Employee(员工号，姓名，性别，年龄，电话，家庭住址，家庭成员，关系，联系电话)。其中，“家庭住址”包括邮编、省、市、街道信息；“家庭成员，关系，联系电话”分别记录了员工亲属的姓名、与员工的关系以及联系电话，且一个员工允许有多个家庭成员。 员工实体Employee的主键为 (33) ；“家庭住址”是一个 (34) 属性；该关系属于 (35) ；为使数据库模式设计更合理，对于员工关系模式Employee (36) 。A2NF，无冗余，无插入异常和删除异常B2NF，无冗余，但存在插入异常和删除异常C1NF，存在冗余，但不存在修改操作的不一致D非1NF，且存在冗余和修改操作的不一致，以及插入异常和删除异常33.Typically, these are concern with the establishment of (66) the network and with the control of the flow of messages across this channel. The provision of such facilities is only part of the network requirements, however, since in many applications the communicating computers may be of different types. This means that they may use different programming languages and, more importantly, different forms of (67) interface between user(application)program, normally referred to, as application processes or APs, and the underlying communication services may be (68) For example, one computer may be a small single -user computer, while another may be a large (69) system. In the earlier days of computer communication, these issues meantthat only closed communities of computers ( that is, from the same manufacturer) could communicate with each other in a meaningful way. IBMs Systems Network. Architecture (SNA) and DECs Digital Network Architecture (DNA) are just two examples of Communication software packages produced by manufacturers to allow their systems to be int erconnected together. These proprietary packages, however, of which there am still many inexistence, do not address the problem of universal interconnect ability, or open systems interconnection. In an attempt to alleviate this problem, (70) , in the late 1970s, formulated a reference model to provide a common basis ( or the coordination of standards developments and to allow existing and evolving standards activities to beplaced into perspective with one another.A. multi - user B. client C. server D. full - user 34.结构化查询语言SQL是一种 (41) 语言，其主要功能有 (42) ，它的典型句型为 SELECT A1，A2，An FROM r1，r2，rm WHERE F 其中A1，A2，An、r1，r2，rm和F分别是 (43) 。 关系模式SCS(Sno，Cno，Score)中，Sno是学生的学号，Cno是课程号，Score为成绩。若要查询每门课程的平均成绩，且要求查询结果按平均成绩升序排列。平均成绩相同时，按课程号降序排列，可用SQL语言写为 (44) 。若查询结果仅限于平均分数超过85分的，则应 (45) 。A. SELECT Cno, AVG (Score. FROM SCS GROUP BY Score ORDER BY 2 ,Cno DESC B. SELECT Cno, AVG (Score. FROM SCS GROUP BY Cno ORDER BY 2 ,Cno DESCC. SELECT Cno, AVG (Score. FROM SCS WHERE Cno, DESC GROUP BY Score D. SELECT Cno, AVG (Score. FROM SCS GROU PBY, AVG (Score. ORDER BY,Cno DESC 35.Typically, these are concern with the establishment of (66) the network and with the control of the flow of messages across this channel. The provision of such facilities is only part of the network requirements, however, since in many applications the communicating computers may be of different types. This means that they may use different programming languages and, more importantly, different forms of (67) interface between user(application)progra