oracle rec rorkela 2001
hi,
The Aptitude test is same for all comp.Sc. & non Comp.
Sc. . Tech paper
is for only comp.Sc. & MCA. here is oracle tech
paper.
there r 3 sections, all questions r new.section a 16
q's[on OS,Networking,Dbms] ,sec b 7 q's based on c++
programs.last is to a
program in c or c++.
Questions r not in order
section a
=======1. Expression 4+3*(6*12-3) Using Infix to postfix algo
find max no of elements in the stack at any time.
a - 1 b - 2 c - 3 d - 4
2. After 4 steps of sorting result is
2 4 5 8 1 3 6 which sorting is used
ans - it will be a insertion sort but not
selection sort
3. In LRU page replacement find the page fault using 4
frames
1 2 3 4 1 2 5 1 2 3 4 5 [ data not sure ]
ans : 6
4. Using FIFO page replacement find the page fault
using 3 frames
1 2 3 4 1 2 5 1 2 3 4 5 [ data not sure ]
ans: 9
5. Sycronization takes place in which layer of OSI
model
ans : session layer
6. Process burst time
p1 24
p2 3
p3 3
find the av, waiting time in FCFS
ans: 17
7. process arrival time burst time
p1 0 7
p2 2 4
p3 4 1
p4 5 4
find the av, waiting time in SJN
ans:
8. foreign key is
ans : it is the collection of one or more
columns of one table
& primary key of other table
9. Critical region
ans : d
10. Entry
p(empty)
p[mutex]
....
Exit
v[mutex]
v[empty]
two statements of emtry r interchanged , what is
the ......like
this
ans : d
11. what is a SQL cursor
ans :
12. double(*(*(* f( ) )[10] ( ) )
ans : d
13. Move m,c
ans : indirect addressing
14. when a lock is small then which one happens(4
choices)
ans :
15.
section b----------------
Read C++,{ Program segments on the virtual fun,
Nested Class,with
four choices r given, for findinf error or output }
qes r long , we
can't
remember.
1.output of a c program of pointer .
void print(int *a,int*b, int *c,int *d,int *e)
{
printf("%d%d%d%d%d",*a,*b,*c,*d,*e);
}
main()
{
int arr[]={97,98,99,100,101}
int *ptr=*arr+1;
print(++ptr-3,ptr- -,ptr++) type.
}
2. which line has errors.
class outer{
class inner{
int i;
}
};
outer::inner::i=47;
3.a question of overloading functions constructor and
destructor.
4.
section c
---------------
write a prg. in c/c++ to sort a doubly linked list of
integers without
creating a new list.implement add, insert and remove
operations in the
program.
BEST OF LUCK>>>>>>>>i sending u paper of oracle...the
paper that i
recd from durgapur has
only paper for non comp branches ...will send u the
other set as soon
as i get it...
HI ORACLE 2001 (REC DURGAPUR)
there are 2 sets of papers.namely:
*for computer students.
*for other branches(me ,ee,che,civ etc)
for me and other branches only quants has been
asked.there are 30 ques
and time is 30 mins..along with that an essay has to
be written on the topic"E-COMMERCE in INDIA AND ITS
PITFALLS AND POTENTIAL".word limit is 100-150 words.
make sure that you ans the quants ques as soon as
possible so that you have ample time for the essay.
the ques are written in a random manner on the memory
retention basis.the sentence formation may not match
exactly with the ques paper..........................
(1) a team won 10 matches and lost 4 this was the 70%
of the total matches..how many more matches they have
to win in order to win 75% of the matches..
(2) a person A and B have 300$ together..A gives 40$
to B.now A has one fourth of what B has.how much A
has now??
(3)there are three boxes each having two drawers in
it..the first box has 2 gold coins in both the drawers
.the second box has 2 silver coins
in both the drawers,and the third box has one gold and
one silver coin.
what is the probability to get a gold coin randomly
choosing a box?
(4)an island is there having 2 houses and the persons
staying in the two houses are 4 namely
ANAND,RAVI,SOM,VENKAT. you go and ask them knowingthat
there first statement is true and the second statement
is false.
ANAND SAYS"Venkat is my neighbour,,I am his
neighbour."
RAVI SAYS" Anand is not my neighbour,,Anand and som
stays in the same house."
SOM SAYS"Venkat's house is not number 9,,{{donot
remember this statement}}
the ques are on the above statements ((like))
* the house number of the venkat is ________.
* which are the two persons staying together..
and two more......
(6)one tap takes 10 min to fill a tub,, another takes
15 mins to fill..
a leak empties the tank in 7.5 mins..
if all the three are opened simaltaneously then how
much time will it take to fill the tank??
(7) cost of one article is 25$,, there are 50 such
items..second item cost is 30$.. they are 40 in
number..what should be the cost of 30 such items so
that the average cost is 35$??
there are 5 persons in a group A,B,C,D,E.some are
sitarist,some are proff,some are sports person.A and D
are neither a sports person nor a sitarist nor a
proffessor..B is not a proffessor nor a sports
person..
B is the brother of C..E is the husband of the
member,..A and D are unmarried..Women are neither a
sitaristt nor a sports person..
the ques are::
(8) who is the wife of E??
(9)what is the proffession of E??
(10)what is the proffesion of B??
(11) 'A' number of men produce 'C' articles working
'B' hours a day..
if the number of men are reduced by 'D',, then how
much time it would take to produce the same number of
articles??
A group of 5 people has to selected from a group
of7..
R,S,T,U,X,Y,Z..according to the following
specifications..
*if R is selected then T must be selected..
*if S is selected then U must be selected..
*if X and Y are selected then T must not be selected..
the ques on this are::
(12)if X and Y are selected then which person is not
selected..
(13)if U is not selected then which person is not
selected..
one more ques ((not remebering)))
a hara-bhara nursery produces 100 plants daily for
the next 100 weeks..20% of the plants donot survive
more than a week..15% plants donot survive more than 4
week.. if each plant was sold at Rs 35
(14)how many plants were sold in hundred weeks??
(15)what will be the total revenue after 100 weeks??
(16)how many plants were spoiled in 4 weeks??
(17)total revenue in 4 weeks??
(18) in a club 20 % are men.. and rest women.. if 40%
of these men are members and 60% women are the members
of the club then what is the probability that a person
selected at random is a woman??
there was a very big passage arround 500 words.. on
which 6-8 ques were there..this makes around 26 ques
out of 30..
not possible to remember the passage..
NOTE:::::we tried our best to remember all the ques...