中级数据库系统工程师题库_计算机软件水平考试题库

单项选择题

数据库数据字典由 1 组成，它 2 。

A．关系和操作
B．数据、关系和操作
C．基本表和用户可存取的视图
D．系统人员可存取的数据和用户可存取的视图

单项选择题

现有一个空栈，栈顶指针为100H，现有输入序列为A、B、C、D、E，经过操作push，push， pop，push，pop，push后，输出的序列为 6 ，此时栈顶的指针为 7 。

A．B、C
B．A、B
C．A、C
D．B、D

单项选择题

SQL语句“平均成绩BETWEEN 80.0 AND 90.0”表示 ________ 。

A．平均成绩＞80.0 AND平均成绩＜90.0
B．平均成绩＜80.0 OR平均成绩＞90.0
C．平均成绩＞=80.0 AND平均成绩＜=90.0
D．平均成绩＜=80.0 OR平均成绩＞=90.0

单项选择题

CMM(Capability Maturity Model)是由美国国防部DOD指定CMU的软件工程研究所SEI研究出来的一套过程规范，它将软件过程的成熟度分为 ________ 。

A．Initial, Defined, Managed, Repeatable, Optimizing
B．Initial, Repeatable, Managed, Defined, Optimizing
C．Initial, Repeatable, Defined, Managed, Optimizing
D．Initial, Managed, Defined, Repeatable, Optimizing

单项选择题

Email收件人的标识即Email地址，它具有，地址中。

A．唯一确定性可以有空格
B．唯一确定性无空格
C．不唯一性可以有空格
D．不唯—性无空格

单项选择题

已知有关系“STUDENT”，则关系运算σ _ANE＜80 (STUDENT)用SQL语句表示为 ________ 。

A．SELECT( * )FROM STUDENT WHERE AVE ＜ 80
B．SELECT( * ) FROM STUDENT HAVING AVE ＜ 80
C．SELECT(AVE. FROM STUDENT WHERE AVE ＜ 80
D．SELECT(AVE） FROM STUDENT HAVING AVE ＜ 80

单项选择题

现有一个空栈，栈顶指针为100H，现有输入序列为A、B、C、D、E，经过操作push，push， pop，push，pop，push后，输出的序列为 6 ，此时栈顶的指针为 7 。

A．100H
B．101H
C．102H
D．103H

单项选择题

欲将表“学生”中的信息先按学号升序排序，再按平均成绩升序排列，其正确命令是 ________ 。

院系号

学号

姓名

性别

平均成绩

001
003
002
003
002
004
001

0013052
0030102
0022007
0031721
0023054
0042158
0015116

学生A
学生B
学生C
学生D
学生E
学生F
学生G

女
男
女
女
男
女
男

82.5
77.0
90.0
73.5
88.5
85.0
87.0

A．SELECT * FROM 学生 ORDER BY 学号 ASC，平均成绩 ASC
B．SELECT * FROM 学生 ORDER BY 平均成绩 ASC，学号 ASC
C．SELECT * FROM 学生 ORDER BY 学号 DESC，平均成绩 DESC
D．SELECT * FROM 学生 ORDER BY 平均成绩 DESC，学号 DESC

单项选择题

数据库系统软件包括 ________ 。

A．数据库和操作系统
B．数据库和相应的开发工具
C．数据库管理系统和数据库应用系统
D．数据库管理系统，数据库应用系统及相应的开发工具

单项选择题

设某磁带的有效磁带长为200m，记录的块系数为2，块间的间隔为10mm，记录长为100 (byte)，记录的密度为80(byte/mm)。将该磁带用于记录某种卡片(100byte)，则磁带上能记录的卡片数可为 ________ 。

A．160
B．320
C．1.6万
D．3.2万

单项选择题

由于学号(SN)为00291的学生已毕业，欲在关系“Student”中删除该学生的所有信息，用元组关系演算语言实现应为 ________ 。

A．GET W (Student): Student. SN = 00291"DELETE W
B．GET W: Student. SN = 00291"in StudentDELETE W
C．HOLD W (student): Student. SN = 00291"DELETE W
D．HOLD W: Student. SN = 00291"in StudentDELETE W

单项选择题

Sometimes the processes in which people are engaged are dependent upon other processes being completed first, possibly by other people. For example, on an automobile 30 , it is necessary for the body to be constructed before the doors can be added on. Attempting to add the doors first would be pointless, because there would be nowhere to attach them. Thus, if there is no body ready to have doors added, the process for adding doors has to be 31 until the process for creating the next body is complete. This is known as 32
Obviously, there are many cases where people have to wait for other people to do something. However, if everyone in such a situation is waiting for someone else to do something first, then no one will ever be able to do anything. When discussing processes, this situation is known as 33 , because all of the involved processes are effectively dead because of locks they have on resources. Usually someone in such a situation will eventually notice and abort the process, allowing normal flow to 34 , and often warning signs can even be spotted ahead of time to avoid "it in the first place.

A．water thread
B．assembly thread
C．water line
D．assembly line

单项选择题

Sometimes the processes in which people are engaged are dependent upon other processes being completed first, possibly by other people. For example, on an automobile 30 , it is necessary for the body to be constructed before the doors can be added on. Attempting to add the doors first would be pointless, because there would be nowhere to attach them. Thus, if there is no body ready to have doors added, the process for adding doors has to be 31 until the process for creating the next body is complete. This is known as 32
Obviously, there are many cases where people have to wait for other people to do something. However, if everyone in such a situation is waiting for someone else to do something first, then no one will ever be able to do anything. When discussing processes, this situation is known as 33 , because all of the involved processes are effectively dead because of locks they have on resources. Usually someone in such a situation will eventually notice and abort the process, allowing normal flow to 34 , and often warning signs can even be spotted ahead of time to avoid "it in the first place.

A．suspended
B．broken
C．hung
D．hold

单项选择题

Sometimes the processes in which people are engaged are dependent upon other processes being completed first, possibly by other people. For example, on an automobile 30 , it is necessary for the body to be constructed before the doors can be added on. Attempting to add the doors first would be pointless, because there would be nowhere to attach them. Thus, if there is no body ready to have doors added, the process for adding doors has to be 31 until the process for creating the next body is complete. This is known as 32
Obviously, there are many cases where people have to wait for other people to do something. However, if everyone in such a situation is waiting for someone else to do something first, then no one will ever be able to do anything. When discussing processes, this situation is known as 33 , because all of the involved processes are effectively dead because of locks they have on resources. Usually someone in such a situation will eventually notice and abort the process, allowing normal flow to 34 , and often warning signs can even be spotted ahead of time to avoid "it in the first place.

A．timing
B．synchronization
C．contemporary
D．simultaneity

单项选择题

在VFP的命令窗口中进行日期的设置，要求以MM-DD-YY形式显示日期“11-15- 05”，应使用命令 ________ 。

A．SET DATE TO MDY DATE()&&显示"11-15-05"
B．SET DATE TO MDYDATE( )&& ,显示" 11 - 15 -05"
C．SET DATE TO MDY DATE( )显示" 11 - 15 -05"
D．SET DATE TO MDY DATE ( ) 显示" 11 - 15 - 05"

单项选择题

Sometimes the processes in which people are engaged are dependent upon other processes being completed first, possibly by other people. For example, on an automobile 30 , it is necessary for the body to be constructed before the doors can be added on. Attempting to add the doors first would be pointless, because there would be nowhere to attach them. Thus, if there is no body ready to have doors added, the process for adding doors has to be 31 until the process for creating the next body is complete. This is known as 32
Obviously, there are many cases where people have to wait for other people to do something. However, if everyone in such a situation is waiting for someone else to do something first, then no one will ever be able to do anything. When discussing processes, this situation is known as 33 , because all of the involved processes are effectively dead because of locks they have on resources. Usually someone in such a situation will eventually notice and abort the process, allowing normal flow to 34 , and often warning signs can even be spotted ahead of time to avoid "it in the first place.

A．waiting lock
B．block
C．deadlock
D．death

单项选择题

TCP/IP模型由低到高可分为 ________ 四个层次。

A．网络接口层，网际层，传输层，应用层
B．网络接口层，链路层，传输层，应用层
C．物理层，链路层，传输层，应用层
D．网络接口层，会话层，传输层，应用层

单项选择题

在以下各种转换和映象中，应用程序可实现的是 37 ；数据库管理系统(DBMS)可实现的是 38 。

A．模式与子模式之间的映象
B．内模式与外模式之间的映象
C．存储模式与数据物理组织之间的映象
D．从外部视图到子模式的数据结构的转换

单项选择题

Sometimes the processes in which people are engaged are dependent upon other processes being completed first, possibly by other people. For example, on an automobile 30 , it is necessary for the body to be constructed before the doors can be added on. Attempting to add the doors first would be pointless, because there would be nowhere to attach them. Thus, if there is no body ready to have doors added, the process for adding doors has to be 31 until the process for creating the next body is complete. This is known as 32
Obviously, there are many cases where people have to wait for other people to do something. However, if everyone in such a situation is waiting for someone else to do something first, then no one will ever be able to do anything. When discussing processes, this situation is known as 33 , because all of the involved processes are effectively dead because of locks they have on resources. Usually someone in such a situation will eventually notice and abort the process, allowing normal flow to 34 , and often warning signs can even be spotted ahead of time to avoid "it in the first place.

A．begin
B．resume
C．presume
D．take back

单项选择题

在以下各种转换和映象中，应用程序可实现的是 37 ；数据库管理系统(DBMS)可实现的是 38 。

A．模式与子模式之间的映象
B．内模式与外模式之间的映象
C．存储模式与数据物理组织之间的映象
D．从外部视图到子模式的数据结构的转换

院系号	学号	姓名	性别	平均成绩
001 003 002 003 002 004 001	0013052 0030102 0022007 0031721 0023054 0042158 0015116	学生A 学生B 学生C 学生D 学生E 学生F 学生G	女男女女男女男	82.5 77.0 90.0 73.5 88.5 85.0 87.0

在软件开发过程中，各阶段的正确顺序应该是 17 ；其中在 18 阶段提出系统的逻辑模型

你可能感兴趣的试题

数据库数据字典由 1 组成，它 2 。

现有一个空栈，栈顶指针为100H，现有输入序列为A、B、C、D、E，经过操作push，push， pop，push，pop，push后，输出的序列为 6 ，此时栈顶的指针为 7 。

SQL语句“平均成绩BETWEEN 80.0 AND 90.0”表示 ________ 。

CMM(Capability Maturity Model)是由美国国防部DOD指定CMU的软件工程研究所SEI研究出来的一套过程规范，它将软件过程的成熟度分为 ________ 。

Email收件人的标识即Email地址，它具有 ________ ，地址中 ________ 。

已知有关系“STUDENT”，则关系运算σ ANE＜80 (STUDENT)用SQL语句表示为 ________ 。

现有一个空栈，栈顶指针为100H，现有输入序列为A、B、C、D、E，经过操作push，push， pop，push，pop，push后，输出的序列为 6 ，此时栈顶的指针为 7 。

数据库数据字典由 1 组成，它 2 。

在软件著作权的保护期内，软件著作权人享有发表权、开发者身份权、使用权、使用许可权和获得报酬权以及转让权。当软件著作权保护期满后， ________ 。

以下关于木马病毒的陈述中不正确的是 ________ 。

已知(114) 6 表示六进制的114，则其用八进制可表示为 ________ 。

数据字典和PAD(问题分析图)是两类非常重要的软件工具，它们主要分别用在软件生存周期中 12 阶段和 13 阶段。

数据字典和PAD(问题分析图)是两类非常重要的软件工具，它们主要分别用在软件生存周期中 12 阶段和 13 阶段。

数据库管理系统(DBMS)是位于操作系统与用户之间的一个数据管理软件，其主要功能包括 ________ 。

数据库系统采用的数据模型有层次模型、网状模型和关系模型三种。VFP6.0数据库系统采用的是 ________ 型。

快速排序方法(Quick Sort)的时间复杂度为 ________ 。

在软件开发过程中，各阶段的正确顺序应该是 17 ；其中在 18 阶段提出系统的逻辑模型

网络安全具有几方面的特性： ________ 指的是数据未经授权不允许进行改变。

以下各字符中ASCII码值最大的是 ________ 。

在软件开发过程中，各阶段的正确顺序应该是 17 ；其中在 18 阶段提出系统的逻辑模型

若某时期投入市场的某型号机器上编制的软件能不加修改地运行于在它之后投入市场的机器上称做 ________ 。

某有向强连通图有n个顶点，则其边数不小于 ________ 。

在数据库系统中，若某基本层次联系的集合满足以下两个条件：有且仅有一个结点无双亲；其它结点有且仅有一个双亲，则该集合称为 ________ 。

在计算机网络系统的远程通信中，通常采用的传输技术是 ________ 。

在队列中， ________ 允许插入操作， ________ 允许删除操作。

数据库系统软件包括 ________ 。

设某磁带的有效磁带长为200m，记录的块系数为2，块间的间隔为10mm，记录长为100 (byte)，记录的密度为80(byte/mm)。将该磁带用于记录某种卡片(100byte)，则磁带上能记录的卡片数可为 ________ 。

由于学号(SN)为00291的学生已毕业，欲在关系“Student”中删除该学生的所有信息，用元组关系演算语言实现应为 ________ 。

在VFP的命令窗口中进行日期的设置，要求以MM-DD-YY形式显示日期“11-15- 05”，应使用命令 ________ 。

TCP/IP模型由低到高可分为 ________ 四个层次。

在以下各种转换和映象中，应用程序可实现的是 37 ；数据库管理系统(DBMS)可实现的是 38 。

在以下各种转换和映象中，应用程序可实现的是 37 ；数据库管理系统(DBMS)可实现的是 38 。

Email收件人的标识即Email地址，它具有，地址中。

已知有关系“STUDENT”，则关系运算σ _ANE＜80 (STUDENT)用SQL语句表示为 ________ 。

已知(114) ₆ 表示六进制的114，则其用八进制可表示为 ________ 。

在队列中，允许插入操作，允许删除操作。