试题一
[问题1] 初录数据、复录数据
[问题2] 0层图中,数据清除处理(加工6)没有输入数据流
[问题3] ①
[问题4] ①、②、④
[问题5] 手工分户帐=初录分户帐+复录分户帐
试题二
[问题1] (1)房间号,身份证号
[问题2]
住宿主键:房间号,身份证号,入住日期
住宿外键:房间号,身份证号,
[问题3] (2)住宿.身份证号 (3)HAVING (4)ORDER BY 2 DSC
[问题4]
表:住宿 属性:入住日期 类型:聚簇索引
原因:表中记录的物理顺序与索引项的顺序一致,根据索引访问数据时,一次读取操作可以获取多条记录数据,因而可减少查询时间。
试题三
[问题1](1)0..n (2)1 (3)0..n (4)1..n (5)1 (6)0..n
[问题2]
(1) getCategories
(2) getCommodities
(3) createPromotion
(4) addCommodities
[问题3]
关系:聚集(聚合)是关联的特例。不同点:聚集表示部分与整体关系的关联。
试题四
(1) f[0][0] = e[0] + a[0][0]
f[1][0] = e[1] + a[1][0]
(2) f[0][j-1]+a[0][j]
(3) f[1][j-1]+a[1][j] < f[0][j-1]+t[0][j-1]+a[1][j]
(4) fi = f[0][n-1]+x[0]
li = 0
(5) fi = f[1][n-1]+x[1]
li = 1
试题五
(1) EnQueue(&tempQ,root)
(2) brotherptr = brotherptr -> nextbrother
(3) !IsEmpty(tempQ)
(4) DeQueue(&tempQ, &ptr)
(5) !ptr->firstchild
(6) EnQueue(&tempQ,ptr->firstchild)
(7) brotherptr = brotherptr -> nextbrother
试题六
(1) state == CLOSED || state == CLOSING
(2) state == OPENING || state == STAYOPEN
(3) state == OPEN
(4) state ->click()
(5) state ->timeout()
(6) state ->complete()
(7) door->setState(door->OPENING)
试题七
(1) state == CLOSED || state == CLOSING
(2) state == OPENING || state == STAYOPEN
(3) state == OPEN
(4) state.click()
(5) state.timeout()
(6) state.complete()
(7) door.setState(door.OPENING)
责任编辑:小草