with the given policies?
A) Tian has W(write) access to An's Mail files
B) Tian has E(execute) access to An's Mail files
C) Chian has R(read) access to An's text files
D) Tian has E(execute) access to Chang's Binary files
(62) Software Engineering Economy is an effective part of software engineering, which of the following content is the research comtent of software engineering economy?
Ⅰ.Estimation of software development cost
Ⅱ.Earn & Cost analysis of software development
Ⅲ.Adjustment of software development progress
A) Ⅲ only B) Ⅱ and Ⅲ C) Ⅰ and Ⅱ D) all
(63) Prototype method is one of the software engineering methods frequently used, which of the following item is the necessary condition for implementing prototype method?
Ⅰ.Can acquire the user requirement quickly
Ⅱ.Have the tools for building software fast
Ⅲ.Have a certain accumulation of prototype systems
A) Ⅰ only B) Ⅰand Ⅱ C) Ⅱ and Ⅲ D) all
(64) ORACLE RDBMS is a distributed DBMS. Which of the following techniques adapted ensure atomicity of distributed transaction?
A) remote procedure call (RPC) B) Two _phases commit (2PC)
C) Snapshots D) triggers
(65) In order to get names of schoolboys(SEX='M')whose age=22, from a relation S(SNO,SNAME,SEX,AGE),which of the following expressions is (are) correct?
Ⅰ.πsname(σsex='M'^age=22(S))
Ⅱ.σsex='M'^age=22(πsname(S))
A) Ⅰ only B) Ⅱ only C) Ⅰand Ⅱ D) neither
(66) In order to improve the performance of a network server, you need to select bus or local bus. The appropriate local bus is
A) VESA B) PCI C) EISA D) ISA
(67) In terms of M.J.Flynn's taxonomy, the systolic array falls into
A) SISD B) MIMD C) SIMD D) MISD
(68) In the WAN, when a point-to-point subnet is used, an important design issue is the roucer interconnection
A) topology B) computer C) service D) lines
(69) In the Ethernet LAN, an algorithm was chosen to dynarnically adapt to the number of stations trying to send. It is called
A) backward learning B) binary exponential backoff
C) spanning tree D) CRC
(70) The typical firewall consists of two packet filters and a (an)
A) router B) bridge C) application D) server
二、论述题 (四个论述题可任选其一,并只选其一,多选无效,满分30分)
论述题 1
设计一个用于管理会议室的数据库。经调查分析,得到的数据项列出如下:
房间号r# CHAR(4),部门号d# CHAR(3),部门名称dname CHAR(20),
房间容量content INT,部门主管dmanager CHAR(8),开会日期mdate DATE,
会议名称cname CHAR(20),会议主题(subject)CHAR(80),会议类型(type),
部门人数dnum INT,当前房间状态state CHAR(1),
并确定以会议室(room)信息,部门(department)信息,会议(conference)信息为实体,它们通过"开会(meeting)"联系起来。为了简化问题做如下假定:
l 会议以部门召开,但一个部门在同一会议室不能重复召开同一个会议。
l 会议室按部门借用,且不预借。
l 当前房间状态取值为'1'表示该会议室当前正在开会,取值为'0'表示该会议室当前未被借用。
数据库概念设计的只包含主键属性的简化E-R图如下:
要求:
⑴ 数据库的逻辑结构设计:给出相应的表名、表的属性名(数据类型可省)、主键。(14分)
⑵ 给出下列查询的SQL语句:(16分,每小题4分)
a) 当前未借用的会议室(房间号)和容量:
b) 2000年4月8日有哪些部门(部门名称)在开会?他们的主管是谁?
c) 2000年4月8日'信息中心'在哪个会议室(房间号)开会?会议名称和主题是什么?
d) 当前能够适合'信息中心'开会的有哪些会议室(房间号)?
论述题2
原型化方法或称快速原型化方法是一种当前常用的软件工程方法,尽管其特征民传统的结构化生命周期法有所不同,但从原型化方法的演变仔细分析,仍可看出它与结构化方法的内在联系,试回顾两种方法的发展特征和演进历史并论述下述问题: |