2023年云南软件水平考试考试模拟卷（4）

2023年云南软件水平考试考试模拟卷（4）本卷共分为1大题50小题，作答时间为180分钟，总分100分，60分及格。一、单项选择题（共50题，每题2分。每题的备选项中，只有一个最符合题意） 1.数据模型的三要素指 (51) ；其中 (52) 是对数据系统的静态特性的描述， (53) 是对数据库系统的动态特性的描述。A. 数据类型，数据值，数据操作 B. 数据类型，数据值，数据结构 C. 数据结构，数据操作，数据完整性约束 D. 数据类型，数据结构，数据完整性约束 2.As mentioned above, C imposes relatively few built - in ways of doing things on the program- mer. Some common tasks, such as manipulating (66) , (67) , and doing (68) (I/O), are performed by calling on library functions. Other tasks which you might want to do, such as creating or listing directories, or interacting with a mouse, or displaying windows or other (69) elements, or doing color graphics, are not defined by the C language at all. You can do these things from a C program, of course, but you will be calling on services which are peculiar to your programming environment (70) , processor, and operating system) and which are not defined by the C standard. Since this course is about portable C programming, it will also be steering clear of facilities not provided in all C environments.A. lines B. strings C. threads D. routes 3.The Simple Network Management Protocol (SNMP)is an (66) protocol that facilitates the exchange of management information between (67) . It is part of the Transmission Control Protocol/Internet Protocol(TCP/IP) protocol suite. SNMP enables network (68) to manage network performance, find and sole network problems, and plan for (69) An SNMP -managed network consists of three key components: managed devices , (70) ,and network -management systems .A. network stations B. network clients C. network devices D. network servers 4.计算机的使用方式有如下的 (2) 方式。其中， (3) 方式是把一批数据集中起来，通过通信线路传送到计算中心，由批处理程序加以处理。 批处理 远程批处理 双机 实时 分时 网络A. 远程批处理 B. 批处理 C. 双机 D. 分时 5.一条指令的执行可划分成取值，分析和执行三个部分，不同的部分由不同自由独立的硬件完成设每一指令完成取值，分析和执行三部分的时间分别为2ns，3ns，1ns现有100条指令，若顺序执行这些指令需要 (23) ；若采用流水方式执行这些指令则需要 (24) 。A. 200ns B. 300ns C. 500ns D. 600ns 6.数据的独立性是指 (28) 是相互独立的；它又可分为 (29) 。A. 内存数据独立性和外存数据独立性 B. 逻辑数据独立性和物理数据独立性 C. 数据库数据独立性和数据库外数据独立性 D. 结构化数据独立性和非结构化数据独立性 7.Object-oriented analysis (OOA) is a semiformal specification technique for the object-oriented paradigm. Object-oriented analysis consists of three steps. The first step is (71) . It determines how the various results are computed by the product and presents this information in the form of a (72) . and associated scenarios. The second is (73) , which determines the classes and their attributes; Then determine the interrelationships and interaction among the classes. The last step is (74) , which determines the actions performed by or to each class or subclass and presents this information in the form of (75) .A. collaboration diagram B. sequence diagram C. use-case diagram D. activity diagram 8.等值连接可由基本的关系运算 (32) 等价表达。给定关系贯、S如下图所示，则RS= (33) 。A、和B-、和C、和 D、和9.The Simple Network Management Protocol (SNMP)is an (66) protocol that facilitates the exchange of management information between (67) . It is part of the Transmission Control Protocol/Internet Protocol(TCP/IP) protocol suite. SNMP enables network (68) to manage network performance, find and sole network problems, and plan for (69) An SNMP -managed network consists of three key components: managed devices , (70) ,and network -management systems .A. servers B. administrators C. computers D. routers 10.一条指令的执行可划分成取值，分析和执行三个部分，不同的部分由不同自由独立的硬件完成设每一指令完成取值，分析和执行三部分的时间分别为2ns，3ns，1ns现有100条指令，若顺序执行这些指令需要 (23) ；若采用流水方式执行这些指令则需要 (24) 。A. 291ns B. 293ns C. 303ns D. 311ns 11.数据模型的三要素指 (51) ；其中 (52) 是对数据系统的静态特性的描述， (53) 是对数据库系统的动态特性的描述。A. 数据值 B. 数据类型 C. 数据结构 D. 数据操作 12.As mentioned above, C imposes relatively few built - in ways of doing things on the program- mer. Some common tasks, such as manipulating (66) , (67) , and doing (68) (I/O), are performed by calling on library functions. Other tasks which you might want to do, such as creating or listing directories, or interacting with a mouse, or displaying windows or other (69) elements, or doing color graphics, are not defined by the C language at all. You can do these things from a C program, of course, but you will be calling on services which are peculiar to your programming environment (70) , processor, and operating system) and which are not defined by the C standard. Since this course is about portable C programming, it will also be steering clear of facilities not provided in all C environments.A. allocating storage B. allocating memory C. distributing memory D. assigning storage 13.Object-oriented analysis (OOA) is a semiformal specification technique for the object-oriented paradigm. Object-oriented analysis consists of three steps. The first step is (71) . It determines how the various results are computed by the product and presents this information in the form of a (72) . and associated scenarios. The second is (73) , which determines the classes and their attributes; Then determine the interrelationships and interaction among the classes. The last step is (74) , which determines the actions performed by or to each class or subclass and presents this information in the form of (75) .A. use-case modeling B. class modeling C. dynamic modeling D. behavioral modeling 14.等值连接可由基本的关系运算 (32) 等价表达。给定关系贯、S如下图所示，则RS= (33) 。 15.数据库数据字典由 (54) 组成，它 (55) 。A. 关系和操作 B. 数据、关系和操作 C. 基本表和用户可存取的视图 D. 系统人员可存取的数据和用户可存取的视图 16.The Simple Network Management Protocol (SNMP)is an (66) protocol that facilitates the exchange of management information between (67) . It is part of the Transmission Control Protocol/Internet Protocol(TCP/IP) protocol suite. SNMP enables network (68) to manage network performance, find and sole network problems, and plan for (69) An SNMP -managed network consists of three key components: managed devices , (70) ,and network -management systems .A. network growth B. network structure C. network architectureD. network servers 17.某超市的商品(商品号，商品名称，生产商，单价)和仓库(仓库号，地址，电话，商品号，库存量)两个基本关系如表1和表2所示。 表1 18.数据模型的三要素指 (51) ；其中 (52) 是对数据系统的静态特性的描述， (53) 是对数据库系统的动态特性的描述。A. 数据值 B. 数据类型 C. 数据结构 D. 数据操作 19.Object-oriented analysis (OOA) is a semiformal specification technique for the object-oriented paradigm. Object-oriented analysis consists of three steps. The first step is (71) . It determines how the various results are computed by the product and presents this information in the form of a (72) . and associated scenarios. The second is (73) , which determines the classes and their attributes; Then determine the interrelationships and interaction among the classes. The last step is (74) , which determines the actions performed by or to each class or subclass and presents this information in the form of (75) .A. use-case modeling B. class modeling C. dynamic modeling D. behavioral modeling 20.部门DEPT (Deptno，Name，Tel，Leader)和职工EMP(Empno，Name，Sex，Address， Deptno)实体集，若一个职工只能属于一个部门，部门负责人Leader是一个职工。关系 DEPT和EMP的外码分别为 (30) ；下图中a、b处的实体名分别为 (31) 。ADeptno、EmpnoBName、DeptnoCLeader、DeptnoDName、Address21.As mentioned above, C imposes relatively few built - in ways of doing things on the program- mer. Some common tasks, such as manipulating (66) , (67) , and doing (68) (I/O), are performed by calling on library functions. Other tasks which you might want to do, such as creating or listing directories, or interacting with a mouse, or displaying windows or other (69) elements, or doing color graphics, are not defined by the C language at all. You can do these things from a C program, of course, but you will be calling on services which are peculiar to your programming environment (70) , processor, and operating system) and which are not defined by the C standard. Since this course is about portable C programming, it will also be steering clear of facilities not provided in all C environments.A. input/output B. inoptimization/optimization C. inside/outside D. inordinacy/ordinance 22.数据的独立性是指 (28) 是相互独立的；它又可分为 (29) 。A. 数据的存储位置和数据值 B. 操作系统和数据库中的数据 C. 用户的应用程序和存储在外存上的数据库中的数据 D. 以上均不对 23.收回用户li对表employee的查询权限，同时级联收旧li授予其他用户的该权限，SQL语句为： (52) select ON TABLE employee FROM li (53) ;AGRANTBGIVECCALL BACKDREVOKE24.The Simple Network Management Protocol (SNMP)is an (66) protocol that facilitates the exchange of management information between (67) . It is part of the Transmission Control Protocol/Internet Protocol(TCP/IP) protocol suite. SNMP enables network (68) to manage network performance, find and sole network problems, and plan for (69) An SNMP -managed network consists of three key components: managed devices , (70) ,and network -management systems .A. administrators B. agents C. managers D. servers 25.某超市的商品(商品号，商品名称，生产商，单价)和仓库(仓库号，地址，电话，商品号，库存量)两个基本关系如表1和表2所示。 表1 26.数据库数据字典由 (54) 组成，它 (55) 。A. 只读 B. 可读可写 C. 不同的数据库不同 D. 以上均不对 27.Object-oriented analysis (OOA) is a semiformal specification technique for the object-oriented paradigm. Object-oriented analysis consists of three steps. The first step is (71) . It determines how the various results are computed by the product and presents this information in the form of a (72) . and associated scenarios. The second is (73) , which determines the classes and their attributes; Then determine the interrelationships and interaction among the classes. The last step is (74) , which determines the actions performed by or to each class or subclass and presents this information in the form of (75) .A. activity diagram B. component diagram C. sequence diagram D. state diagram 28.部门DEPT (Deptno，Name，Tel，Leader)和职工EMP(Empno，Name，Sex，Address， Deptno)实体集，若一个职工只能属于一个部门，部门负责人Leader是一个职工。关系 DEPT和EMP的外码分别为 (30) ；下图中a、b处的实体名分别为 (31) 。ADEPT、EmpnoBDEPT、EMPCEMP、DepmoDEMP、DEPT29.As mentioned above, C imposes relatively few built - in ways of doing things on the program- mer. Some common tasks, such as manipulating (66) , (67) , and doing (68) (I/O), are performed by calling on library functions. Other tasks which you might want to do, such as creating or listing directories, or interacting with a mouse, or displaying windows or other (69) elements, or doing color graphics, are not defined by the C language at all. You can do these things from a C program, of course, but you will be calling on services which are peculiar to your programming environment (70) , processor, and operating system) and which are not defined by the C standard. Since this course is about portable C programming, it will also be steering clear of facilities not provided in all C environments.A. user - interconnect B. person - interconnect C. user - interface D. person - interface 30.收回用户li对表employee的查询权限，同时级联收旧li授予其他用户的该权限，SQL语句为： (52) select ON TABLE employee FROM li (53) ;ARESTRICTBCASCADECWITH GRANT OPTIONDWITH CHECK OPTION31.某超市的商品(商品号，商品名称，生产商，单价)和仓库(仓库号，地址，电话，商品号，库存量)两个基本关系如表1和表2所示。 表1 32.As mentioned above, C imposes relatively few built - in ways of doing things on the program- mer. Some common tasks, such as manipulating (66) , (67) , and doing (68) (I/O), are performed by calling on library functions. Other tasks which you might want to do, such as creating or listing directories, or interacting with a mouse, or displaying windows or other (69) elements, or doing color graphics, are not defined by the C language at all. You can do these things from a C program, of course, but you will be calling on services which are peculiar to your programming environment (70) , processor, and operating system) and which are not defined by the C standard. Since this course is about portable C programming, it will also be steering clear of facilities not provided in all C environments.A. gatherer B. translator C. generator D. compiler 33.某超市的商品(商品号，商品名称，生产商，单价)和仓库(仓库号，地址，电话，商品号，库存量)两个基本关系如表1和表2所示。 表1 34.某超市的商品(商品号，商品名称，生产商，单价)和仓库(仓库号，地址，电话，商品号，库存量)两个基本关系如表1和表2所示。 表1 35.某超市的商品(商品号，商品名称，生产商，单价)和仓库(仓库号，地址，电话，商品号，库存量)两个基本关系如表1和表2所示。 表1 36.某超市的商品(商品号，商品名称，生产商，单价)和仓库(仓库号，地址，电话，商品号，库存量)两个基本关系如表1和表2所示。 表1 37.某超市的商品(商品号，商品名称，生产商，单价)和仓库(仓库号，地址，电话，商品号，库存量)两个基本关系如表1和表2所示。 表1 38.某企业单位局域网中，客户机通过代理服务器访问Internet的连接方式如图2-6所示。IP地址为 192.168.1.100的客户机配置“TCP/IP网络属性”时，其中“默认网关”应设置为 (68) 。该客户机访问Internet中IP地址为220.110.10.234的Web站点时，经由代理服务器后数据包的源IP地址为 (69) 。 39.以下C程序段的输出结果是 (30) 。 #include stdio. h void abc(char *str) int a, b; for(a=b=0;stra!=O;a+) if(stra!=c) strb+=stra; strb=O; void main() char str=abcdef; abc(str); printf(str=%s,str);Astr=aBstr=abCstr=abdefDstr=abcdef 40.在一个客户信息系统中存在两种类型的客户：个人客户和集团客户。对于个人客户，系统中保存了其客户标识和基本信息(包括姓名、住宅电话和E-mail)：对于集团客户，系统中保存了其客户标识，以及与该集团客户相关的若干个联系人的信息(联系人的信息包括姓名、住宅电话、E-mail、办公电话和职位)。 根据上述描述，得到了如图2-5所示的UML类图，其中类“客户”的属性有 (46) ；类“人”的属性有 (47) 。 41.根据程序局部性理论，Denning提出了工作集理论。工作集是进程运行时被频繁访问的页面集合。在进程运行时，如果它的工作页面都在 (35) 内，能够使进程有效地运行，否则会出现频繁的页面调入/调出现象。 假设窗口尺寸为10，在某一段时间内，进程所访问的逻辑页面顺序如图2-2所示，那么在t1时刻的工作集是 (36) 。 42.为了便于存储和处理一般树结构形式的信息，常采用孩子-兄弟表示法将其转换成二叉树(左子关系表示父子、右子关系表示兄弟)，与图2-3所示的树对应的二叉树是 (39) 。 43.若对表2-1按 (61) 进行运算，可以得到表2-2。 表2-1 商品信息列表 条 形 码 44.某数据库中有员工关系E、产品关系P、仓库关系W和库存关系I，其中： 员工关系E(employeeID，name，department)中的属性为：员工编号，姓名，部门； 产品关系P(productID，name，model，size，color)中的属性为：产品编号，产品名称，型号，尺寸，颜色； 仓库关系W(warehouseID，name，address，employeeID)中的属性为：仓库编号，仓库名称，地址，负责人编号： 库存关系I(warehouseID，productID，quantity)中的属性为仓库编号，产品编号和产品数量。 若需得到每种产品的名称和该产品的总库存量，则对应的查询语句为： SELELCT name SUM(quantity) FROM P, I WHERE (62) :AproductID=I.productIDBproductID=1.productID ORDER BY nameCproductID=1.productlD GROUP BY nameDproductID=1.productlD GROUP BY name, quantity 45.某企业在计划期内要同时生产X、Y两种产品。已知生产单位产品所需的设备台及A、B两种原材料的消耗如表2-3所示。该企业每生产一件产品X可获利2000元，每生产一件产品Y可获利3000千元。合理安排计划能使该企业生产获取的最大利润是 (63) 元。表2-3 生产单位产品所需的设备台时及原材料消耗表 产 品 X 46.某企业单位局域网中，客户机通过代理服务器访问Internet的连接方式如图2-6所示。IP地址为 192.168.1.100的客户机配置“TCP/IP网络属性”时，其中“默认网关”应设置为 (68) 。该客户机访问Internet中IP地址为220.110.10.234的Web站点时，经由代理服务器后数据包的源IP地址为 (69) 。 47.在一个客户信息系统中存在两种类型的客户：个人客户和集团客户。对于个人客户，系统中保存了其客户标识和基本信息(包括姓名、住宅电话和E-mail)：对于集团客户，系统中保存了其客户标识，以及与该集团客户相关的若干个联系人的信息(联系人的信息包括姓名、住宅电话、E-mail、办公电话和职位)。 根据上述描述，得到了如图2-5所示的UML类图，其中类“客户”的属性有 (46) ；类“人”的属性有 (47) 。 48.根据程序局部性理论，Denning提出了工作集理论。工作集是进程运行时被频繁访问的页面集合。在进程运行时，如果它的工作页面都在 (35) 内，能够使进程有效地运行，否则会出现频繁的页面调入/调出现象。 假设窗口尺寸为10，在某一段时间内，进程所访问的逻辑页面顺序如图2-2所示，那么在t1时刻的工作集是 (36) 。 49.通常计算机的存储器是一个由Cache、主存和辅存构成的3级存储系统。辅助存储器一般可由磁盘、磁带和光盘等存储设备组成。Cache和主存一般是一种 (11) 存储器。在各种辅存中，除了 (12) 外，大多是便于脱卸和携带的。Cache存储器一般采用 (13) 半导体芯片，主存现主要由 (14) 半导体芯片组成。A随机存取B相联存取C只读存取D顺序存取50.通常计算机的存储器是一个由Cache、主存和辅存构成的3级存储系统。辅助存储器一般可由磁盘、磁带和光盘等存储设备组成。Cache和主存一般是一种 (11) 存储器。在各种辅存中，除了 (12) 外，大多是便于脱卸和携带的。Cache存储器一般采用 (13) 半导体芯片，主存现主要由 (14) 半导体芯片组成。A软盘BCD-ROMC磁带D硬盘