甲骨文
1000人以上 | 计算机软件 IT服务/IT解决方案 电子/硬件 | 外资·合资 | 北京 上海 南京 海外
查看全部103条面经 面试经验共103条面经

求职小秘书

共面试1轮 未获得工作

【笔经】ORACLE 第一轮笔试回忆记录下来的真题
oracle 第一轮笔试题目11月8日
这个是我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


 
2009-11-10 17:52:09 0 0
回答或评论0条

登录后,参与评论

评论不能为空

确认删除?

x

你新收到1封甲骨文的职位邀请信