应届生求职招聘论坛

标题: ORACLE 第一轮笔试题目11月8日 1 [打印本页]

作者: annmmliu 时间: 2008-11-8 14:46
标题: ORACLE 第一轮笔试题目11月8日 1

这个是我2008年十一月8号做的orale的上机做的题目；

只有部分；大家参考；

Question Number 20In the implementation of many linear linked structures it is often useful to keep a pointer to the last node in addition to the first, so that a new node can be added at the end without having to loop through the entire structure looking for the last node. In what ways would adding a pointer to the last node improve the efficiency of this dictionary implementation?It would speed up put operations when the dictionary contains an item with the designated key_It would speed up put operations when the dictionary does not contain an item with the designated key.

neither

A but not B

both

B but not A------------

ABC Housekeeping Forces are responsible for maintaining a building that comprises of 100 floors. The maintenance company decides to use a database to schedule work for its employees and also check the status of the work. When an assigned housekeeper does not report for work, an alternate resource is allotted to complete the job.

The Housekeeping database in its un-normalized form is given below:

HouseKeeperID – ID of the housekeeper

HouseKeeperName – Housekeeper's Name

SupervisorID – ID of the Housekeeper's

Supervisor

SupervisorName - Name of the Housekeeper's

Supervisor

DutyID – ID of an assigned duty

FloorNo – Floor to which the duty is

assigned

DutyDate – Date on which the duty has to be

done

WorkStatus - Status of the duty

AlternateHID - ID of the alternate housekeeper's

assigned to complete the job, in

case the originally assigned

housekeeper is absent.

AlternateWorkSt – Work Status of the Alternate

Housekeeper's duty.

From the following options, select the Housekeeping database in 2NF.

Housekeeper

HouseKeeperID

HouseKeeperName

Supervisor

SupervisorID

SupervisorName

Duty

DutyID

FloorNo

DutyDate

Transaction

DutyID

FloorNo

-----------

HouseKeeperID

WorkStatus

AlternateHID

AlternateWorkSt

--------------

Housekeeper

HouseKeeperID

HouseKeeperName

SupervisorID

Supervisor

SupervisorID

SupervisorName

Duty

DutyID

FloorNo

DutyDate

-----------

HouseKeeperID

WorkStatus

AlternateHID

AlternateWorkSt

------------

Housekeeper

HouseKeeperID

HouseKeeperName

SupervisorID

Supervisor

SupervisorID

SupervisorName

Duty

DutyID

FloorNo

DutyDate

Transaction

DutyID

------------

HouseKeeperID

WorkStatus

AlternateHID

AlternateWorkSt

------------

Housekeeper

HouseKeeperID

HouseKeeperName

Supervisor

SupervisorID

SupervisorName

Duty

DutyID

FloorNo

DutyDate

Transaction

DutyID

HouseKeeperID

WorkStatus

AlternateHID

AlternateWorkSt

作者: yangjie_5211 时间: 2008-11-8 15:05
哥们挺牛，还有时间把题目copy下来……:76)

作者: Le Cash 时间: 2008-11-8 20:14
:87) LZ强人

作者: zhuzhu0618 时间: 2008-11-8 20:15

我也有这道题，我做之前看到这帖了都，居然不知道好好研究一下。cs这部分做得实在是。。。

没看清楚题目问什么。。。:74)

作者: sxajiajia 时间: 2008-11-28 19:01
:67) :67) :67) :67) :67)

作者: jiessiegong 时间: 2008-11-28 19:05
没看懂题目到底是啥意思？？？:76)

作者: sunway83 时间: 2008-11-28 19:07
技术类的~~看不懂的也不用管了

作者: samchen 时间: 2008-11-28 19:08
标题: 回复 1# annmmliu 的帖子
:87) 1111111111111111111111111

作者: wining111 时间: 2008-11-28 19:47
:74) :74) :74) :74) :74)

作者: hjd511 时间: 2008-11-28 22:00
。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。。

作者: 灰菲湮灭 时间: 2009-11-4 22:13
谢谢~~~~~~~~~~~~~~~~~~~~``````

作者: guoshijin007 时间: 2009-11-10 17:41
Thanks~

作者: 天涯若风 时间: 2009-11-10 22:15
xiexiefenxiang~~~

作者: znsan 时间: 2009-11-12 09:18
good person

作者: fxyyxf 时间: 2010-1-4 13:51
什么来的？？？？

作者: sdlcjx 时间: 2010-11-11 11:21
谢谢。。。。。。。。。

作者: sandasanda333 时间: 2010-11-24 19:54
重复性很大~

作者: lserenity 时间: 2012-10-13 00:00
thanks~~

欢迎光临应届生求职招聘论坛 (https://bbs.yingjiesheng.com/)