2023年甘肃软件水平考试考试真题卷（9）.docx

《2023年甘肃软件水平考试考试真题卷（9）.docx》由会员分享，可在线阅读，更多相关《2023年甘肃软件水平考试考试真题卷（9）.docx（29页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、2023年甘肃软件水平考试考试真题卷（9）本卷共分为1大题50小题，作答时间为180分钟，总分100分，60分及格。一、单项选择题（共50题，每题2分。每题的备选项中，只有一个最符合题意） 1.设机器码的长度为8，x为带符号纯小数，y为带符号纯整数，X原11111111，Y补11111111，则x的十进制真值为（），y的十进制真值为（）。y的十进制真值为（）A-1B127C-127D12.在Word编辑状态下，可以把一段字符的格式快速应用到另一段字符上，这样能够提高编排文章的效率，其方法是：单击常用工具栏上的（）按钮，然后移动鼠标到待格式化的文本开始处，（）。然后移动鼠标到待格式化的文本开始处

2、，（）A按Alt键的同时单击鼠标左键即可B按Alt键的同时单击鼠标右键即可C按住鼠标左键拖动鼠标，到达待格式化的文本末尾时松开鼠标键D按住鼠标右键拖动鼠标，到达待格式化的文本末尾时松开鼠标键3.A multicast router may receive thousands of multicast（）every day for different groups. If a router has no knowledge about the membership status of the（）, it must broadcast all of these packets. This crea

3、tes a lot of traffic and consumes（）. A better solution is to keep a list of groups in the network for which there is at least one loyal member.（）helps the multicast router create and update this list. For each group, there is one router that has the duty of distributing the（）packets destined for tha

4、t group. This means that if there are three multicast routers connected to a network, their lists of groupids are mutually exclusive. A host or multicast router can have membership in a group.A multicast router may receive thousands of multicast（）every day for different groups.ApacketsBerrorsCreport

5、sDalarms4.SNMP代理使用（）操作向管理端通报重要事件的发生。在下图中，（）能够响应Manager2的getRequest请求。SNMP代理使用（）操作向管理端通报重要事件的发生。AGetRequestBGet-nextRequestCSetRequestDTrap5.某公司网络地址是206110640/18，被划分成16个子网，则每个子网的子网掩码为（），最大可容纳的主机数是（）。每个子网的子网掩码为（）A2552552550B2552552540C2552552520D25525524006.某公司网络地址是206110640/18，被划分成16个子网，则每个子网的子网掩码为（）

6、，最大可容纳的主机数是（）。最大可容纳的主机数是（）A254B512C1022D10247.有4个网络地址：1924716254、192471701、192473225和192473305，如果子网掩码为2552552400，则这4个地址分别属于（）个子网。下面列出的地址对，中，属于同一个子网的是（）。下面列出的地址对，中，属于同一个子网的是（）A192.47.16.254 和 192.47.32.25B192.47.16.254 和 192.47.17.01C192.47.17.01 和 192.47.33.05D192.47.17.01 和 192.47.32.258.A multicas

7、t router may receive thousands of multicast（）every day for different groups. If a router has no knowledge about the membership status of the（）, it must broadcast all of these packets. This creates a lot of traffic and consumes（）. A better solution is to keep a list of groups in the network for which

8、 there is at least one loyal member.（）helps the multicast router create and update this list. For each group, there is one router that has the duty of distributing the（）packets destined for that group. This means that if there are three multicast routers connected to a network, their lists of groupi

9、ds are mutually exclusive. A host or multicast router can have membership in a group.If a router has no knowledge about the membership status of the（）, it must broadcast all of these packets.AroutersBnetworkCpacketsDhosts9.SNMP代理使用（）操作向管理端通报重要事件的发生。在下图中，（）能够响应Manager2的getRequest请求。在下图中，（）能够响应Manager

10、2的getRequest请求。AAgent1BAgent2CAgent3DAgent410.A multicast router may receive thousands of multicast（）every day for different groups. If a router has no knowledge about the membership status of the（）, it must broadcast all of these packets. This creates a lot of traffic and consumes（）. A better solut

11、ion is to keep a list of groups in the network for which there is at least one loyal member.（）helps the multicast router create and update this list. For each group, there is one router that has the duty of distributing the（）packets destined for that group. This means that if there are three multica

12、st routers connected to a network, their lists of groupids are mutually exclusive. A host or multicast router can have membership in a group.This creates a lot of traffic and consumes（）.AcapabilityBpowerCbandwidthDaddress11.A multicast router may receive thousands of multicast（）every day for differe

13、nt groups. If a router has no knowledge about the membership status of the（）, it must broadcast all of these packets. This creates a lot of traffic and consumes（）. A better solution is to keep a list of groups in the network for which there is at least one loyal member.（）helps the multicast router c

14、reate and update this list. For each group, there is one router that has the duty of distributing the（）packets destined for that group. This means that if there are three multicast routers connected to a network, their lists of groupids are mutually exclusive. A host or multicast router can have mem

15、bership in a group.（）helps the multicast router create and update this list.AICMPBIGMPCOSPFDRIP12.A multicast router may receive thousands of multicast（）every day for different groups. If a router has no knowledge about the membership status of the（）, it must broadcast all of these packets. This cre

16、ates a lot of traffic and consumes（）. A better solution is to keep a list of groups in the network for which there is at least one loyal member.（）helps the multicast router create and update this list. For each group, there is one router that has the duty of distributing the（）packets destined for th

17、at group. This means that if there are three multicast routers connected to a network, their lists of groupids are mutually exclusive. A host or multicast router can have membership in a group.For each group, there is one router that has the duty of distributing the（）packets destined for that group.

18、AanycastBmulticastCunicastDbroadcast13.在微型计算机中，通常用主频来描述CPU的（）；对计算机磁盘工作影响最小的因素是（）。通常用主频来描述CPU的（）。A运算速度B可靠性C可维护性D可扩充性14.操作系统是裸机上的第一层软件，其他系统软件(如（）等)和应用软件都是建立在操作系统基础上的。下图分别表示（）。其他系统软件（如（）等）和应用软件都是建立在操作系统基础上的。A编译程序、财务软件和数据库管理系统软件B汇编程序、编译程序和Java解释器C编译程序、数据库管理系统软件和汽车防盗程序D语言处理程序、办公管理软件和气象预报软件15.模块设计中常用的衡量指标

19、是内聚和耦合，内聚程度最高的是（）；耦合程度最低的是（）。内聚程度最高的是（）。A逻辑内聚B过程内聚C顺序内聚D功能内聚16.设有员工关系Emp(员工号，姓名，性别，部门，家庭住址)，其中，属性性别的取值只能为M或F；属性部门是关系Dept的主键。要求可访问家庭住址的某个成分，如邮编、省、市、街道以及门牌号。关系Emp的主键和外键分别是（）。家庭住址是一个（）属性。创建Emp关系的SQL语句如下：CREATE TABLE Emp(员工号CHAR(4)姓名CHAR(10)性别JCHAR(1)（），门CHAR(4)（），家庭住址CHAR(30)PRINARY KEY (员工号) )；关系Emp的主

20、键和外键分别是（）。A员工号、部门B姓名、部门C员工号、家庭住址D姓名、家庭住址17.Why is （） fun？What de lights may its practitioner expect as his reward？First is the sheer joy of making things. As the child delights in his mud pie, so the adult enjoys building things, especially things of his own design. Second is the pleasure of making

21、things that are useful to other people. Third is the fascination of fashioning complex puzzle-like objects of interlocking moving parts and watching them work in subtle cycles, playing out the consequences of principles built in from the beginning. Fourth is the joy of always learning, which springs

22、 from the （） nature of the task. In one way or another the problem is ever new, and its solver learns something: sometimes （）, sometimes theoretical, and sometimes both. Finally, there is the delight of working in such a tractable medium. The （）, like the poet, works only slightly removed from pure

23、thought-stuff. Few media of creation are so flexible, so easy to polish and rework, so readily capable of realizing grand conceptual structures.Yet the program （）, unlike the poet’s words, is real in the sense that it moves and works, producing visible outputs separate from the construct itsel

24、f. It prints results, draws pictures, produces sounds, moves arms. Programming then is fun because it gratifies creative longings built deep within us and delights sensibilities we have in common with all men.Why is （） fun？AprogrammingBcomposingCworkingDwriting18.操作系统是裸机上的第一层软件，其他系统软件(如（）等)和应用软件都是建立

25、在操作系统基础上的。下图分别表示（）。下图分别表示（）。A应用软件开发者、最终用户和系统软件开发者B应用软件开发者、系统软件开发者和最终用户C最终用户、系统软件开发者和应用软件开发者D最终用户、应用软件开发者和系统软件开发者19.模块设计中常用的衡量指标是内聚和耦合，内聚程度最高的是（）；耦合程度最低的是（）。耦合程度最低的是（）。A数据耦合B内容耦合C公共耦合D控制耦合20.Why is （） fun？What de lights may its practitioner expect as his reward？First is the sheer joy of making things

26、. As the child delights in his mud pie, so the adult enjoys building things, especially things of his own design. Second is the pleasure of making things that are useful to other people. Third is the fascination of fashioning complex puzzle-like objects of interlocking moving parts and watching them

27、 work in subtle cycles, playing out the consequences of principles built in from the beginning. Fourth is the joy of always learning, which springs from the （） nature of the task. In one way or another the problem is ever new, and its solver learns something: sometimes （）, sometimes theoretical, and

28、 sometimes both. Finally, there is the delight of working in such a tractable medium. The （）, like the poet, works only slightly removed from pure thought-stuff. Few media of creation are so flexible, so easy to polish and rework, so readily capable of realizing grand conceptual structures.Yet the p

29、rogram （）, unlike the poet’s words, is real in the sense that it moves and works, producing visible outputs separate from the construct itself. It prints results, draws pictures, produces sounds, moves arms. Programming then is fun because it gratifies creative longings built deep within us an

30、d delights sensibilities we have in common with all men.Fourth is the joy of always learning, which springs from the （） nature of the task.ArepeatingBbasicCnon-repeatingDadvance21.在微型计算机中，通常用主频来描述CPU的（）；对计算机磁盘工作影响最小的因素是（）。对计算机磁盘工作影响最小的因素是（）。A温度B湿度C噪声D磁场22.设有员工关系Emp(员工号，姓名，性别，部门，家庭住址)，其中，属性性别的取值只能为M或

31、F；属性部门是关系Dept的主键。要求可访问家庭住址的某个成分，如邮编、省、市、街道以及门牌号。关系Emp的主键和外键分别是（）。家庭住址是一个（）属性。创建Emp关系的SQL语句如下：CREATE TABLE Emp(员工号CHAR(4)姓名CHAR(10)性别JCHAR(1)（），门CHAR(4)（），家庭住址CHAR(30)PRINARY KEY (员工号) )；“家庭住址”是一个（）属性。A简单B复合C多值D派生23.Why is （） fun？What de lights may its practitioner expect as his reward？First is the s

32、heer joy of making things. As the child delights in his mud pie, so the adult enjoys building things, especially things of his own design. Second is the pleasure of making things that are useful to other people. Third is the fascination of fashioning complex puzzle-like objects of interlocking movin

33、g parts and watching them work in subtle cycles, playing out the consequences of principles built in from the beginning. Fourth is the joy of always learning, which springs from the （） nature of the task. In one way or another the problem is ever new, and its solver learns something: sometimes （）, s

34、ometimes theoretical, and sometimes both. Finally, there is the delight of working in such a tractable medium. The （）, like the poet, works only slightly removed from pure thought-stuff. Few media of creation are so flexible, so easy to polish and rework, so readily capable of realizing grand concep

35、tual structures.Yet the program （）, unlike the poet’s words, is real in the sense that it moves and works, producing visible outputs separate from the construct itself. It prints results, draws pictures, produces sounds, moves arms. Programming then is fun because it gratifies creative longing

36、s built deep within us and delights sensibilities we have in common with all men.sometimes （）, sometimes theoretical, and sometimes both.AsemanticBpracticalClexicalDsyntactical24.设有员工关系Emp(员工号，姓名，性别，部门，家庭住址)，其中，属性性别的取值只能为M或F；属性部门是关系Dept的主键。要求可访问家庭住址的某个成分，如邮编、省、市、街道以及门牌号。关系Emp的主键和外键分别是（）。家庭住址是一个（）属性。

37、创建Emp关系的SQL语句如下：CREATE TABLE Emp(员工号CHAR(4)姓名CHAR(10)性别JCHAR(1)（），门CHAR(4)（），家庭住址CHAR(30)PRINARY KEY (员工号) )；性别JCHAR(1)（）。Am(M,F)BLIKE(’M’，’P’)CCHECK(’M’，’T’)DCHECK(性别IN(’M’，’F’)25.设有员工关系Emp(员工号，姓名，性别，部门，家庭住址)，其中，属性性别的取值只能为M或F；属

38、性部门是关系Dept的主键。要求可访问家庭住址的某个成分，如邮编、省、市、街道以及门牌号。关系Emp的主键和外键分别是（）。家庭住址是一个（）属性。创建Emp关系的SQL语句如下：CREATE TABLE Emp(员工号CHAR(4)姓名CHAR(10)性别JCHAR(1)（），门CHAR(4)（），家庭住址CHAR(30)PRINARY KEY (员工号) )；门CHAR(4)（）。ANOTNULLBREFERENCESDept(部门)CNOTNULLUNIQUEDREFERENCESDept(’部门’)26.Why is （） fun？What de lights

39、may its practitioner expect as his reward？First is the sheer joy of making things. As the child delights in his mud pie, so the adult enjoys building things, especially things of his own design. Second is the pleasure of making things that are useful to other people. Third is the fascination of fash

40、ioning complex puzzle-like objects of interlocking moving parts and watching them work in subtle cycles, playing out the consequences of principles built in from the beginning. Fourth is the joy of always learning, which springs from the （） nature of the task. In one way or another the problem is ev

41、er new, and its solver learns something: sometimes （）, sometimes theoretical, and sometimes both. Finally, there is the delight of working in such a tractable medium. The （）, like the poet, works only slightly removed from pure thought-stuff. Few media of creation are so flexible, so easy to polish

42、and rework, so readily capable of realizing grand conceptual structures.Yet the program （）, unlike the poet’s words, is real in the sense that it moves and works, producing visible outputs separate from the construct itself. It prints results, draws pictures, produces sounds, moves arms. Progr

43、amming then is fun because it gratifies creative longings built deep within us and delights sensibilities we have in common with all men.The （）, like the poet, works only slightly removed from pure thought-stuff.ApoetBarchitectCdoctorDprogrammer27.Why is （） fun？What de lights may its practitioner ex

44、pect as his reward？First is the sheer joy of making things. As the child delights in his mud pie, so the adult enjoys building things, especially things of his own design. Second is the pleasure of making things that are useful to other people. Third is the fascination of fashioning complex puzzle-l

45、ike objects of interlocking moving parts and watching them work in subtle cycles, playing out the consequences of principles built in from the beginning. Fourth is the joy of always learning, which springs from the （） nature of the task. In one way or another the problem is ever new, and its solver

46、learns something: sometimes （）, sometimes theoretical, and sometimes both. Finally, there is the delight of working in such a tractable medium. The （）, like the poet, works only slightly removed from pure thought-stuff. Few media of creation are so flexible, so easy to polish and rework, so readily

47、capable of realizing grand conceptual structures.Yet the program （）, unlike the poet’s words, is real in the sense that it moves and works, producing visible outputs separate from the construct itself. It prints results, draws pictures, produces sounds, moves arms. Programming then is fun beca

48、use it gratifies creative longings built deep within us and delights sensibilities we have in common with all men.Yet the program （）, unlike the poets words, is real in the sense that it moves and works, producing visible outputs separate from the construct itself.AconstructBcodeCsizeDscale28.在Excel表处理软件中，（）是当公式在复制或移动时会根据移动的位置自动调节公式中引用单元格的地址。假设单元格A1、A2、B1和B2内容如下图所示，并在C1中输入公式=$A$1+$B$1，并将公式