Creativo - the topper's choice

www.creativo.co.in ( Placement papers of all companies are here )

Sunday, April 30, 2006

Philips

Section 1 - Electronics and Mathematics - 20 questions
section 2 - Computer Science
section 3 - Aptitude

Electronics and computer science

1. A circuit was given with lot of flip-flops etc and the operation of that
circuit was asked.
2. 15 software functions are there. It is known that atleast 5 of them are
defective. What is the probability that if three functions are chosen and
tested, no errors are uncovered.
Ans : 10 * 9 * 8
-- -- --
15 14 13

Computer Science
1.Java is
a) Multithreaded b) intrepreter c) compiler d) all of the above
Ans :d
2. The number of nodes in a k-level m-ary binary tree is :

Aptitude
A graph was given and questions regarding shortest path was asked.
For one question shortest path was asked and the answer is none of the
above.
Overall the question paper was easy.

I will try to mail u the entire question paper.

Interview:

HR questions:
1.What is your strengths and weaknesses
2.What are the values u respect
3.Site a reason why philips should hire u
4.What will u do if u are asked to manage a project which will definitely
skip its deadline.

Technical (for me)
1.What is runtime locatable code?
2.What is volatile, register definition in C
3.What is compiler and what its output.






1.6*12*15 is the volume of some material.How many cubes can be inserted into that?
Ans.40

2.Two pipes can fill a tank in 10 1nd 12 hours while third pipe will make the tank
empty in 20 hours.If all three pipes operate simultaneously,in how many hours the
tank will be filled ?
Ans.7hours 30 minutes.

3.Diameter of a beaker is 7cm. Mambler(some instrument)dia is 1.4cm.How many mamblers
has to be put to increase the water level by 5.6cm.


4.Cost of an item is x. It's value increases by p% and decreases by p%Now the new value
is 1 rupee, what is the actual value.
Ans.(1000)/(1000-p*p).

5.A right circular cylinder and a cone are there.Base radius of cone is equal to radius
of cylinder.What is the ratio of height to slant side.


6.Distance between two poles is 50 meters.A train goes by 48 kmph in one minute.How many
poles will be crossed by the train.


7.A pole seen from a certain distance at an angle of 15 degrees and 100 meters ahead by
30 degrees. What is th height of pole.


8.15 people--each has to pay Rs.20.. 20 people--each has to pay Rs.18.. for 40 people--how
much has to pay ?


9.if p=2q then q=r*r,if p-odd then q is even,whether we decide r is even or odd ?
choices:a)first condition is sufficient
b)second condition is sufficient
c)both are sufficient
d)both are not sufficient

10.What is the value of m given that
i) m is devided by 2
ii) m is devided by 5
Ans: none of these


11.If he sells 40 magoes, he will get the selling price of 4 mangoes extra, What is his %
increse in profit ?
Ans: 25%

12.100 glasses are there. A servant has to supply glasses to a person If he supplies the
glasses without any damage he will et 3 paise otherwise he will loose 3 paise.At the
end of supplying 100 glasses if he gets 270 paise, how many glasses were supplied safely.
Ans: 95

*** Some questions on reasoning

Electronics.
------------
1.Fastest logic ..
Ans: ECL

2.202.141.65.62 type of IP address belong to which class.
Ans:class B

3.Mod K ring counter requres how many number of flipflops.
Ans:K

4.ftp is in application layer.

5.Problem related to Ternary operations.
Ans:3

6.Problem related to macro # define square x x*x.
Ans:11

7.Problem related to 5 pointers..refer Page.123 of C
prog.,by Keringan and Ritchie.

8.Ideal op-amp CMRR.
Ans: infinity.

9.13-bit DAC MSB resistance 2kohms.LSB resistance ?
Ans: 2k * 2 to the power of 12.

*** Few question related to C++


***8888*************88 philips99 ********************



IIT- Guwahati.



they r giving the same paper so be thro this

after written test

select guys will go for group dis.

after a formal interview.

( main thing to note dont't tell them u r intersted in

going to states or abroad. u don't say ur GRE score.)

due to this reason 7 guys r not selected.

they taken only 4 guys.







so take care of all the things





section I and section II and sec III

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



questions r not in sequence .................

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





1. forall(roar(x)=> lions(x)) what does it mean ?

ans all lions roar .



2. p<=>q read about this



3. when 2 dice r thrown atleast one of them shows 6 probability is

ans 11/36.



4.2's complement of a 2's complement number is

ans . same no.



5. internatioaal court is at -----------

ans Hague.

6. Meaning of ambasador ?

uca ( u can ans)

7. automata DFA dia is given

ans most probably B. chec



8.criticall section

( uca )

9. No of page faults asked by giving the sequence

2 3 6 7 1 3 4 8 9 10 3 2 4

( just for example I have given this seq .)

thro LRU.

ans 6 ( corect).



10.problem in scheduling RR , a sequence is given just like above

with time slice of 1 and completion period for a process is asked

ans . 11



11.A directory has write permission then a user can create a file.



12.Java is

a. compiled

b. interpreted.

c. OOP

d. mutithreaded.

e. all

ans e.





13. Bubble sort is given ., No of times it executes

ans . n(n-1)/2



14. The appriximate ratio for no of internal nodes to total no

of nodes in k-ary tree of depth n.

ans. 1/k



15. what is fidelity

satya u check



16 what is microprogram.

u check



17. joke :: laugh

ans. cracker : blast



18. question on deadlock



19. How do u remove a ghost in t.v

u check ( clue. ghost means shadow of pictures i.e





20. Queston about a familiy eric, koren, davis etc .

ans . for first one of question. mother



21. If a channel has 2400 bauds what is the data rate it support.



check in data commn book stalins

22. if Band width is w what is data rate

ans 2w

23. A graph is given u have to answer



shotest path a to f ans. none of these



shotest path between a to f ans. 17

shortest path between b to f ans . 16





Electronics and computer science

1. A circuit was given with lot of flip-flops etc and the operation of that
circuit was asked.
2. 15 software functions are there. It is known that atleast 5 of them are
defective. What is the probability that if three functions are chosen and
tested, no errors are uncovered.
Ans : 10 * 9 * 8
-- -- --
15 14 13

Computer Science
1.Java is
a) Multithreaded b) intrepreter c) compiler d) all of the above
Ans :d
2. The number of nodes in a k-level m-ary binary tree is :

Aptitude
A graph was given and questions regarding shortest path was asked.
For one question shortest path was asked and the answer is none of the
above.
Overall the question paper was easy.

I will try to mail u the entire question paper.

Interview:

HR questions:
1.What is your strengths and weaknesses
2.What are the values u respect
3.Site a reason why philips should hire u
4.What will u do if u are asked to manage a project which will definitely
skip its deadline.

Technical (for me)
1.What is runtime locatable code?
2.What is volatile, register definition in C
3.What is compiler and what its output.

Patni

PATNI NEW:-->>99-->>____________
1.what is the angle between teo hands of a clock when time is 8-30ans:75(appro 2.a student is ranked 13th from right and 8th from left.how many are there(similer) 3.a,b,c,d,e,f are arranged in a circle b is to right of c and so on(rsaggrewal) 4.chain rule(work&time) 5.puzzle test.some data is given and he asked three qustions below.based ondata we have to answer. 6.six questions on venn diagrams. 7.5 years ago sum of ages of father and son ans:40,10 8.assertion and reasoning 1.clouds 2.capital city of dweloped corentira ansfor both is :a 9.man walks east & from turns to right & from to left &then 45degrees to right.in which direction he went ans:north west 10.aa-b-bb-aaa- 11.96,85,....(a series with diff 11),3,15,45,....,total 3 questions aregiven on series 12.a student got 70% in one subject,80% in other.to get overall 75% how muchhe should get in third subject. 12.a news pwper must have a.news b.advertizements 3.editor 4.date 5.paper 13.if clouds are air, air are water and so on where birds fly? 14.press,cinema,tv ans:mass media 15.3 qustions on rs aggrewal relations i.e first few chapters of aggrewal(english) 16.a man showed to a woman sitting in a pack & told to his friend.she isthe daughter of my grand mother only son ans:daughter
group disscussion topic 1.if you become muncipal corporater what steps you take to develop yourarea. 2.if you become administrative officer of this university what steps youtake to improve standards. 3.tell what are the seven problems in calcutta and solutions to problems? 4.abortion is legal or illegal the following two topics are omportant they asked the same topics to many students by changing the numbers
5.in 2050 a nuclear disaster has ocurred and 50 persons are saved.which areof age above 15.of them 20 know 6 subjects and you have to choose only 3 ofsix subjects so that resticted resorces can used for future subjects are 1.enggineering 2.medical 3.law 4.social sciences 5.lifesciences 6.---- 6.in space ship 5men are going1.docter,drug asdditive 2.lady lawer has done crime 3.teacher emotinally imbalanced 4.18.18 year old aeruonautical engineer 5. noble lauraut .suddenly something happend and oxygen is avaliable to only three people to use which of three youchoose
interview
here they asked only personal.relating to what you have written insychometric test and some puzzles one puzzle is 10 machines are there only one is defective iteams are comingout how tdo you find out which is defective second: * * * how do you reverse this in two transitions


Section1:
5 questions.. (Mutiple choices)
i.e select any one of the following for 5 questions;;
A) only 1 is sufficentB) only 2 is sufficentC) both nessaryD) both are insufficentE) either is sufficent
1. .......... (Don't know)
2. one composition contains... 5/4 L 6/14 L....
(Ans. both r insufficent)
3. x fabric.... 6.50 per meter , 25% wholesale...
(Ans: both r required)
4 & 5 don't know....
/**************************************/
Section 2 (Analitical...)
1. Average 3years 45,000, 1st 1.5 times, 2nd 2.5 times..
(Calculate in this way... (x+1.5x+2.5x)/3 = 45000 i.e 5x/3 =45000 )then calculate required value...)
2. Three vehecle speed ratio 1:2:3 & time ratio 3:2:1...Distance ratio ??
(Ans: 3:4:3.. check once)
3. some km/hr problem...
(Ans: 150 km/hr)
4 & 5 don't know....
/***********************************/
Section 3 (English - 8 marks.. mutiple choice..)
Don't know...
/******************************/
Section 4 (True or Flase type..)
1. Square contains all angles , one object does not contain angles;
--------------------------------------------------------------------------------
///////////////PATNI NEW OVER at jadavpur 99////////////____________1.what is the angle between teo hands of a clock when time is 8-30ans:75(appro2.a student is ranked 13th from right and 8th from left.how many arethere(similer)3.a,b,c,d,e,f are arranged in a circle b is to right of c and so on(rsaggrewal)4.chain rule(work&time)5.puzzle test.some data is given and he asked three qustions below.based ondatawe have to answer.6.six questions on venn diagrams.7.5 years ago sum of ages of father and son ans:40,108.assertion and reasoning 1.clouds 2.capital city of dweloped corentira ansforboth is :a9.man walks east & from turns to right & from to left &then 45degrees toright.in which direction he went ans:north west10.aa-b-bb-aaa-11.96,85,....(a series with diff 11),3,15,45,....,total 3 questions aregiven onseries12.a student got 70% in one subject,80% in other.to get overall 75% how muchheshould get in third subject.12.a news pwper must have a.news b.advertizements 3.editor 4.date 5.paper13.if clouds are air, air are water and so on where birds fly?14.press,cinema,tv ans:mass media15.3 qustions on rs aggrewal relations i.e first few chapters ofaggrewal(english)16.a man showed to a woman sitting in a pack & told to his friend.she isthedaughter of my grand mother only son ans:daughtergroup disscussion topic1.if you become muncipal corporater what steps you take to develop yourarea.2.if you become administrative officer of this university what steps youtake toimprove standards.3.tell what are the seven problems in calcutta and solutions to problems?4.abortion is legal or illegalthe following two topics are omportant they asked the same topics to manystudents by changing the numbers5.in 2050 a nuclear disaster has ocurred and 50 persons are saved.which areofage above 15.of them 20 know 6 subjects and you have to choose only 3 ofsixsubjects so that resticted resorces can used for futuresubjects are 1.enggineering 2.medical 3.law 4.social sciences 5.lifesciences6.----6.in space ship 5men are going1.docter,drug asdditive 2.lady lawer has donecrime 3.teacher emotinally imbalanced4.18.18 year old aeruonautical engineer 5. noble lauraut .suddenly somethinghappendand oxygen is avaliable to only three people to use which of three youchooseinterviewhere they asked only personal.relating to what you have written insychometrictestand some puzzlesone puzzle is 10 machines are there only one is defective iteams are comingouthow tdo you find out which is defectivesecond: ** * how do you reverse this in two transitions* * ** * * *----------------------------------- two transistors are connected Vbe is 0.7volts .this is simple ckt.onetransistor is diode equivalent. & asked the o/p across the 2 nd transistor.2.simple k map ans is Bbar.3.
Emitter---R-------transistorbase -- ---collectorin above capacitor is connected parallel with resistance r.capacitoris not shown in fig.capacitor is used for in this ckt:
ans:a.speedupb.active bypass c.decoupling4.
-----R------I----------o/p___R____ in above r is resistence.I is cmos inverter.then ckt is used for:
a.schmitt trigger b.latch c.inverter d.amplifier
5.simple amplifier ckt openloop gain of amplifier is 4.V in =1v.asked forV x?amplifdier + is connected to base. - is connected to i/p in between 5k isconnected.from o/p feedback connected to - of amplifier with 15k.this is ckt.
6.resistence inductot cap are serially connected to ac voltage 5volts.voltage acrossinductor is given.R I C values are given & asked forvoltages across resistence & capacitor.7.___ R_____ ---R------OPAMP -------------R1 R1 is for wjhat i mean what is the purpose of R1.
ground
8.asked for Vo at the o/p.it is like simple cmos realization that is n blockis above& p block is below.Vdd is 3 volts at supply.V threshold 5 volts.9.2 d ffs are connected in asyncro manner .clock 10 MEGAHZ.gate delay is 1nanosec.A B are the two given D FFs.asked for AB output is:
a.updownb.up c. updown glitching like that (take care abt glitching word)
10.
---------------- subtractor---------o/p___HPF____
the ckt is LPF ,HPF or APF ?
11.in a queue at the no of elements removed is proportional to no of elementsinthe queue.then no of elements in the queue:a.increases decreases exp or linearly(so these are the 4 options given choose1 option)12.with 2 i/p AND gates u have to form a 8 i/p AND gate.which is the fastestin the following implementations.ans we think ((AB)(CD))((EF)(GH))13.with howmany 2:1 MUX u can for 8:1 MUX.answer is 7.14. there are n states then ffs used are log n.15.cube each side has r units resistance then the resistance across diagonalof cube.16.op amp connections asked for o/pthe answer is (1+1/n)(v2-v1).check it out.practise this type of model.17._____________ supply---__ ___Ii >________ ___ Tranistot> _______VoR Ioground.

asked for Io/Ii=? transistor gain is beta.
a.(1+beta)square b.1+beta c. beta
18.y=kxsquare. this is transfer function of a block with i/p x & o/p y.if i/pissum of a & b then o/p is :--
a. AM b.FM c. PM19.------MULTIPLIER--- _____R____OPAMP______________________Vo---ground.v in = -Ez then o/p Vo =?answer is squareroot of -Ez.multiplier i/ps are a & b then itso/pis a.b;


Section1:>> 5 questions.. (Mutiple choices)>> i.e select any one of the following for 5 questions;;>> A) only 1 is sufficent> B) only 2 is sufficent> C) both nessary> D) both are insufficent> E) either is sufficent>>> 1. .......... (Don't know)>> 2. one composition contains... 5/4 L 6/14 L....>> (Ans. both r insufficent)>> 3. x fabric.... 6.50 per meter , 25% wholesale...>> (Ans: both r required)>> 4 & 5 don't know....>>/**************************************/>>Section 2 (Analitical...)>> 1. Average 3years 45,000, 1st 1.5 times, 2nd 2.5 times..>> (Calculate in this way... (x+1.5x+2.5x)/3 = 45000 i.e 5x/3 =>45000 )> then calculate required value...)>> 2. Three vehecle speed ratio 1:2:3 & time ratio 3:2:1...> Distance ratio ??>> (Ans: 3:4:3.. check once)>> 3. some km/hr problem...>> (Ans: 150 km/hr)>> 4 & 5 don't know....>>/***********************************/>> Section 3 (English - 8 marks.. mutiple choice..)>> Don't know...>>/******************************/>> Section 4 (True or Flase type..)>> 1. Square contains all angles , one object does not contain angles;>> 1.1 True> 1.2 False> 1.3 True


1. An aircraft is flying at a height of 3000m from the ground at an average speed of 400 km/hr while descending.It has to travel 5 kms before it can touch down the runway and start operating its break system.It will take less than 10 seconds to reach the touch down point.How far it is from the touch down point if it had been on thye ground.a)5 kms b)4 kms c)3 kms d)none of these
2. water is continuously poured from a reservoir to a locality at the steady rate of 10,000 litres per hour.When delevery exceeds demand the excess water is stored in a tank.If the demand for 8 consecutive three-hour periods is 10000,10000,45000,25000,40000,15000,60000 and 35000 litres respectively, what will be the minimum capacity required of the water tank(in 1000 litres)to meet the demand?a)10 b)30 c)40 d)50ans:c)40
3. Jhaveri invested in Upendra&Upendra,Celco and Winger shares at Rs. 300,Rs.200 and Rs.5 per share respectively.He bought 100 shares for Rs.1000.The number of Upendra&Upendra and Celco shares he bought are respectivelya)23.17 b)17,23 c)17,60 d)15,25ans:b)17,23
4. a certain organization has three committees.only two persons are members of all committees,but every pair of committees have three members in common.what is the least possible no of member of members on any one committee?a)4 b)5 c)6 d)none of these.ans:a)4
5. one bottle is half-full of oil and another bottle with twice the capacity is one quarter full of oil.if water is added so that both the bottles are full and the contents of both are then poured into athird bottle that is empty and large enough to hold the contents of both,what fractions of the contents in the third bottle is oil?a)1/4 b)1/3 c)3/8 d)2/3ans:b)1/3
6. don and his wife each receive an 8 percent annual raise.if don receives a raise rs.800 and his wife receives a raise of rs. 840, what is the differencer between their annual income after their raises?a)40 b)460 c)500 d)540ans:d)540
7. if x+y+z=9 and both y and z are positive integers greater than zero,then the mzx value x can take is?a.7 b.3 c.8 d.data insufficientans:a.7
8. if 5 tomatoes are worth 8 oranges,5 oranges are worth 4 apples, 7 apples are worth 3 pineapples and 7 pineapples cost rs.203,then the approx price of each tomato isa.16 b.5 c.19 d.none of thesesans: a.16
9. in the relation x>y+z,x+y>p and z

p b.x+y>z c.y+p>x d.insufficient dataans:b.x+y>z
10. if x,y,z are three +ve integers such that x is greater tahn y and y is greater tahn z,then which of the following is definitely true?a.x% of y is greater than y% of zb.y% of x is greater than z% of yc.z% of x is greater than y% of zd.all of these(ans)
11. amar,akbar,antony eat lunch at the same restaurant everyday.if amar orders a dosa,then akbar also orders adosa.either akbar or antony always orders a dosa,but never at the same lunch.either amar or antony or both order a dosa.if antony ordes a dosa ,then amar also orders a dosa.youy can conclude that:a.amar, akbar,antony always order adosa.b.amar and antony sometimes order a dosa,akbar never does.c.amar and akbar always order a dosa,antony never does.(ANS)d.amar and antony always order adosa,akbar never does.
12.ramesh,ram,kareem and mohan collected coins of different countries.they collected 100 together.none collected less than 10.each collected an even number.each collected a different number.based on these,we can say that the number of coins collected by the boy who collected the most could not have exceededa.54 b.64(ans) c.58 d.60
13. let p,q,r and s be four statementssuch that:if p is true, then q is true;if q is true,then r is true andif s is true,then at least one of q and r is false.then it follows that:a. if p is true then s is false.(ans)b. if s is falsae both q and r are true.c. if at least one of q and r is false then s is false.d. if q is true then s is true.
14.players a to z play a league match in which every player plays a match against every other player. a win earns 2 points,a draw 1 point and loss 0 points.there were no draws,and no two players had the same total points.the rank list of the players happens to be the alphabetical list itself.which of the following statement is true?a.n wins over m b.m wins over n(ans)c. m did not play against n d.none
15.an article costing rs.160 is sold at 15% discount on a mark-up price.what is the selling price after discount?a.170(ans) b.200 c.150 d.220
16. if jacob sold a watch costing rs.400 to john at 15% profit and john sold the same to sudhir at 15% profit,what is the price paid by sudhir?a.460 b.510 c.529(ans) d.560
17.in a shop 80% of the articles are sold at a profit of 10% and the remaining at a loss of 40%.what is the overall profit/loss?a.10% profit b.10% loss c.15% profit d.no profit,no loss(ans)
18. if an article with marked price of rs.400 is sold at successive discount of 10%,25% and 15%,what is the price the customer has to pay?a.360 b.300 c.230(ans) d.270
19.the sides of a triangle are in the ratio 3:5:7.if the pereimeter is 60 cms,the longest side isa.7 b.30 c.28(ans) d.14
20. an article with cost price of 180 is sold at 15% profit.what is the selling price?a.198 b.200 c.204 d.207(ans)
21. what part of x*x is power(x,2/3)?a.60% b.66.7% c.69% d.can't say(ans)
22. 15% of 75 is the same as vx% of 450.find x.a.1 b.2.5(ans) c.3 d.5
23. if the selling price of an object is rs.2300 and the profit percent is 15,what is the cost price?a.1995(ans) b.1945 c.2000 d.2645
24.70% of x is greater than 1/3rd of x by 110.what is x?a.100 b.200 c.300 d.350(ans)
25.the age of a and b are in the ratio 4:5 and of b and c in the ratio 3:2.the youngedt of three isa.a b.b c.c(ans) d.can't say
26. a man buys postage stamps of denomination of 30ps. and 50 ps. for rs.10.00. he buys 22 stamps in all. find the no of 30ps. stamps bought by him.a.5(ans) b.6 c.17 d.8
27.the ages of a and b are in the ratio 9:4. after 7 years the ratio of their aghes will be 5:3.find b's present age.a.18 b.8(ans) c.7 d.16
28. if 28 is divided into two parts such that one fourth of the greater part is equal to one third of the lesser part,then the greater part isa.16(ans) b.18 c.20 d.24
29.a man and a woman, walking together start out by boyh taking a step with the left foot.in order to keep together, the man whose stride is longer,takes two steps while the woman takes three.how many steps will the woman have taken they are both about to step out on the right foot for the first time together?
30. for communicating with its satellite,NASA has only two coides is equal to 2 and<= is equal to 3.whenever the two symbols appear together the value is taken as sum of each symbol.for example <=<=*** is equal to 3+3+2+2+2=12.which of the following is equal to <=<=<=** minus <**?a.<=* b.<=** c.<=**** d.<=<=(ans)
31. if i sell two articles, one at 20% profit for rs.100 and the other at 20% loss for rs.100, what is my net profit/loss?a.4.16 profit b.4.16 loss c.8.33 profit d.8.33 loss(ans)
32. if 85% of the population of an ant colony is red, and of these 45% are females,then what % of the total ant population are male red ants?a.46.75(ans) b.40 c.33.66 d.66.66
33. what is the cost price of an article sold at rs.199 after two successive discount of 10% and 15%?a.260(ans) b.200 c.234 d.220
34. if A and B can do a piece of work in 10 days and A alone can do it in 15 days,how long will B take to do it?a.25 b.20 c.15 d.30
35. if 12 men working 2 hours a day take 10 days to complete a job, how long will 8 men working 6 hours a day take to do the same work?a.5(ans) b.8 c.12 d.3
36.a mixture contains spirit and water in the ratio 5:1. another mixture contains spirit and water in the ratio 2:1.what is the ratio in which two mixtures are added to get the mixure in the ratio 5:2a.5:2 b.2:5(ans) c.2:7 d.3:2
37.x:y=7:11, y:z=1:7.what is the least possible integral values of x given that z is 11x.a.3(ans) b.9 c.7 d.10
38. pqrs is a rectangle having area 50. rx=1/4sr.what is the area of pqxs?a.37.5 b.42.5 c.12 d.3
39......
40.what is the area of a circle having the same perimeter as that of a square whose area is 121.ans: 154

the followqing questions are not in order as the original.but the aptitude test is in the same order.
Some of the PL/SQL questions i have remembered are belowThere are 50 questions in 40 minutes. first 25 are multiple and another 25 are true or false.1)A package without body is possible.(T/F)ans:T2)Subprograms have equal scope as variables.(T/F)3)Can a cursor be closed for two times(T/F)ans:F4)Transaction function can be used in trigger(T/F)ans:F5)DDL can be used in trigger(T/F)ans:T6)A trigger name can have the same name as that of its base table name(T/F)ans:T7)In a PL/SQL block a variable and a table name both are same then which will get highest precedence.8)Is PL/SQL reserved words can be used in SQLAns:It can be used with quotation.9)How to write a single quote in SQL i)"" ii)''' iii)''10)Can a labeled go to statement goto the inner loop(T/F)ans:F11)Which are the mandatory parts of PL/SQL procedure.12)SQL%ISOPEN for implicit cursor is always evaluateto false(T/F)ans:T13)Any variable not declared in the declare part assigns value ......14)For cursor %NOTFOUND and for PL/SQL NO_DATA_FOUND(exception)gives the same result.(T/F)ans:T15)If exception occured in the exception then it will i)raise in the same block ii)raise in the outer block iii)not raise in the same block16)PMON command is used for__________17)Select * from emp where emp_no=1; If exist then dbms_output_putline(".....") else dbms_output_putline("error") end if;what will be the output choices are there18)If for Update lock is absent then will there any error in the following statement select * from emp;choices are there.ans is there will no error19)Can a inbuilt exception be redifined by a user(T/F)ans:F20)var table.value%type; var=5; insert into table(value) values(var); for var in reverse 4..6 loop insert into table(value) values(var); end loop; insert into table(value) values(var); i)56545 ii)56544(ans) iii)56555 iv)6544521)can a function overloaded differed by i)the no of parameters and its type onlyii)their return typeiii)iv)22)Raise_application_error is used for..........23)In SQL SGA area the parser tree and exceptions are stored which are used for multiple applications(T/F)ans:F24)PRAGMA_EXCEPTION_INIT(mssge,code no)......25)exceptions are executed at i)compile time ii)runtime(ans)26)When a subprocedure will be declared within a procedure? i)at the end of the declaration ii).......iii)....27)Record1 and record2 are declared.each record has two fields with same datatypes. i)Record1:=Record2; ii)Record1.field1:=Record2.field1;iii)Record1.field2:=Record2.field2;a)only i is legalb)only ii and iii are legalc)all are legald)none is legal28)Trigger syntax declaration without the option for each row is legal(T/F)ans:T29)Tablespace contains physical data(T/F)ans:T30)Rowid is a pseudo column of every oracle table(T/F)31)Lpad and Rpad have default pad character is space(T/F)32)when %ROWCOUNT is 0 what will happen i)NO_DAT_FOUND exception will raise ii)%FOUND will be false


Q. A man leaves office daily at 7pm A driver with car comes from hishome to pick him from office and bring back homeOne day he gets free at 5:30 and instead of waiting for driverhe starts walking towards home.In the way he meets the car and returns home on car He reacheshome 20 minutes earlier than usual.In how much time does the man reach home usually??
Ans. 1hr 20min
Q The following truth table is given What is Y equal to??
A B C Y0 0 0 10 0 1 10 1 0 00 1 1 01 0 0 01 0 1 01 1 0 11 1 1 1
Ans. (A')(B')(AB) , where ' stands for complement.
Q. A works thrice as much as B. If A takes 60 days less than B to doa work then find the number of days it would take to completethe work if both work together?
Ans. 22½days
Q. How many 1's are there in the binary form of 8*1024 + 3*64 + 3
Ans. 4
Q. In a digital circuit which was to implement (A B) + (A)XOR(B), thedesigner implements (A B) (A)XOR(B)What is the probability of error in it ?
Q. A boy has Rs 2. He wins or loses Re 1 at a time If he wins hegets Re 1 and if he loses the game he loses Re 1.He can loose only 5 times. He is out of the game if he earns Rs5.Find the number of ways in which this is possible?
Ans. 16
Q. If there are 1024*1280 pixels on a screen and each pixel can havearound 16 million colorsFind the memory required for this?
Ans. 4MB
Q. On a particular day A and B decide that they would either speakthe truth or will lie.C asks A whether he is speaking truth or lying?He answers and B listens to what he said. C then asks B what Ahas said B says "A says that he is a liar"What is B speaking ?
(a) Truth(b) Lie(c) Truth when A lies(d) Cannot be determined
Ans. (b)
Q. What is the angle between the two hands of a clock when time is8:30
Ans. 75(approx)
Q. A student is ranked 13th from right and 8th from left. How manystudents are there in totality ?
Q. A man walks east and turns right and then from there to his leftand then 45degrees tohis right.In which direction did he go
Ans. North west
Q. A student gets 70% in one subject, 80% in the other. To get anoverall of 75% how much should get in third subject.
Q. A man shows his friend a woman sitting in a park and says that shethe daughter of my grandmother's only son.What is the relation between the two
Ans. Daughter



1. In space ship 5 people are going in a spacecraft to another planetto start a cicilization.These are:
Male docter who is a drug addictLady lawer who has committed murderLady teacher who is emotionally imbalanced18 year old brilliant aeronautical engineerMale Noble prize winnerSuddenly some thing happens and oxygen is avaliable to only threepeople to use. Which three would you choose
Hint :1. You need atleast 1 lady to have future generations.2. Aeruonautical engineer can be a female3. Doctor is necessary to deal with new diseases.
2. In 2050 a nuclear disaster has ocurred and 50 persons are saved.These are of age above 15. Among them these people know 5 subjectsand you have to choose only 3 of five subjects so that restictedresorces can used for future.The subjects are:
EnggineeringMedicineLawSocial SciencesLife Sciences


1. Raju had some amount of money with which he can purchase either 40 oranges or 50 mangoes. While going to market he kept 20% of the money separately for taxy fare. He purchased 20 mangoes for the remaining money he bought oranges. How many oranges did he purchase.2. There 500 ml of acid from which 3 cups was taken and poured in to 500 ml of water. Now from the mixture 3 cups was taken back and poured back in to the container which contained acid.Now (a) Concentration of former is greater than later (b) Concentration of later is greater than former (c) equal (d) indeterminent.3. There is a triange of sides 10,8 and 6. What is the length of a rectangle haviing equal area of the triangle and having breadth 8.4. The sum of reciprocals of two numbers having their difference 5 is 9/14. One among the number is ...7 and 2.5. a, b, c and d are collecting rubbles.1. total number of rubbles with all of them is 100.2. Every one should have a odd number.3. One should have atleat 10 rubble.4. the nunber of rubles with difeerent persons should be differentThe maximum possible number that the person have more rubbles is -----(a) should not exeed 64 (b) should not exceed 60 (c) should not exceed ....6. I purchased 72 chikens some years back. The bill was old and i could only this much _67.9_.At what cost i purchased the chicens...means per unit cost.(it's 5.11)7. A and B income is in the rato 5:3, A,B,C, spend in the ratio 8:5:2, If C's expenditure is Rs 2000 and B saves Rs 7000 what's A savings?? ((1500 check it out))8. A B and C are three tv channels. 85% of people watch A , 75% watch B and 60% watch C. 20 % of the people watch atleast 2 channels . 5% watch no channels. How many watch all the channels?9. How many numbers divisible by 125 can be formed from the five numbers 2,8,3,7,5?10. Some prob on Akbar, Amir and Anthony..about ordering dosas...sorry couldn't exactly reproduce...11. 2 questions was there from the quotient, divident, divider and remainder typenumber x when divided by 739 had a quotient 99 and remainder 738. what's x.one more was there...12. What number must be added to 1/x to make it equal to x.Ans. (x2-1)x13. A thing was sold at loss, for Rs 60.(IMPORTANT::: Not loss of Rs.60, but the selling price was Rs.60). It it would have been sold at price of 81 and the profit would be 20%of the loss. What's the original price of the objectAns. calculate.14. one person start run on 11am. with 4 Km/hr and another man start at 1:30 pm with 1 km/hr in first hr,2 kph in the 2nd hr, 3kmphr at 3 rd hr and so on. at what distance they will meet.??Also at what time they'll meet?15 one disk of 20cm radius, out of that 4 disk of 5cm are cut ,find the ratio of left out area to the cut area...3:116. (X)+(1/X)=3 then (xsquare) + 1/(Ysquare) = ??17. see divisibilty rules.. which no is divided by both 9 and 11??18. only one question of this type p,q,r,s, 4 statments r there , if p is true hen q is true, if qis true then r is true, s is true then at least of q and r should false then what is correct ??19. a box contain 4 small bos, each small box again contain 3 box,again these box contain 2 box . total how many boxes ?20. between 100 to 200 how many no are divisible by both 3 and 2and 100,200 are i1


1.mod(x)+cube(x)=0 1.(0,-1) 2.(0,-1,1) 3.(0,-1,-2) 4.indeterminate ans:(0,-1)2.if a+b+c < ac =" ?">1/2 3.1 4.none of these. ans <1/2.
3.if a man earns Rs20 on first day and spends Rs15 on second day ,and earns Rs20 on third day and spends Rs 15 on fourth day and goes on on which day he will be having Rs 60. ans. 17th day. (similar to sakuntala devi monkey puzzle).4.int a tennis tournment there are 137 players .to decide the winner among them how many matches should be played among them.such that if a player losts the match he is not eligible for the next round. ans.1365.if there is only 1 kg weight with you in how many minimum weighings u would weigh 31 kg.ans 5.6.between 1 and 100 toatl no of numbers divisible by 3 ,9 and 27.7.between 1 and 100 toatl no of numbers divisible by any two of 3 ,9 and 27.8.between 1 and 100 toatl no of numbers divisible by exactly two of 3 ,9 and 27.9.between 1 and 100 toatl no of numbers divisible by all the 3 ,9 and 27.10. if m and n divisible by 5 then which of thw following br not necessarily br true. a.m-n divisible by 5. b.m^2 - n^2 divisible by 25. c.m+n divisible by 5. d.indeterminate ans:- d11.between numbers 10 to 99 how many numbers can be formed with the combinations of 0,1,2,3,4.12. M*n= -1 then m+n=0 if m ,n are consecutive odd numbers.13.if three cubes are numbered with 1 ,2,3 onthere faces then what is the probability of drawing the cubes on after the other cubes with replacement threee times for N=1,2,3.14.the perimeter of an equilateral triangle is 45.if one of the side is the side of an isoceles triangle of perimeter 40 then what is thelenght of base of isoceles triangle. ans:4015 AA is two digit number then m times its cube of AA has 1 in its tens place then what is m.16.the twonumbers (23__)^32 and (12__)^ 33 has 6 in the last digit what is the missing digit.17.once 3000 students went ot amusement park.there are three kinds of trips of Rs 1 each .in which 800 students tokk all the three trips and 1400 students took atleast 2 trips and no student took more than one round. if the amusement park collected a total of Rs7200 then find the total number os students who took no trip.18.The ratio of white balls to black balls is 1:2.If 9 grey balls are added then the ratio of white:black:grey is 2:4:3.Find the number of black balls.ans:1219.15x^2 -ax +60=0 if one root is square of other then find a.20.82*83*84*....89 what is the digit in units place. ans 0.21.if A and B run on a circular path in opposite directions of constant speeds with different velocities from P and Q. First time they meet 800 mts away from P and second time they meet 700 mts away from P, what is the lenght of the circular path.22.venn diagram on English French and Germany.23.Venn diagram on news papers.24.if a,b,c,d,e are in group discussion with following group rules what is the probability of a talking before b.


Section1: 5 questions.. (Mutiple choices) i.e select any one of the following for 5 questions;; A) only 1 is sufficent B) only 2 is sufficent C) both nessary D) both are insufficent E) either is sufficent 1. .......... (Don't know) 2. one composition contains... 5/4 L 6/14 L.... (Ans. both r insufficent) 3. x fabric.... 6.50 per meter , 25% wholesale... (Ans: both r required) 4 & 5 don't know....
Section 2 (Analitical...) 1. Average 3years 45,000, 1st 1.5 times, 2nd 2.5 times.. (Calculate in this way... (x+1.5x+2.5x)/3 = 45000 i.e 5x/3 =45000 ) then calculate required value...)
2. Three vehecle speed ratio 1:2:3 & time ratio 3:2:1... Distance ratio ?? (Ans: 3:4:3.. check once)
3. some km/hr problem... (Ans: 150 km/hr) 4 & 5 don't know....


1. 10^23-7 is divided by 6, remainder is? (ans 3)
2. if x+y+z =1. then xy+yz+zx is (ans-a)
a)<1/2
b)>1/2
c)=1/2
3. 5 questions based on venn diag Check from R S Agarwala. Like
Some people eat mangoes and apples, some eat only apples.....
then
how many eat only....
10. Spped of river and boat given and ........
11. Find circumference of circle, 2 people start at one point
and
reach a pt whose dist is given. Then again from there they start
and agian reach a pt whose dist is given .
12.nos from 1 to 100.
a)find all the nos which r divisble by 3,9,27
b)at least 2
c) only 2
d) none
13. 3 balls inside a bag having nos on it written 1, 2, 3 on it.
fa ball is taken and then put inside it. Find probability that
all
3 nos r the same when it is taken 3 times
14.2 consequtive odd nos..multi is -1 find out sum ..
ans:0
15. few days ago lady celebrated her 36th birthday.....
ans:even no

--------------------------------------------------------------------------------
1)sqrt of (pq)=8,then ans--p+q =1 is not possible
2)qulateral triangle of 10 units.cow is tethteded with a rope of
7
units at one of the vertices.area covered is ---77/3
3)sum of 50 terms of series 2+3-5+2+3-5........... ans --5
4)a no is abc.sum of factorial of the three digits is the no
itself.then b==?;a>0 ans---2
5)when x is divisible my 299 reminder is 100.then x/23 leaves
reminmder ? ans---8
6)2 groups a&b; a guy jumps from gp A to gp B and both the
average
wts of groups increases.then avg wt of gp A>that guy>av wt of
gp
B.
7)relation: (7^2^3).>(7^2)^3
8)train speed 36kmph.dis travelled in 3 mts==1800mts.
9)no of all possible 6 digit nos using 1,2,3,4,5,6. which r not
divisible by 5 ans--600
10)x=1.5,2.5,2,... y= 9,25,.... relation btwen two.
ans---
y proportional to square of x.
11)20 kgs of fresh grape contain 90% water.dry grape 20% water.
20kgs of fresh grape == ans---2.5 kgs of dry grape.
12)least volume . given four ans ---- cuboid
13)question on akbar,amar,antony ans-----antony
14)population is 20000.10% inc for every year.pop after 3
years......26620.
15)dis bt 2 points. a&b is given.a starts at 9 and b at 10 with
twice speed of a.both cover 1/4 distance in i hr.how much time
it
will take for a to cover entire distance....ans ---8hrs.
16)each soldier has 2 horses.....ans ---indeterminent.
17)entry fee is rs. 1. 3000 went to park. each ride rs . 1.....
800 all three.1400 atleast two rides.total collected 7200.
no of people -no ride ans ---- 1000
18)a,b,c, do work in 12,20...... ans---- 8 days.
19)m div by 5, n div by 5. then which is wrong ans-- m+n div
by
10.
20)1771+1773+1775+1777... .reminder when divisible by 6
is.(1+3+...) ans is 7.
21)cube of side 5 painted in blue on all its faces.cut into i
unit
cubes.probability that 2 sides painted is ... 36/125
22)a>0;b<0.>0.
23)a 25%> than b.b 20%24)a cone and sphere has same radius.if sphere is kept in cone
then the part goes in cone is ans--- less than half.
25)marks got in 5 papers is 6:7:8:9:10.total obtained is 60%.
50%
is pass. then no of sub he passed is ans--4
26)wich is not correct... a)cube of 343 b) etc ........
ans--- none of these.
27)15c6+15c7+16c8=== 17cx then x== 8 or 9. n c r + n c r-1 =
n+1 c r. and n c r === n c s if and only if r=s or r +s =n;
28)three men invested sum. and their ratio is 5:7:6. profit is
5400.then b's share ans--2100
29)sum of all 5 digit nos formed using 1,3,5,7,9. ans---6666600
(11111+33333+55555+77777+99999)*24. each digit occupies all the
places for 24 times.
30)x and y even nos. x>y which is even. a)x+y b)x-y c) 2x/y
(not)
31)1/2 divived by 1/2 of 1/2 ) whole divided by 1/2 +1/2 of
1/2
ans----- 2 2/3. or 8/3.
32) trees of heights 30 and 40 sepatated by a river. fish in
the
river is at equal dis from top of the trees where two boirds r
there.
ratio of the distances from fish to the root of the tress
ans---
4:3.
33)which one of the following will have least volume
a)cube b)cuboid c)sphere d)cylinder
(the dimensions of each are given) ans-----cuboid with
l=2,b=5,h=10
34)three cones (r=r,l=2r)are arranged upright so that each
cone
is in contact with other two .and a circle is formed passing
through its vertices.
what will be its radius.






1. What number must be added to 1/x to make it equal to x.
Ans. (x2-1)x
2. Some pers bought something at loss for Rs 60.He then sold it
the price of 81 and his profit was 20%
of the loss.At what price did he buy the object.
Ans. calculate.
3. age problems easy
father age, elder son age and yonger son age releation given u
have to tell father age?
4. Km/hr and time distance problems
one person start run on 11am. with 4 Km/hr and another man
start
at 1:30 pm with 1 km/hr in first hr,2 kph in the 2nd hr and so
on. at what distance they will meet.??
4)one disk of 20cm radius, out of that 4 disk of 5cm are cut ,
find diffrence of leftout and cut out area:
5) (X)+(1/X)=3 then (xsquare) + 1/(Ysquare) = ??
6)see divisibilty rules??
which no is divided by both 9 and 11??
7)only one question of this type
p,q,r,s, 4 statments r there , if p is true hen q is true, if q
is true then r is true, s is true then at least of q and r
should
false then what is correct ??/
8)a box contain 4 small bos, each small box again contain 3 box,
again these box contain 2 box . total how many boxes ?
9) between 100 to 200 how many no are divisible by both 3 and 2
and 100,200 are i1. If x+y+z=0 then the value xy+yz+zx= i)<1/2,>1/2, iii)=1/2, iv)none of these.
2. How many two digit no you make by 1,2,3,4,0 Ans=16 because 0 is not in the 10th place.
3. 1-100, how many number cannot divide by any of 3,9,27
4. How many number divide by any of 3,9,27
5. How many number divide by only any of 2
6. How many number divide by any 1
7. Other one Q related it. I forget it.
8. (25...) 32 and (25....)31 in both cases 6 in the last position. What should be in the blanks? Ans 6 as 6*6=36, 6*6*6=216
9. In a GD there is no restriction in saying something between the participants. A, B, C, D, E be the participant. What's is probability to say B before A. i) 20%, ii) 40%, iii) 50%, iv) none of these. Ans. 50%.
10. You have only 1 kg weight. You have to weight 31kg. Min number of measurements you have to done. Ans. 5 as 1+2+4+8+16=31.
11. Min (a, b, c)=min of a, b, c Max (a, b, c,)=max of a, b, c then what is the value of MAX {min (2,5,7), max (-7, -2, -3), 3} thus.
12. The product of two consecutive odd no is -1, then what is the value of the sum of them. Ans. 0 as -1*1 becomes -1.
13. 5 or 6 easy Vane Diagrams
19. In a box there's 3 cubes numbered 1,2,3. What is the probability to pick up any one ball all the three time by replacing it to others? Ans. =1/3*1/3*1/3=1/27
20. Few years ago on 31st January on her 26th birthday a lady laid a baby. Now what's the sum of their ages? i) 37, ii) 38, iii) 43, iv) 51. I am confused about the answer. It may be any even no. as (26+x)+x. So I think it are 38.
25. 81*82*83*84*85*86*87*89. What should be in the unit place in this product? Ans. It must be 0 as 5*2=10
26. What is the value of p in the equation (15X2-pX+120)=0 if the one root of is must be the double of the other. Ans. May be 90 as the roots are 30,60.
27. Two trains P Q starts from A and B respectively towards each other. After 1 hour of starting of P Q starts and after sometime both of them covered the 1/4th of the total distance of AB. In how many times Q cover the total distance. I forget the Question. But the ans. May be 8.
28. In a company ones salary increases 6/5 times in every year. After 4 year of joining average salary is 1342. Then what's the starting salary of the company? A) 900, b) 1000, c) 1100, d) 1200. Ans.= 1000
29. Perimeter of an equilateral and isosceles is 45 and 40 respectively. At least one of the sides of isosceles is equal to the equilateral. What's the base of isosceles triangle? Ans. 10. As. 45/3=15. 15+15+10=40.
30. 3000 students went to visit to a park. The entry fee re.1. There are three rides................................ Profit of authority is Rs. 7200... Ans. 1000.
31. Two people P Q start a race in a circular track in opposite way different but constant speed. First they meet 900m cw from the starting pt. Then they meet 800m ccw from the starting pt. What's the circumference of the circle.nclusive?
GD topics in j.u.:
Arrange marriage and love marriage
Terrorism
Coco cola & pepsi recent prob
Advantage & dis advantages of campus interview
social crime


1.what is the angle between teo hands of a clock when time is 8-30ans:75(appro)2.a student is ranked 13th from right and 8th from left.how many are there(similer)3.a,b,c,d,e,f are arranged in a circle b is to right of c and so on(rs aggrewal)4.chain rule(work&time)5.puzzle test.some data is given and he asked three qustions below.based on datawe have to answer.6.six questions on venn diagrams.7.5 years ago sum of ages of father and son ans:40,108.assertion and reasoning 1.clouds 2.capital city of dweloped corentira ans for both is :a9.man walks east & from turns to right & from to left &then 45degrees toright.in which direction he went ans:north west10.aa-b-bb-aaa-11.96,85,....(a series with diff11),3,15,45,....,total 3 questions are given on series12.a student got 70% in one subject,80% in other.to get overall 75% how muchhe should get in third subject.12.a news pwper must have a.news b.advertizements 3.editor 4.date 5.paper13.if clouds are air, air are water and so on where birds fly?14.press,cinema,tv ans:mass media15.3 qustions on rs aggrewal relations i.e first few chapters of aggrewal(english)16.a man showed to a woman sitting in a pack & told to his friend.she isthe daughter of my grand mother only son ans:daughter
group disscussion topic1.if you become muncipal corporater what steps you take to develop yourarea.2.if you become administrative officer of this university what steps youtake toimprove standards.3.tell what are the seven problems in calcutta and solutions to problems?4.abortion is legal or illegalthe following two topics are omportant they asked the same topics to manystudents by changing the numbers
5.in 2050 a nuclear disaster has ocurred and 50 persons are saved.which areofage above 15.of them 20 know 6 subjects and you have to choose only 3 ofsixsubjects so that resticted resorces can used for futuresubjects are 1.enggineering 2.medical 3.law 4.social sciences 5.lifesciences6.----6.in space ship 5men are going1.docter,drug asdditive 2.lady lawer has donecrime 3.teacher emotinally imbalanced4.18.18 year old aeruonautical engineer 5. noble lauraut .suddenly somethinghappendand oxygen is avaliable to only three people to use which of three youchoose
interview
here they asked only personal.relating to what you have written insychometrictestand some puzzlesone puzzle is 10 machines are there only one is defective iteams are comingouthow tdo you find out which is defectivesecond: ** * how do you reverse this in two transitions* * ** * * *
PCS, Regional Institute of Technology > Jamshedpur.16th July.2k1 > **************************************************************** > > 1. Number of Weights needed for weighing 1 to 40 kgs? > 27 9 3 1 ans : 4 > 2. Venn diagram problem venndiagram find the > formulae. > Ans. (AB+BC+CA)(A'+B'+C') > 3. a+2b=6,ab=4 2/a + 1/b=? > ans : 3/2 > 4. age of 4 persons given in a relation find smallest age? > ans : meera > 5. find floating point result > (float)25/2, float(25/2), 25/(float)2 ,25/2 > ans: 1 & 3 > > 6. find equivalent *(*(s+x)+y) ==> s[x][y] > ans : content of s[x][y] > > 7. find invalid statement : int a[3] > 1. scanf("%d",a[2]); > 2. scanf("%d",&a[2]); > 3. scanf("%d",a); > 4. all > > ans : 1 > > 8.one palindrome programme was given in recursion > ans : pal(f++,t--) > > 9. main program: > i=foo(2) foo(int s) > { > if(!s) > return s; > else > { int i=5; return i} > } > ans : 5 > > 10.Ans. > ordere of sequence fetch, decode,read > data,execute,stroe > > 11. > k=0 i=0j=1; > if(i0)&&(k=2) printf(k); > if(i0 k=0) > printf(k) > > ans: 2 2 > > > 12.cube is moulded as a sphere. find the ratio of > cube of surface area of sphere to squareof surface area of cube. ans pi/6 > > 13. teacher in math=4 p6=3 kmistry=3 each can take 2 > subject minimum teacher needed for school > ans : 5 > > 14. 3 vowels,4 consonents formulate string of 6 > letters with a vowel in a string max no of string ? > ans: 5040 > > 15.binnary of .6875. > 0.1011 > > 16. man walks at speed of 8 km/h 300 mtrs length train crosses man in 30 > sec from back, find speed of train > ans: 44 km/hr > > 17. chess corner > ans : 30 > > 18 > input : " this is a line." > > main() > { > char ch; > int count=0; > while((ch = getch() != '\n') > { > while (ch == ' ') > ch = getch(); > while((ch!=' ') && (ch!='.')) > { > count++; > ch=getch(); > } > } > > ans : 11 > > 19. radius of a circle is 5cm , if we draw a > rectangle of maximum size, > what is the area of rectangle > ans : 50 cmsq > > 20. > main() > { > int i; > for(i=0;i<3;i++)> switch(i) > { > case 1: printf("%d",i); > case 2 : printf("%d",i); > default: printf("%d"i); > } > } > ans 011122 > > Short listed have to appear for GD which includes > filteration. GD : > > 1. Report to the commisioner about the Corporation > Probs, > > 2. 5 things that u will consider while starting a > company, > > 3. there is a ship u r given five persons and u have > to send only three > whom > will u send and why (Doctor, Engineer, lawer etc.), > > 4. what are the qulification required to have a high > standards. > > 5.men are from mars and women are from venus. > > 6.what are the necessary steps should the senior > management should > take when the company has just launched and going to > produce a software > product. > at M.S. university > 7. Should politician poses a minimum qulification. > 8. Should India bid for organizing Olympic games. > >
This is the latest patni paper(campus recritment) Basically there is a 1.apti(general+tech) 2.gd 3.pschyometric test 4.interview(tech+personal)
the apti consist of 20 questions time 50 min
5.there is a circle of radius 5.what is the area of the biggest rectangle that can be cut out of this circle 6.in a chess board 2 squares are cut out leaving 61 squares if we place blocks each of length=lengthof 2 squares and width=width of 1 square how many blocks will be necessary 9.radius =3 of a sphere it is melted to form a cube.what is the ratio of the cube of the volume of the sphere to the cube of the volume of the cube
///////////////PATNI NEW OVER at jadavpur 99////////////
this is pcs pune paper.
1. Men in the order type - Eswar Rao2. Optional3. Latter4. Cease
5. There r 3 boys 7 4 girls; Howmany ways they r arrangedsuch that boys should be always together ???
(Ans: 240
6. If n.....; What is the max no that divides
(Ans: 8)
7. A,B,C,D has values from 0 to 9.... What is D ?
(Ans: 6)
8. A wodden piece taken which is in shape of Triangle ,of 10 X 24 X 26 ; Then cut at some ..... which is rearrangedin rectangle format; so what is ...
(Ans: 5)
9. There r 5 numbers. The average is 25; the highest valueexcluded then average is 25, if the lowest is excluded the avg is ..Then average of remaining is ?
(Ans: 30)
10. The square is cut such that the end point of one side isshown in fig.. This is repeated two times, what is the area ??
(Ans: 3.61)
11. The route problem... what is the shortest rout to p1 to p2...(There may be circle figure......)
(Ans: From p1 to 0 & form 0 to p8)
12. Two motor cycles A & B are started from one point at4 Kmph & 6 Kmph; After 45 min B starts returning , at whattime they will reach....
(Ans: 3.6 km)
13. All integer from 0 to 9, what is the smallest no perfectly devides;
(Ans: c)
14. Some figure (Triangle in a rectangle)..... What is perimeter if triangle
(Ans: 20)

***************************************************************> In PCS the recruitment process is > 1-Aptitude Test 50 min 20 que. I am sending> questions.> Don't attempt all questions (ONly 14 to 18) .they> have uppercutoff. > 160 appear ,108 shortlisted for 2nd set,in which 9> from MCA.> 2 -Language test (English). 25 questions 15 min.> A sentence is divided into a,b,c,d,e part. You have> to find Error.> 3- Group Discussion> In GD ,it was given six streams and u have to> select one and why?> 1- Medical> 2- Engineering> 3- social science> 4- Life science> 5 - Management> 6- Law> 4-Interview.>*****************************************************************> PCS, Regional Institute of Technology> Jamshedpur.16th July.2k1>****************************************************************> > 1. Number of Weights needed for weighing 1 to 40 kgs?> 27 9 3 1 ans : 4> 2. Venn diagram problem venndiagram find the> formulae.> Ans. (AB+BC+CA)(A'+B'+C')> 3. a+2b=6,ab=4 2/a + 1/b=? > ans : 3/2> 4. age of 4 persons given in a relation find smallest age? > ans : meera> 5. find floating point result> (float)25/2, float(25/2), 25/(float)2 ,25/2 > ans: 1 & 3> > 6. find equivalent *(*(s+x)+y) ==> s[x][y] > ans : content of s[x][y]> > 7. find invalid statement : int a[3]> 1. scanf("%d",a[2]);> 2. scanf("%d",&a[2]);> 3. scanf("%d",a);> 4. all> > ans : 1> > 8.one palindrome programme was given in recursion> ans : pal(f++,t--)> > 9. main program:> i=foo(2) foo(int s)> {> if(!s) > return s;> else> { int i=5; return i}> }> ans : 5> > 10.Ans.> ordere of sequence fetch, decode,read> data,execute,stroe > > 11.> k=0 i=0j=1;> if(i0)&&(k=2) printf(k);> if(i0 k=0)> printf(k)> > ans: 2 2> > > 12.cube is moulded as a sphere. find the ratio of> cube of surface area of sphere to squareof surface area of cube. ans pi/6> > 13. teacher in math=4 p6=3 kmistry=3 each can take 2 subject minimum> teacher needed for school> ans : 5> > 14. 3 vowels,4 consonents formulate string of 6 letters with a vowel in> a string max no of string ?> ans: 5040> > 15.binnary of .6875.> 0.1011> > 16. man walks at speed of 8 km/h 300 mtrs length train crosses man in 30> sec from back, find speed of train ans: 44 km/hr> > 17. chess corner> ans : 30> > 18> input : " this is a line."> > main()> {> char ch;> int count=0;> while((ch = getch() != '\n')> {> while (ch == ' ')> ch = getch();> while((ch!=' ') && (ch!='.'))> {> count++;> ch=getch();> } > }> > ans : 11> > 19. radius of a circle is 5cm , if we draw a> rectangle of maximum size,> what is the area of rectangle > ans : 50 cmsq> > 20.> main()> {> int i;> for(i=0;i<3;i++)> switch(i)> {> case 1: printf("%d",i);> case 2 : printf("%d",i);> default: printf("%d"i);> }> }> ans 011122 > > Short listed have to appear for GD which includes> filteration. GD : > > 1. Report to the commisioner about the Corporation> Probs, > > 2. 5 things that u will consider while starting a> company, > > 3. there is a ship u r given five persons and u have> to send only three> whom> will u send and why (Doctor, Engineer, lawer etc.),> > 4. what are the qulification required to have a high> standards.> > 5.men are from mars and women are from venus.> > 6.what are the necessary steps should the senior> management should> take when the company has just launched and going to> produce a software> product.> at M.S. university> 7. Should politician poses a minimum qulification.> 8. Should India bid for organizing Olympic games.
PCS PAPER (PATNI)

> 4. #include > /* This problem is given in PCS BOMBAY walk-in-interview.> * What is the final value of i and how many times loop is> * Executed ?> */> > main()> > {> int i,j,k,l,lc=0;> /* the input is given as 1234 567 */> printf("Enter the number string:<1234>\n");> scanf("%2d%d%1d",&i,&j,&k);> for(;k;k--,i++)> for(l=0;l> printf("%d %d\n",i,l);}> printf("LOOPS= %d\n", lc-1);> }> /* Ans: i = 17, and loop is executed for 169 times */> ~
> 10.#include > main()> {> func(1);> }> func(int i){> static char *str[] ={ "One","Two","Three","Four"};> printf("%s\n",str[i++]);> return;> }> /* Ans:- it will give warning because str is pointer to the char but> it is initialized with more values> if it is not considered then the answer is Two */
> 11. > #include > main()> {> int i;> for (i=1;i<100;> printf("%d %0x\n",i,i);> }> /* Ans:- i is from 1 to 99 for the first format,> for the second format 1to9, ato f, 10 to 19,1ato1f, 20 to 29, etc */>
> 13.#include > /* This problem was asked in PCS Bombay in a walk-in-interview> * Write a recursive function that calculates> * n * (n-1) * (n-2) * ....... 2 * 1> */> > main() {> int factorial(int n);> int i,ans;> printf("\n Enter a Number:");> scanf("%d",&i);> ans = factorial(i);> printf("\nFactorial by recursion = %d\n", ans);> }> int factorial(int n)> {> if (n <= 1) return (1);> else> return ( n * factorial(n-1));> }> > 14.#include > /* This problem is asked in PCS Bombay walk-in-interview> * What is the output of the following problem> */> main(){> int j,ans;> j = 4;> ans = count(4);> printf("%d\n",ans);> }> int count(int i)> {> if ( i <> else> return( count(i-2) + count(i-1));> }> > /* It is showing -18 as an answer */> > > 4. #include > /* This problem is given in PCS BOMBAY walk-in-interview.> * What is the final value of i and how many times loop is> * Executed ?> */> > main()> > {> int i,j,k,l,lc=0;> /* the input is given as 1234 567 */> printf("Enter the number string:<1234>\n");> scanf("%2d%d%1d",&i,&j,&k);> for(;k;k--,i++)> for(l=0;l> printf("%d %d\n",i,l);}> printf("LOOPS= %d\n", lc-1);> }> /* Ans: i = 16, and loop is executed for 169 times */> > This is pcs pune.================
1. Men in the order type - Eswar Rao2.. Optional3. Latter4. Cease> > 5. There r 3 boys 7 4 girls; Howmany ways they r arranged > such that boys should be always together ???> > (Ans: 240> > 8. A wodden piece taken which is in shape of Triangle ,> of 10 X 24 X 26 ; Then cut at some ..... which is rearranged > in rectangle format; so what is ...> > (Ans: 5)> > 9. There r 5 numbers. The average is 25; the highest value > excluded then average is 25, if the lowest is excluded the avg is ..> Then average of remaining is ?> > (Ans: 30)> > 10. The square is cut such that the end point of one side is > shown in fig.. This is repeated two times, what is the area ??> > (Ans: 3.61)> > 11. The route problem... what is the shortest rout to p1 to p2...> (There may be circle figure......)> > (Ans: From p1 to 0 & form 0 to p8)> > 12. Two motor cycles A & B are started from one point at 4 Kmph & 6 Kmph; After 45 min B starts returning , at what time they will reach....(Ans: 3.6 km)
13. All integer from 0 to 9, what is the smallest no perfectly devides;(Ans: c)

1. square root of(PQ)=8 then 4 options Ans:p+q =1: is not possible
2. equilateral triangle of side 10 units. cow is teethered with a rope of length 7 units at one of the vertex. Find the area of the field grazed. ans-77/3
3.Series till 50 terms: 2+3-5 +2+3-5+.... ans:5
5.when x is diveded by 299 remainder is 100. then when x is divided by 23 remainder is ? ans:8
6. there r 2 groups A and B. A boy goes from gp A to gp B. When he goes the ave wt of both the gps A and B increases. Then? ans:ave wt of gp A>wt of boy is>ave wt of gp B
7. (7^2)^3 and 7^2^3. What is the relation between the 2 . ie >,<,= ans- (7^2)^3<7^2^3.
8.Train speed 36kph. Dist travelled in 3minutes in meters ans-1800m
9. with the digits 1,2,3,4,5,6 make all 6 digit nos which r not divisible by 5. The no of such 6 digit nos is ans:600
10. x 2.5 3.5 1.5 y25 49 9 then what is the relation between x and y ans:y is directly proportional to (2x)^2
11.18kg of fresh grapes have 90% water. dry grapes have 20% water. then the weight of the dry grapes is ans:2.25kg
14.population is 20000. Pop increases by 10% every year, then the pop after 3 years is? ans-26620
15.Dist bet 2 places A and B is given. A man P starts from place A at 9 pm and another man Q goes from B at 10pm . Speed of Q is double of that of P. Both cover 1/4 dist in the same time interval. then A travels the entire dist in time ? ans:8hrs
17.Entry fee is Re1. There r 3 rides each is of Re1. Total boys entering is 3000. Total income is Rs 7200. 800 students do all the 3 rides. 1400 go for atleast 2 rides. None go the same ride twice. Then no of students who do not go any ride is ans:1400 (check-1000)
19. 1,23,45,67... ans:-89
20. m is div by 5, n is div by 5 m-n is div by 5 m*n is div by 25 ans:then m+n is not div by 10
22.Cube of side 5 cms is fully painted in alll the 6 sides. it is then cut into cubes each of side 1 cms. then prob that 2 sides r painted is ans:36/125
24.A is 25% bigger than B B is 20% less than C then the relation bet A, B, C ans 5:4:5
25.A cone and a sphere have the same radius. and in the cone we put the sphere then how much of sphere will be inside the cone a)1/2 b)>1/2 c)<1/2 ans d)1/4
26. there r 5 papers Ratio of marks obtained in each subject is 6:7:8:9:10. Total marks obtained is 60%. 50% is pass marks. In how many subjects did he get above 50%. ans:4
27. which one is not correct a)cube rootof 343. b)3.24 is not an integer Ans:none of these
28.A and B r 2 men who enter into business and they invest Rs 1000, Rs 2000resp. How will they divide the income of Rs 5000 .ans 5000/3 & 5000(2/3)
29. 9C2 + 9C3 +10C4=? ans 11c4
1. 10^23-7 is divided by 6, remainder is? ans-3
2. if x+y+z =1. then xy+yz+zx is a)<1/2>1/2 c)=1/2
12.nos from 1 to 100. a)find all the nos which r divisble by 3,9,27 --33b)at least 2 --11c) only 2 --8d) none --67
13. 3 balls inside a bag having nos on it written 1 , 2, 3 on it. a ball is taken and then put inside it. Find probability that all 3 nos r the same when it is taken 3 times ans-1/27
27)15c6+15c7+16c8=== 17cx ans- x== 8 or 9.
28)three men invested sum. and their ratio is 5:7:6. profit is5400.then b's share ans--2100
29)sum of all 5 digit nos formed using 1,3,5,7,9. ans---6666600(11111+33333+55555+77777+99999)*24. each digit occupies all theplaces for 24 times.
30)x and y even nos. x>y which is even. a)x+y b)x-y c) 2x/y (not)
31)1/2 divived by 1/2 of 1/2 ) whole divided by 1/2 +1/2 of 1/2ans----- 2 2/3. or 8/3.
32) trees of heights 30 and 40 sepatated by a river. fish in the river is at equal dis from top of the trees where two birds rthere.ratio of the distances from fish to the root of the tress ans---4:3.
34)three cones (r=r,l=2r)are arranged upright so that each coneis in contact with other two .and a circle is formed passingthrough its vertices. what will be its radius. ans 2r/sqrt(3)
1. What number must be added to 1/x to make it equal to x. Ans. (x2-1)x
2. Some pen bought something at loss for Rs 60.He then sold it the price of 81 and his profit was 20% of the loss.At what price did he buy the object. Ans. calculate. ans-77.50
6.one disk of 20cm radius, out of that 4 disk of 5cm are cut ,find diffrence of leftout and cut out area:ans-200pi
7.(X)+(1/x)=3 then (xsquare) + 1/(xsquare) = ??ANS-7
10.a box contain 4 small bos, each small box again contain 3 box,again these box contain 2 box . total how many boxes ANS-1+4+12+24=41
11. between 100 to 200 how many no are divisible by both 3 and 2and 100,200 are inclusive? ans-68
12. How many two digit no you make by 1,2,3,4,0 Ans=16 because 0 is not in the 10th place.
18. (25...) 32 and (25....)31 in both cases 6 in the last position. Whatshould be in the blanks? Ans 6
19. In a GD there is no restriction in saying something between theparticipants. A, B, C, D, E be the participant. What's is probability to say Bbefore A. i) 20%, ii) 40%, iii) 50%, iv) none of these. Ans. 50%.
20. You have only 1 kg weight. You have to weight 31kg. Min number ofmeasurements you have to done. Ans. 5 as 1+2+4+8+16=31.
21. Min (a, b, c)=min of a, b, c Max (a, b, c,)=max of a, b, c then what isthe value of MAX {min (2,5,7), max (-7, -2, -3), 3}. ans-3
22. The product of two consecutive odd no is -1, then what is the value of thesum of them. Ans. 0 as -1*1 becomes -1.
23. Few years ago on 31st January on her 26th birthday a lady laid a baby. Nowwhat's the sum of their ages? i) 37, ii) 38, iii) 43, iv) 51. I am confusedabout the answer. It may be any even no. as (26+x)+x. So I think it are 38.
25. 81*82*83*84*85*86*87*89. What should be in the unit place in this product?Ans. It must be 0 as 5*2=10
26. In a company ones salary increases 6/5 times in every year. After 4 yearof joining average salary is 1342. Then what's the starting salary of thecompany? A) 900, b) 1000, c) 1100, d) 1200. Ans.= 1000
27. Perimeter of an equilateral and isosceles is 45 and 40 respectively. Atleast one of the sides of isosceles is equal to the equilateral. What's thebase of isosceles triangle? Ans. 10. As. 45/3=15. 15+15+10=40.
28. Two people P Q start a race in a circular track in opposite way differentbut constant speed. First they meet 900m cw from the starting pt. Then theymeet 800m ccw from the starting pt. What's the circumference of the circle.ans-2600m
1.what is the angle between teo hands of a clock when time is 8-30ans:75deg
2.a student is ranked 13th from right and 8th from left.how many arethere(similer)-ans-20
9.man walks east & from turns to right & from to left &then 45degreestoright.in which direction he went ans:south east
12.a student got 70% in one subject,80% in other.to get overall 75%how muchheshould get in third subject.ans-75%
12.a news paper must have a.news b.advertizements 3.editor 4.date5.paper
13.if clouds are air, air are water and so on where birds fly?ans-water
16.a man showed to a woman sitting in a pack & told to his friend.sheisthedaughter of my grand mother only son ans:sister
1. Average 3years 45,000, 1st 1.5 times, 2nd 2.5 times..>> (Calculate in this way... (x+1.5x+2.5x)/3 = 45000 i.e 5x/3 =>45000 )
2. Three vehecle speed ratio 1:2:3 & time ratio 3:2:1...> Distance ratio ??>> (Ans: 3:4:3..
26. What is the value of p in the equation (15X2-pX+120)=0 if the one root of is must be the double of the other. Ans. May be 90 as the roots are 30,60.
1.a school has 4 maths 3 physics and 3 chemistry teachers each teacher can teach 2 subjects max what is he minimum number of teachers required ans-5
5.there is a circle of radius 5.what is the area of the biggest rectangle that can be cut out of this circle ans-50
6.in a chess board 2 squares are cut out leaving 61 squares if we place blocks each of length=lengthof 2 squares and width=width of 1 square how many blocks will be necessary ans-31
7.how many minimum number of weigh are required to weigh 1-40kg using a weighing pan ans-27,9,3,1
9.radius =3 of a sphere it is melted to form a cube.what is the ratio of the volume of cube to the volume of the sphere ans=1:1
11 there are 4 consonants 3 vowels how many 6 letter strings can u form with atleast one vowels in each ans-5040 (check
12. binary rep of .6875 ans-1011
5. There r 3 boys & 4 girls; Howmany ways they r arranged such that boys should be always together ???
(Ans: (720)check
12. Two motor cycles A & B are started from one point at 4 Kmph & 6 Kmph; After 45 min B starts returning , at what time they will reach....
(Ans: 3.6 km nd .9 hr)
3. a+2b=6,ab=4 2/a + 1/b=? > ans : 3/2
12.cube is moulded as a sphere. find the ratio of> cube of surface area> of sphere to cube of surface area of cube. ans pi/6
1. A make a wall in 9 hour. B makes a wall in 10 hour. When doing together 10 more bricks are required and together make a wall in 5 hour. How many bricks r there in the wall? (190)
3. A man got 20 rupees in 1st day. Next day spent 15 rupees. 3rd day got rupees 20. 4th day spent 15.hoew many days r required to save 60 rupees? Ans (17
4. Apple, orange, mango. Mango + apple=12. Mango + orange=10. Mango +Apple + orange=38. Calculate the no of mango?ans-8
5. 40 persons like apple. 7 like orange and mango dislike apple. 10 like mango and apple and dislike orange. 4 like all. How many people like apple? (26)
6. x + x^3 =0 solve x. (-1,0)
12. Round trip time of 110 meters in a river is 16 min. the velocity of stream is 3m/min. what is the velocity of the person in the still water? (8)
Q3) word "courageously" is given . form the word chosing thefirst,sixth,seventh and eleventh letter. whether ny word can be formed from this word, then how many.?
Q1)cube is of size 5*5*5 .every side has een oloured. it is divided into 125equal parts.1) what is the no. of parts having only one side coloured - 54.2) no. of parts having two sided oloured 36.3) having no side coloured - 27.
Q3) 72 67 66 61 60 ... ans 55.
Q5) A is 16th position and 29th from down of the people who passed. 5 failed , 6 didn't give . how many boys are there in the class : ans : 55.
4)A's 5th birthday is on 12th which is a (say) Monday of a leap year.What willbe the day on their 6th birthday(**wednesday**).
1) A beats B by 20metres ,B beats C by20 metres in a 100 m race .Byhow mauch A beats C ans-36
12) If 2+3= 35, 4+5 = 189, what is 10+1=ans-121
1. A word .e. computers " is given.Qus: using 2nd 4th 6th & last letters of the word given form a meaningfulword Ans: Stop Qus: How many three letter words starting with a vowel can be formedwith the above word . Ans: ?
3. Pointing at a photo a man said the boy in the photo is son of my fathersOnly son . what is the relation of boy to ans: Son
5) A person walks 25 meter North , turns left and walks 10 meter again turnsleft and walks 20 meter Again turns left and walks 10 meter . how far and inwhich direction is e rom the starting point. Ans: 5m north
2. What is the ratio of (¼)to the power 3 and (1/4) to the power4 Ans:4:1
3.If p=n-8 , m=n+10; then in terms of p,m is ? Ans : (p+18)
4.If x+m is an integer and x-m is also an integer Must be an integer. Ans: (probably) 2x
1.women takes 2 steps for every 3 steps of a man. if they both start from left as first step, how many steps did man take before both of them put their right step togetherAns: 5
2. In a garden man has to pick some flowers ans has to pass thru 3 doors. Each door has a guard. man has to give half of the flowers he had to the guard and in return guard returns the man him one flower back. how many flower should man pick so that at the end he is left with same number of lowers he has picked?Ans: 2
3. A bag contains 25 paise, 50 paise and 1 rupee coins in the ratio 7:4:3 . total no. of coins is 360. sum of total coins is Rs. 99(don't remember exactly). so how many 25 paise coins?
6. A two digit number reversed and multiplied by 4 is 3 more than the original digit. what is the digit?
8. A man goes to shopkeeper and says that if u give me as much as i have , i will spend Rs.10/- on ur shop. shopkeeper agrees and man moves to another shopkeeper ans asked same. at 3rd shop after all the transaction , he was left with no money. find the initial amount with the man.(easy one)(2-3 questions of this type)
1.there r three commeetee two r members of all. In any two three r common members find total persons. Ans 5
4 c.p=160. mark price =25% above 160 and discount 15% find s.p
5 two horses r sold for 100rs 1 at 20% profit 2 at 20%loss find profit/loss in rs.
6 x+y+z=9& y>0,z>0 and both r int max value of x. ans 7
7. the ratio of a&b =9:4 after 7 year this become 5:3 .find the age of b.ans-8
8. a rectangle l is increased by 10 & b is decresed by 5.again l is decresed by5 and b is increased by 4 area unaltered in both case find l.
9. consecutive discout of 10%, 15% and then 199 is s.p find c.p.ans-~~260
10. what % of x^2 is (2/3)x ans . can not determined
11. first container contain half oil. Second container of double volume contains ¼ the oil.what is the fration when both r mixed . ans 1/3.
12. x>y>z then which is true. a) x% of y> y% of z b) y%of x >z% of y C) z% of x> y% of z d) all of these. Ans d
15. milk and water is in ratio 5:1 and in other vessel the ratio is 2:1 when they mixed what is the ratio ans-3:1

Paragon

1st round: Written-70 questions in 1hr.The questions are based on English and Reasoning. No special preparation is required as the questions are easy.
2nd round: Group Discussion- Generally they form groups of about 10 people.The topic generally is :Is remexing of old hindi songs good for the industry.
My suggesion is that whenever u get the chance to speak,speak confidently and clearly while looking at each of ur group member.
3rd round: Technical Interview- Questions asked can vary depending upon what u specify as ur strength(technically).
4th round: HR Interview-This interview is taken by 3 top ranked officials of the company.Questions asked are related to u and details about u.Important thing is that they ask u about ur positive and negative points which I think r very important so prepare ur positive and nagative points accordingly and yes don't borrow them from someone else,find out ur own positive and negative points.


Questions:1: Zulus always speak truth and Hutus always speak lies. There are three persons A,B&C. A met B and says " I am a Zulu or I am Hutu". We don't know what exactly he said. then B meets C and says to c that " A is a Zulu ". Then C replied " No, A is a Hutu ". How many Zulus are there ?
A.1 B.2 C.3 D.None. 2: there is a robery and four persons are suspected out of them one isactual thief, these are the senteces said by each one of them!A says D had doneB says A had doneC says i dddnt doneD says B lied when he said that i am thief who is the thief?
A.A B.B C.C D.D 3: two friends A,B are running up hill and then to get down!length if road is 440 yards A on his return journy met B goin up at20 yards from top,A has finished the rase .5 minuit earlier thanB,then how much time A had taken to complete the race? A.6.4min B.6.3min C.6.5min D.6.2min 4: two employs were thereemploy one says to employ two your work ezxperience twice as meemp2 exactlyemp1 but two years before you said that your work experience isthrice as meemp2 yes its also truewhat are their work experience? A.4,8 B.6,8 C.... D..... 5: there were few diamonds.1st thief takes half of the diamonds +22nd thief takes half of the diamonds +23rd thief takes half of the diamonds +24th thief takes half of the diamonds +2when 5 th thief arives there were no diamonds. find total no. of diamonds. A.45 B.40 C.60 D.65 6: Two identical twins have a very unusual characteristic. One tells nothing but lies on Mondays, Wednesdays and Fridays, and tells nothing but the truth all other days. The other tells nothing but lies on Tuesday, Thursday and Saturday, and tells nothing but truth all other days.i: A says that, "today is sunday and my name is Anil"ii:B says that, "today is tuesday and my name is bill" what day is today? A.Sunday B.Monday C.Tuesday D..... 7:Two men are going along a track rail in the opposite direction. One goods train crossed the first person in 20 sec. After 10 min the train crossed the other person who is coming in opposite direction in 18 sec .After the train has passed, when the two persons will meet? A.60min B.72min C...... D....8: A bus started from a bus station at 8.AM. after staying 30min at the destination the reached the starting point. the speed of the bus is 18miles/hr and the distance between the start and destination point is 27 miles. at what time did the bus reach the start point? A.11AM B.1.30PM C.2PM D.12Noon.
9: The lowest temperature in the night in a city A is 1/3 more than 1/2 the highest during the day. Sum of the lowest temperature and the highest temperature is 100 degrees. Then what is the low temp? A.40degree B.... C.... D... 10: Light glows for every 13 seconds . How many times did it glow between 1:57:58 and 3:20:47 am. A.382 B.383 C.384 D.385 11: There are six boxes containing 5 , 7 , 14 , 16 , 18 , 29 balls of either red or blue in colour.Some boxes contain only red balls and others contain only blue.One sales man sold one box out of them and then he says" I have the same number of red balls left out as that of blue ".Which box is the one he solds out ? A.5 B.14 C.18 D.29.
12: A person was fined for exceeding the speed limit by 10 mph. Another person was also fined for exceeding the same speed limit by twice the same. If the second person was travelling at a speed of 35 mph, find the speed limit. A.15 mph B.20mph C.... D ... 13: Javagal, who decided to go to weekened trip should not exceed 8 hours driving in a day. The average speed of forward journey is 40 miles/hr.Due to traffic on sundays, the return journey's average speed is 30 m/h. How far he can select a picnic spot? a) 120 milesb) between 120 and 140 miles c) 160 miles d) 180 miles 14. A car is filled with four and half gallons of fuel for a round trip.If the amount of fuel taken while going is 1/4 more than the amount taken for coming, what is the amount of fuel consumed while coming back? A.1gallons B.2 gallons C. 3gallons D... 15: three sub questions were asked on one analytical reasoning question. 16: there were some logical reasoning questions.

Oracle

This is Just a MODEL Questions will be asked on C, C++, Oracle, RDBMS ,Java and data structuresC--1. The expression 1= 30*1000+2768; evaluates to A)32768 B) -32768 C) 113040 D) 0 2. Which is wrong A) mess=123.56; B) con='T'*'A'; C) this='T"*20; D)3+a=b
3) What is the output of Ptograms Main(){ int a=500,b,c;if(a>400)b=300; c=2--; printf("\n%d%d",b,c);}4) Identify the error in Main(){char c1='a',c2='Z';if (c1=='a'or c2=='z') printf("welcome");}5) What will the following program print Main(){inti; for(i=0;i<=10;i++); printf("%d\n",i);}6) What will be the values of x,y,& zMain(){int x=10,y,a'y=--X;z=x--;printf(%d%d%d\n",x,y,z);}7) What will be the output ofMain(){int i;int marks[]={100,90,75,90,80};for (i=0,i<4;i++)disp(&marks[i]);disp(int i="&arr[1];J=" deptno="10;END;Which">4) How would you declare a PL/SQL table of records toholdthe rows selectd from the EMP table ?5) Which statement about Implicit cursor is true ?a) Implicit cursors are declared implicitly only fromDML b) Implicit cursors are dclared implicitly for all theDML and SELECT statements c) Programmers needs to close all implicit cursorsbefore the end of PL/SQL programsd) Programmers can declare Implicit cursors by usingcursor type in declaraion section 6) Evaluate this PL/SQL Block Declare V_Result number(2)BEGIN DELETE FROM EMPLOYEESWHERE department id (20,30,80);V_result:=SQL%ROWTYPE;COMMIT;END;/What will be the value of v_result if no rows areselected a) 0 b) 1 c) TRUE d) NULL 7) Which two conditions in a PL/SQL block cause anexception error to occur ? ( Choose 2 ) a) Select statement does not return a rowb) select stmt returns more than one rowc) select statement contaains a group by claused) seelct statenent donot have where clausee) data type in the select list are inconsistent whithdata types in the into clause DBMS/ RDBMS-----------1)You are requested to use the HIERARCHIAL DATABSEmodel for the Human Resource DBMS System . Since yourentity relationship model for the system reveal thatmost of the entities have many-o-many relationshipsbetween them, you do not approve TOm'srequest.Referring to the above scenario,what is theREASON behind your decision ?<>
2) Which one of the following mechanisms in aRDBMSensure a) 1 Constraints b) Locking c) Views d) Indexes3) How does a data base stor information that isrelated to the location of its tablesa) 1 by relationships b) By normalisation c) By a data dictionary d) by data banking e) By entity modeling 4) Two tables A & B would be givenYou are asked to mintain a relationship between TableA & B. Referring to the gien table, which field willyou choose as the primary key for Table A <>
5) You have been asked to remove all aggregatefunctions from your SQL statements refering to thescenario above. WHich one of the following do you needto remove ?a) 1 SUM b) COUNT c) AVG d) MAX e) ROUND Data structures--------------- 1) What will be the output of the gien program int m,n=10,top=0,stack[11],item ,current;main(){puts ("enter number of elements <11 top="1;top<=" m="top;m">0;--m)printf("%d\n",stack[m]);}2)Questions on BINARY TRESS and LINKED LISTS ( 4 or 5 options would be given ) 3) What are the THREE MODES OF traversal of a BINARYTREE?

1. Three beauty pageant finalists-Cindy, Amy and Linda-The winner was musician. The one who was not last or first was a math major. The one who came in third had black hair. Linda had red hair. Amy had no musical abilities. Who was first? (A) Cindy (B) Amy (C) Linda (D) None of these
2. Two twins have certain peculiar characteristics. One of them always lies on Monday, Wednesday, Friday. The other always lies on Tuesdays, Thursday and Saturdays. On the other days they tell the truth. You are given a conversation. Person A- today is Sunday, my name is Anil Person B-today is Tuesday, my name is Bill What day is today? (A) Sunday (B) Tuesday (C) Monday (D) Thursday
3. The difference of a number and its reciprocal is 1/2.The sum of their squares is (A) 9/4 (B) 4/5 (C) 5/3 (D) 7/4
4. The difference of a number and its square is 870.What is the number? (A) 42 (B) 29 (C) 30 (D) 32
5. A trader has 100 Kg of wheat, part of which he sells at 5% profit and the rest at 20% profit. He gains 15% on the whole. Find how much is sold at 5% profit? (A) 60 (B) 50 (C) 66.66 (D) 33.3
6. Which of the following points are collinear? (A) (3,5) (4,6) (2,7) (B) (3,5) (4,7) (2,3) (C) (4,5) (4,6) (2,7) (D) (6,7) (7,8) (2,7)
7. A man leaves office daily at 7pm.a driver with car comes from his home to pick him from office and bring back home. One day he gets free at 5.30 and instead of waiting for driver he starts walking towards home. In the way he meets the car and returns home on car. He reaches home 20 minutes earlier than usual. In how much time does the man reach home usually? (A) 1 hr 20 min (B) 1 hr (C) 1 hr 10 min (D) 55 min
8. If m:n = 2:3,the value of 3m+5n/6m-n is (A) 7/3 (B) 3/7 (C) 5/3 (D) 3/5
9. A dog taken four leaps for every five leaps of hare but three leaps of the dog is equal to four leaps of the hare. Compare speed? (A) 12:16 (B) 19:20 (C) 16:15 (D) 10:12
10. A watch ticks 90 times in 95 seconds. And another watch ticks 315 times in 323 secs. If they start together, how many times will they tick together in first hour? (A) 100 times (B) 101 times (C) 99 times (D) 102 times
11. The purpose of defining an index is (A) Enhance Sorting Performance (B) Enhance Searching Performance (C) Achieve Normalization (D) All of the above
12. A transaction does not necessarily need to be (A) Consistent (B) Repeatable (C) Atomic (D) Isolated
13. To group users based on common access permission one should use (A) User Groups (B) Roles (C) Grants (D) None of the above
14. PL/SQL uses which of the following (A) No Binding (B) Early Binding (C) Late Binding (D) Deferred Binding
15. Which of the constraint can be defined at the table level as well as at the column level (A) Unique (B) Not Null (C) Check (D) All the above
16. To change the default date format in a SQLPLUS Session you have to (A) Set the new format in the DATE_FORMAT key in the windows Registry. (B) Alter session to set NLS_DATE-FORMAT. (C) Change the Config.ora File for the date base. (D) Change the User Profile USER-DATE-FORMAT.
17. Which of the following is not necessarily an advantages of using a package rather than independent stored procedure in data base. (A) Better performance. (B) Optimized memory usage. (C) Simplified Security implementation. (D) Encapsulation.
18. Integrity constrains are not checked at the time of (A) DCL Statements. (B) DML Statements. (C) DDL Statements. (D) It is checked all the above cases.
19. Roll Back segment is not used in case of a (A) DCL Statements. (B) DML Statements. (C) DDL Statements. (D) all of the above.
20. An Arc relationship is applicable when (A) One child table has multiple parent relation, but for anyone instance of a child record only one of the relations is applicable. (B) One column of a table is related to another column of the same table. (C) A child table is dependent on columns other than the primary key columns of the parent table. (D) None of the above.
21. What is true about the following C functions? (A) Need not return any value. (B) Should always return an integer. (C) Should always return a float. (D) Should always return more than one value.
22. enum number { a=-1, b=4, c,d,e,} what is the value of e? (A) 7 (B) 4 (C) 5 (D) 3
23. Which of the following about automatic variables within a function is correct? (A) Its type must be declared before using the variable. (B) They are local. (C) They are not initialized to zero. (D) They are global.
24. Consider the following program segment int n, sum=5; switch(n) { case 2:sum=sum-2; case 3:sum*=5; break; default:sum=0; } if n=2, what is the value of the sum? (A) 0 (B) 15 (C) 3 (D) None of these.
25. Which of the following is not an infinite loop? (A) x=0; (B) # define TRUE 0.... do{ While(TRUE){....} /*x unaltered within the loop*/ (C) for(;;) {....} ....} While(x==0); (D) While(1) {....}
26. Output of the following program is main() { int i=0; for(i=0;i<20;i++) i="3;" i="func(i);" i="func(i);" g1="First String" g1="g();" b="&a[2];" ab="x;" b =" (a+b)/(a-b)a*b" href="mailto:a@b">a@b = a/b – b/a (implies subtracting the smaller of the two from the other one )a#b = a/b + b/a
16) Find (((a@b) + (a#b)) * 1)/ 1, where a=5.91 and b= 17.73
1. 35 2. 18/17 3.17/18 4.None of these
17) State which of the following is/are true I. 7@(a*b) is undefined if a = bII. [(a/b)/1 * [(b/a)/1. = (a@b) x (a#b)
1.I only 2. II only 3. Both I and II 4. Neither I or II
18) What is the maximum area that can be enclosed by a wire 44cm long ?
1. 77 2. 154 3. 308 4.None of these
19) If A(2,3) ,B(-2,-3) and C(1,2) are three vertices of a triangle ,which among the following is the largest angle ?
1. ABC 2. BCA 3. CAB 4. All three angles are equal20) f(x) = 2(x*x) +1 when x<0>=0 What is f(f(f(2))) ?
1. 66 2. –33 3. 33 4. None of these
21) One sells 30 kg rice with cost Rs.22.87/kg at 20% profit and 50kg rice with cost price Rs 20.92/kg at 30% profit .What is the total percentage profit ?
1. 26.25% 2. 24.72% 3. 26.5% 4. 28%
22) Ravi buys 100 5% shares of face value Rs.100 at Rs.15000 .If he sells them off after a year at Rs 155 a share ,what is his yield ?
1. 8.33% 2. 6.67% 3. 5% 4. 3.33%
23) Amit and Meghna went to New York for a 63 day holiday .Each day ,Amit spent as many as hundred dollar bills as the remaining number of days in the trip (excluding the current day ) ,and Meghna spent as many as hundred dollar bills as the number of days already spent (including current day). How much per day would they have spent together during the holiday ?
1. $12,600 2. $10000 3. $6300 4. $5000
24) Bacteria reproduce in such a manner that every hour their number doubles In a controlled experiment that started with a certain number of bacteria in a jar at 12noon on Tuesday ,30 million were found at 12noon on Wednesday .At what time were there 15 million bacteria ? 1. Midnight ,Tuesday 2. 6a.m on Wednesday 3. 10 a.m Wednesday 4. None of these
25) Take a number ‘x’ and follow these steps :1. Find the sum of its digit 2. If the sum has only one digit , STOP3. Else , go back to step 1 with the new number.If x = 1684 ,what is the end result ?
1. 19 2. 10 3. 1 4. None of these
26) A number consisting of five digits 5,6,7,8 and 9 each coming once but not necessarily in that order is taken ,and an algorithm specified in the previous question is run on it .How many different end results are possible ?
1. One 2.Three 3.Five 4. Nine
Directions for questions 27 and 28 :Each question is followed by two statements A and B. Mark 1. If statement A alone is sufficient to answer the question 2. If statement B alone is sufficient to answer the question3. If both statements A and B are required to answer the question4. If neither A or B are sufficient to answer the question
27) What is the height of the tower ? A. A man standing at a distance of 1km from the bottom of the tower makes an angle 300 degrees with the top of the tower .B. An insect starts from the bottom of the tower and reaches the top in 25sec.
28) Distance between A and B isA. A and B two points on the circumference of the circle with center O and radius 5.2 cmB. Angle AOB = 450
Additional instructions for questions 29 and 30:
For any activity , X, year Ao dominates year Bo if organized retail business in activity X in year Ao is greater than organized retails business in activity X is year Bo .For any two activities in the organized retail business ,A and B ,year Xo dominates year Yo ifa. The organized retail business in activity A ,in the year Xo is greater than equal to the organized retail business activity A in the year Yo: and b. The organized retail business in activity B ,in the year Yo is less than or equal to the organized retail business in activity B in the year Xo.
29) For the organized retail business activity in children’s clothing ,which one of the following is true ?
1. 1994-95 dominates 1995-962. 1995-96 dominates 1994-953. 1997-98 dominates 1996-974. 1998-99 dominates 1997-98
30) For the organized retail business activity in children ‘s clothing and footwear ,which of the following is true ?
1. 1995-96 dominates 1994-952. 1994-95 dominates 1995-963. 1996-97 dominates 1995-964. None of these


SQL AND SQL*Plus
1. Which of the following statements contains an error?
A. SELECT * FROM emp WHERE empid = 493945;B. SELECT empid FROM emp WHERE empid= 493945;C. SELECT empid FROM emp;D. SELECT empid WHERE empid = 56949 AND lastname = 'SMITH';
2. Which of the following correctly describes how to specify a column alias?
A. Place the alias at the beginning of the statement to describe the table.B. Place the alias after each column, separated by white space, to describe the column.C. Place the alias after each column, separated by a comma, to describe the column.D. Place the alias at the end of the statement to describe the table.
3. The NVL function
A. Assists in the distribution of output across multiple columns.B. Allows the user to specify alternate output for non-null column values.C. Allows the user to specify alternate output for null column values.D. Nullifies the value of the column output.
4. Output from a table called PLAYS with two columns, PLAY_NAME and AUTHOR, is shown below. Which of the following SQL statements produced it?
PLAY_TABLE-------------------------------------"Midsummer Night's Dream", SHAKESPEARE"Waiting For Godot", BECKETT"The Glass Menagerie", WILLIAMS
A. SELECT play_name author FROM plays;B. SELECT play_name, author FROM plays;C. SELECT play_name', ' author FROM plays;D. SELECT play_name', ' author PLAY_TABLE FROM plays;
5. Issuing the DEFINE_EDITOR="emacs" will produce which outcome?
A. The emacs editor will become the SQL*Plus default text editor.B. The emacs editor will start running immediately.C. The emacs editor will no longer be used by SQL*Plus as the default text editor.D. The emacs editor will be deleted from the system.
6. The user issues the following statement. What will be displayed if the EMPID selected is 60494?
SELECT DECODE(empid,38475, "Terminated",60494, "LOA", "ACTIVE") FROM emp;
A. 60494B. LOAC. TerminatedD. ACTIVE
7. SELECT (TO_CHAR(NVL(SQRT(59483), "INVALID")) FROM DUAL is a valid SQL statement.
A. TRUEB. FALSE
8. The appropriate table to use when performing arithmetic calculations on values defined within the SELECT statement (not pulled from a table column) is
A. EMPB. The table containing the column valuesC. DUALD. An Oracle-defined table
9. Which of the following is not a group function?
A. avg( ) B. sqrt( )C. sum( )D. max( )
10. Once defined, how long will a variable remain so in SQL*Plus?
A. Until the database is shut downB. Until the instance is shut downC. Until the statement completesD. Until the session completes
11. The default character for specifying runtime variables in SELECT statements is
A. AmpersandB. EllipsesC. Quotation marksD. Asterisk
12. A user is setting up a join operation between tables EMP and DEPT. There are some employees in the EMP table that the user wants returned by the query, but the employees are not assigned to departments yet. Which SELECT statement is most appropriate for this user?
A. select e.empid, d.head from emp e, dept d;B. select e.empid, d.head from emp e, dept d where e.dept# = d.dept#;C. select e.empid, d.head from emp e, dept d where e.dept# = d.dept# (+);D. select e.empid, d.head from emp e, dept d where e.dept# (+) = d.dept#;
13. Developer ANJU executes the following statement: CREATE TABLE animals AS SELECT * from MASTER.ANIMALS; What is the effect of this statement?
A. A table named ANIMALS will be created in the MASTER schema with the same data as the ANIMALS table owned by ANJU.B. A table named ANJU will be created in the ANIMALS schema with the same data as the ANIMALS table owned by MASTER.C. A table named ANIMALS will be created in the ANJU schema with the same data as the ANIMALS table owned by MASTER.D. A table named MASTER will be created in the ANIMALS schema with the same data as the ANJU table owned by ANIMALS.
14. User JANKO would like to insert a row into the EMPLOYEE table, which has three columns: EMPID, LASTNAME, and SALARY. The user would like to enter data for EMPID 59694, LASTNAME Harris, but no salary. Which statement would work best?
A. INSERT INTO employee VALUES (59694,'HARRIS', NULL);B. INSERT INTO employee VALUES (59694,'HARRIS');C. INSERT INTO employee (EMPID, LASTNAME, SALARY) VALUES (59694,'HARRIS');D. INSERT INTO employee (SELECT 59694 FROM 'HARRIS');
15. Which three of the following are valid database datatypes in Oracle? (Choose three.)
A. CHARB. VARCHAR2C. BOOLEAND. NUMBER
16. Omitting the WHERE clause from a DELETE statement has which of the following effects?
A. The delete statement will fail because there are no records to delete.B. The delete statement will prompt the user to enter criteria for the deletionC. The delete statement will fail because of syntax error.D. The delete statement will remove all records from the table.
17. Creating a foreign-key constraint between columns of two tables defined with two different datatypes will produce an error.
A. TRUEB. FALSE
18. Dropping a table has which of the following effects on a nonunique index created for the table?
A. No effect.B. The index will be dropped.C. The index will be rendered invalid.D. The index will contain NULL values.
19. To increase the number of nullable columns for a table,
A. Use the alter table statement.B. Ensure that all column values are NULL for all rows.C. First increase the size of adjacent column datatypes, then add the column.D. Add the column, populate the column, then add the NOT NULL constraint.
20. Which line of the following statement will produce an error?
A. CREATE TABLE goodsB. (good_no NUMBER,C. good_name VARCHAR2 check(good_name in (SELECT name FROM avail_goods)),D. CONSTRAINT pk_goods_01E. PRIMARY KEY (goodno));F. There are no errors in this statement.
21. MAXVALUE is a valid parameter for sequence creation.
A. TRUEB. FALSE
22. Which of the following lines in the SELECT statement below contain an error?
A. SELECT DECODE(empid, 58385, "INACTIVE", "ACTIVE") empid B. FROM empC. WHERE SUBSTR(lastname,1,1) > TO_NUMBER('S')D. AND empid > 02000E. ORDER BY empid DESC, lastname ASC;F. There are no errors in this statement.
23. Which function below can best be categorized as similar in function to an IF-THEN-ELSE statement?
A. SQRTB. DECODEC. NEW_TIMED. ROWIDTOCHAR
24. Which two of the following orders are used in ORDER BY clauses? (choose two)
A. ABSB. ASCC. DESCD. DISC
25. You query the database with this command
SELECT nameFROM employeeWHERE name LIKE ‘_a%’;
Which names are displayed?
A. Names starting with “a”B. Names starting with “a” or “A”C. Names containing “a” as second characterD. Names containing “a” as any letter except the first
PL/SQL
26. Which of the following statements is true about implicit cursors?
A. Implicit cursors are used for SQL statements that are not named.B. Developers should use implicit cursors with great care.C. Implicit cursors are used in cursor for loops to handle data processing.D. Implicit cursors are no longer a feature in Oracle.
27. Which of the following is not a feature of a cursor FOR loop?
A. Record type declaration.B. Opening and parsing of SQL statements.C. Fetches records from cursor.D. Requires exit condition to be defined.
28. A developer would like to use referential datatype declaration on a variable. The variable name is EMPLOYEE_LASTNAME, and the corresponding table and column is EMPLOYEE, and LNAME, respectively. How would the developer define this variable using referential datatypes?
A. Use employee.lname%type.B. Use employee.lname%rowtype.C. Look up datatype for EMPLOYEE column on LASTNAME table and use that.D. Declare it to be type LONG.29. Which three of the following are implicit cursor attributes?
A. %foundB. %too_many_rowsC. %notfoundD. %rowcountE. %rowtype
30. If left out, which of the following would cause an infinite loop to occur in a simple loop?
A. LOOPB. END LOOPC. IF-THEND. EXIT
31. Which line in the following statement will produce an error?
A. cursor action_cursor isB. select name, rate, actionC. into action_recordD. from action_table;E. There are no errors in this statement.
32. The command used to open a CURSOR FOR loop is
A. openB. fetchC. parse D. None, cursor for loops handle cursor opening implicitly.
33. What happens when rows are found using a FETCH statement
A. It causes the cursor to closeB. It causes the cursor to openC. It loads the current row values into variablesD. It creates the variables to hold the current row values
34. CREATE OR REPLACE PROCEDURE find_cpt(v_movie_id {Argument Mode} NUMBER, v_cost_per_ticket {argument mode} NUMBER)ISBEGIN IF v_cost_per_ticket > 8.5 THENSELECT cost_per_ticketINTO v_cost_per_ticketFROM gross_receiptWHERE movie_id = v_movie_id; END IF;END;
Which mode should be used for V_COST_PER_TICKET?
A. INB. OUTC. RETURND. IN OUT
35. CREATE OR REPLACE TRIGGER update_show_gross {trigger information} BEGIN {additional code} END;
The trigger code should only execute when the column, COST_PER_TICKET, is greater than $3.75. Which trigger information will you add?
A. WHEN (new.cost_per_ticket > 3.75)B. WHEN (:new.cost_per_ticket > 3.75C. WHERE (new.cost_per_ticket > 3.75)D. WHERE (:new.cost_per_ticket > 3.75)
36. What is the maximum number of handlers processed before the PL/SQL block is exited when an exception occurs?
A. Only oneB. All that applyC. All referencedD. None
37. For which trigger timing can you reference the NEW and OLD qualifiers?
A. Statement and RowB. Statement onlyC. Row onlyD. Oracle Forms trigger38. CREATE OR REPLACE FUNCTION get_budget(v_studio_id IN NUMBER)RETURN number IS
v_yearly_budget NUMBER;
BEGIN SELECT yearly_budget INTO v_yearly_budget FROM studio WHERE id = v_studio_id;
RETURN v_yearly_budget;END;
Which set of statements will successfully invoke this function within SQL*Plus?
A. VARIABLE g_yearly_budget NUMBEREXECUTE g_yearly_budget := GET_BUDGET(11);B. VARIABLE g_yearly_budget NUMBEREXECUTE :g_yearly_budget := GET_BUDGET(11);C. VARIABLE :g_yearly_budget NUMBEREXECUTE :g_yearly_budget := GET_BUDGET(11);D. VARIABLE g_yearly_budget NUMBER:g_yearly_budget := GET_BUDGET(11);
39.CREATE OR REPLACE PROCEDURE update_theater(v_name IN VARCHAR2, v_theater_id IN NUMBER) ISBEGIN UPDATE theater SET name = v_name WHERE id = v_theater_id;END update_theater;
When invoking this procedure, you encounter the error:ORA-00001: Unique constraint(SCOTT.THEATER_NAME_UK) violated.
How should you modify the function to handle this error?
A. An user defined exception must be declared and associated with the error code and handled in the EXCEPTION section.B. Handle the error in EXCEPTION section by referencing the error code directly.C. Handle the error in the EXCEPTION section by referencing the UNIQUE_ERROR predefined exception.D. Check for success by checking the value of SQL%FOUND immediately after the UPDATE statement.

40.CREATE OR REPLACE PROCEDURE calculate_budget ISv_budget studio.yearly_budget%TYPE;BEGIN v_budget := get_budget(11); IF v_budget < yearly_budget =" v_new_budget" id =" v_studio_id;" s1="{" i="1;ifile://Ans: i work for oracle
3.void main() { int i,j,k; for(i=0;i<3;i++) k="sum(i,i);" href="file://Ans/">file://Ans: 6
4.void main() { int i; clrscr(); for(i=1;i<6;++i) href="file://Ans/">file://Ans: 1,4,6
5.Which of the storage class(es) becomes the globalvariables for the =entire Program (A) Extern (B) Static (C) Auto (D) Register
ANSWER : A
6.//What is the output of the program void main() { char s[]="oracle is the best"; char t[40]; char *ss,*tt; while(*tt++=*ss++); printf("%s",t); getch(); } // A. oracle is the best // B. Core dump // c. Error Message // D. Goes into infinite loop // Ans: B. core dump (Garbage value)
7.//What is the output of the program void main() { int j[10]={9,7,5,3,1,2,4,6,9}; int i=1; clrscr(); for(;i<9;i++) n="5;" i="5;i">0;i--) { j=1i=100; strcpy(str1->st1,"Welcome to Oracle"); printf(" %d%s\n",str1->i,str1->st1); getch(); } // A. core dump // B. will not compile // c. 100,Welcome to Oracle // D. None of these // Ans: C
13.//What is the output of the program void main() { int i,j,k; i=2; j=4; k=i++>j&2; printf("%d\n",k); if(++k &&amp;amp; ++i<--j i++) { j=++k; } printf(" %d %d %d",i,-j--,k); getch(); } // A. 4,-3,2 // B. 5,-3,2 // c. 4,-2,2 // D. 5,-2,2 // Ans: D 14.Which of the following is not true incase ofCommand line arguments A.The argc parameter is used to hold the numberof arguments in the =command line and is an integer B. The argv parameter is a pointer to an array ofa character =pointer and each one points to command linearguments C. The argv[1] always point to program name D. None of above Ans: C 15. A function without any return type declaresreturn=20 A. Integer B. Float C. Void D. Syntax Error Ans: A 16.//What is the output of the program #include #include #define sqr(a) a*a void main() { int a=10,b=1,c; c=sqr(10+1); printf("Sqr Root of (10+1)is %d",c ); getch(); } // A. 121 // B. 21 // c. 13 // D. Syntax Error // Ans: B
17.//What is the output of the program #include #include void main() { int i,j=20; clrscr(); for(i=1;i<3;i++)> #include void main() { int i=1*4/3-27%3^2+100*0.5-(4>3?1:2); clrscr(); printf("%d",i); getch(); } // A. 49 // B. compile error // c. 51 // D. 48 // Ans: b
19.What is the output of the program #include #include void main() { char *st1[3]= {"Hello","World","Oracle"}; *st1=st1[2]; st1[1]=*st1; free(st1[0]); free(st1[1]); clrscr(); printf("%s %s %s",st1,st1[1],st1[2]); getch(); } // A. Garbage Garbage Oracle // B. oracle oracle oracle // c. Hello World Oracle // D. Core Dump:cannot Print after freeing thememory // Ans: D
20.Consider the following structure =20 Struct { int data; struct node *prev; struct node *next; }NODE;
NULL <-- 5 --> 8 --> 10 --> NULL p <-- q <-- r=20 WHAT WILL BE THE VALUE OF r-->prev-->-->next-->data? A. 8 B. Null C. 5 D. 10 Ans: 10
21. what will be the output of the fallowing SELECTstatement ? SELECT count(*) FROM emp Where exist (select 'X' From dept where dept_name ='Stores' and dept.dept_id=emp.dept_id)
A. select total number of employees belonging todepartment " stores " B. select all employees belonging to department "X" C. select all employees belonging to department"stores" D. select total number of employees belonging todepartment "X"
22. Denormalisation is done to=20 A. Check for Data Integrity B. Reduce Data Redundancy C. Intoduce Security Check D. Increase Query performance .
23. How many columns are retrived from this query: SELECT address1 ',' address2 ','address2 "Address" FROM =employee;
A. 3 B. 2 C. 1 D. 0
24. What is the is the result of the fallowing CodePiece=20 Insert into table A value(a1): CREATE TABLE B AS SELECT * FROM A; ROLLBAACK ; A. Table B gets created with the row inserted in thefirst statement. B. Table B is not created C. Table B gets created , but no row gets insertedinto Table A D. Rollback throws up an exception .
25. The key word used in Oracle for string searchingis=20
A. SOUNDEX B. DECODE C. LIKE D. HAVING
26. What does the ROLLBACK statement wil do in thefool segment of =code PROGRAM STARTS HERE ........ SOME DML STAT. ...SAVEPOINT1 SOME DML STAT. ...SAVEPOINT2 SOME DML STAT. ...ROLLBACK A. Rollback Dml changes to savepoint 1 B. Rollback Dml changes to savepoint 2 C. Rollback Dml changes of the last DMLststs. just before =ROllback stats D. Rollback DML changes to the place whre theprogram starts
27. Which clause u use to exclude the rows beforegrouping them? A. Group By B. Having C. Where D. Minus
28. Which of the following statements is not trueabout views? A. u can create a index on views B. Views donot have permanent data C. Views can be based on one or more tables D. Views can be dropped without droppingtables
29 How many JION conditions are needed in JOIN queryto avoid a =Cartesian Product? A. No of tables + 1 B. No of tables - 1 C. No of colums + 1 D. No of colums - 1
30. "An item could be either a component or spare ".How can u =represent this scenerio in a E-R=20 A. Subtype Relation B. Arc Relation C. Recursive Relation D. Many to Many Relationscription


The questions asked to me in Oracle Interview are:
1st interviewer(one hour 10 minutes) ______________________________________
1. There is dual switch bulb,we have to write the truth table and also FSM for that dual switch bulb.
2. Write a program to check whether the given comments are nested comments are or not(/*ajsd/*asdh*/asd*/ is nested comment but /*asd*/ /*kjasdh*/ is not a nested comment)-you can write program in any language...
3.Check whether the trees are structurally similar or not....program using linked list
4. What is virtual functions and some question on virtual functions....
5.What are the statemnets beging with # mean in C language and how they can be handled by macroprocessor and if it comes in the middle of program how it will be handled..
6.Write a program for finding the factorial of a given number..

2nd interviewer(one hour 20 minutes) _________________________________________
1. Write a program to find whether a linked list is circular or not
2. Write a program to reverse a linked list...
3.Write a program to find the mirror image of the given binary tree.
4.Tell something about genetic algorithms and explain ur M.Tech project....
3rd interviewer(one hour 10 minutes) ______________________________________
1. What is a process and a thread
2.Write a algorithm for deletinga node in an binary search tree...
3.What is inheritance,virtual function,singleton class and pure virtual function...
4.Write a unix network program to implement the ftp protocol,,
5. write a algorithm to find a loop ina linked lsit.
6.he concentrated mainly in unix.. what is socket and what is binding and how is client server thing works.....

4th interviewer(one hour ) _________________________________________
1. What are the various scheduling algorithms and explain the algorithms
2. Write what will happen when you run a program that contains many functions... you have to tell what is stored in stack and what is stored in the heap and other steps how a program is executed...
3. Write a program for quicksort and also merge sort
4.What is the process control block and explain the structure with a diagram...
5.Write a program to insert nodes in a linked list and print them and some modifications after writing the program to write functions for addnode....
6.he concentrated mainly in Operating systems...



1. #include #define sqr(x) (x*x)int main(){ int x=2; printf("value of x=%d",sqr(x+1));} What is the value of x?a)4 b)5 c)None d)can not compileAns: 5 2. what is the wrong in the following program?#define LBRACKET {#define RBRACKET }#define MAIN mainint MAIN()LBRACKET int x=2; printf("%d",x);RBRACKET a) This program will compileb) compilation error 3.#include int main(){ int x=4; { { { int x=2; printf("%d",x); } } }}a) 4 b)2 c)Nesting not allowed d)dependent on the compiler4. Go through the following code sinippet char a[20]; a="Hello Orcale Test"; will this compile? a) Compilation Error b) Strings are allowed in c but cannot be assigned directly. c) dependent on compiler d) will work fine.5. the expression a+b*c should be conveted to +a*bc. Using tree structure, Which traversal is the correct one? a) Postfix traversal b) prefix traversal c) infix traversal d)None6. what about brk, sbrk a) system calls b) function calls c) user defined functions 7. Why the use of alloca() is discouraged?8. Macros support multiple arguments ?9. the header file a) contains only compiler directives and extern variables b) contail only structures and unitions c) a & b10. what about "char *(*(*a[])())();"


1. An index is automatically generated with the following constraints. a. Check b. Not null c. Primary key d. Foreign key 2. Select mod(16,3) from emp; a. 1 b. 2 c. 3 d. Error in the stmt 3. The data dictionary view to see the list of constraints enabled on a table is a. user_tables b. user_table_constraints c. user_constraints d. There is no dictionary view available for the same 4. Identify the pseudocolumns a. rowid b. sysdate c. rowval d. dual 5. select deptno, count(empno) from emp where count(empno)>=5 group by deptno; identify the line no which contains the error a. 1 b. 2 c. 3 d. 1,3 6. choose the group function that can be used with any data type a. sum() b. min() c. avg() d. all 7. which of the following sequence is true a. WHERE,HAVING,GROUPBY,ORDERBY b. GROUPBY, WHERE, HAVING, ORDERBY c. ORDERBY,GROUPBY,WHERE,HAVING d. NONE OF THE ABOVE 8. which of the proper keyword to deallocate memory a. free b. delete c. clear d. remove 9. what is the index no of the last element of an array with 29 elements a. 29 b. 28 c. 0 d. programmer defined
10. what is the final value of x when the code for(int x=0;x<10;x++)> void main() { char buffer[10]={"Genesis"}; printf("%d",&buffer[4]-(buffer)); } a. 3 b. 4 c. 0 d. illegal pointer subtraction 14. what is the output for #include main() { static int a[]={5,10,15,20}; int * ptr=a; int ** ptr_ptr=&ptr; printf("\n %d",**ptr_ptr++); } a. 5 b. 10 c. 15 d. 6 15. what is the value of expr.. 1+2/3*4+1 a. 2 b. 3 c. 4 d. 4.666666 e. 5 16. identify the relationship between the many employees working in a dept.. a. one to one b. one to many c. many to one d. many to many 17.there was a table given and it was asked which normal form does it follows.. 18. the process of including some controlled redundancy for the sake of performance is known as a. normalization b. Cartesian product c. Denormalization d. None 19. in a doubley linked list a. the last node contains the address of the first node b. each node contains the address of previous and next node c. each node contains the address of previous node d. none 20. in a queue each node contains a. the address of previous node b. address of next node c. address of both the previous and next node d. none of the above
1. given a square matrix which consists only of 1 and 0......find which rows,which cols and which diagonals consist entirely of 1's. 2. given an array of integers find all possible combinations of the numbers whose sum equal to 90..... ans : knapsack problem (in data structures - aho ullman) Note : for them solution was not the criteria.......but the approach was important......the solution should be generalised and optimized........optimization was given the top priority........ here is the techincal paper : plz try to solve them urself by trying on comp. 1. const int MAX=10; main() {enum a {a,b,MAX}; print MAX; } 2. enum object is a const which can only be assigned a value at initialization or a variable which can be assigned any value in the middle of the program? 3. void *p; what operation cannot be performed on p? ans : arithmetic operation unless it is properly typecasted 4. char **p="Hello"; print p,*p,**p 5. main() {char str[]="Geneius"; print (str); } print(char *s) {if(*s) print(++s); printf("%c",*s); } 6. what does the function fcloseall() does ? 7. main() {printf("Genius %d",fun(123)); } fun(int n) {return (printf("%d",n)); } 8. difference between definition and declaration. 9. find the error? fun() {int i=10; if(i<10) a="9,b=" c="3,d;" d="(b-c)<(c-a)" 1="?" i="4;" i="i/4);" cols="?"> 4. Mention basic concepts of OOP. 5. What are messages in OOP?. 6. What is garbase collection?. 7.what is object?. 8. what is a class?.
section 4: 1. expand the following: a.SEI b. ISO 2. what are different levels of SEI?. 3. What is significance of ISO?> 4. Expand the following: a. WWW b. HTTP c. HTML d. TCP/IP 5. what is Black box testing?. 6. explain the following: 1. white box testing 2. white box testing 3. boundary testing 4 stress 5. negative 6. system 7. unit 8.module 9.destructive

1. what are the macros other than C macros (the macrosin word,excel) A macro in MS-word is used to group a sequenceof jobs and make it as a button or keyboard shortcut.Suppose, if you need always to draw a table containing2 rows and 5 cols, you can start,record a macro andmake it as a button and put in taskbar, sothat whenyou press it, you will be provided with a fixed table.
2. can you delete a column from a table. In oracle 9i, you can do it by the statementALTER TABLE table1 DROP COLUMN column1; In oracle8,you can't.
3. can you store a image in oracle and by whichdatatype? Yes, you can and it can be acheived by usinga BLOB (binary large object) type and store upto 4GBin a single column.
4. have you used reports and forms in oracle?
5. have you written applications to retrieve storedimages in a table?
6. some DOS commands and UNIX.
7. project desription (both academic andminiprojects,if any)
8. some situation questions like what would you do ifyour company is burning,etc.


English:analogy questions around ( you can refer to GRE book)fill the sentence with appropriate word..(multiple choices given)sentence correction..
Aptitude:arithmetic questions..some of the questions:Q:1/3th of the passengers gotdown at first stop and 30 people got into the bus, 1/4th of the passengers gotdown at second stop and 12 people got into the bus.in last stop 84 people got down from the bus.What is the initial capacity of the bus?
Q:one person is running around a 180 sq yard filed, first 1/4 his speed was 10KMPH second 1/4 20KMPH third 1/4 30 KMPH and the fourth 1/4 40 KMPH.what is the average speed?
NOTE: there was a question on milk ,water ratio..
logical deductions..Q: is x+y a prime? a. x is prime b. y is prime
options: 1. only "a" correct 2. only "b" correct 3. both are correct 4. both are wrong.
C,C++,JAVA
Q: There were 2 or 3 C programs and the question is to point error in the program or to predict the answer
Q:Which one of the following is not a storage type:1. static 2. register 3. stack 4.autoanswer: stack
Q:what is the type of the second parameter of fopen() function?
Q:Which of the following is correct about constructor?OPTIONS: 1.void type 2. return nothing 3..... 4.....answer 2
Q:how do we store a constant value in java?multiple choices given..answer: using "final"
SQL:please be thorough with SQL, PL/SQL
There were some questions where they gave query and asked whether it is correct or wrong if wrong what is wrong...
Q: create table...........;{table creation query)Roll back;what will be the output?options ....

1. how compiler treats variables of recursive functions2. what is orthogonal matrix?3. given two tables and asked 2 qns on those table , one is on join and another is on NOT IN4. given some qns on pointers( pretty easy)5. given five qns on data structures like , lifo, fifo 6. qtn on primary key 7. how NULL in sql is treated?8. given a doubly linked list and asked r->left->right->data ans: r->data9:explain const char *ptr and char *const ptr

1)declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end;What will be the output ?(a) equal(b) not equal(c) else(d) No outputCorrect Answer : (c)
2)declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=numto_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ? (a)12 (b)12345 (c)123 (d)Wrong assignmentCorrect Answer : (c)


1. question on bubble sore2. quick sort complexity3. heap sort SPACE complexity.
4. char *p = "Oracle India"; p[5] == 'l' ? printf("Orcle") : printf("India")
5. main(){ int i=5; recursive(i);}recursive(int u){ if(u > 0 ) recursive(u-1); printf("%d", u);}
6. question on function pointer. char *(*(*x())[])()7. GRANT command question8. about MINUS set operator.
Java
9. RandomAccessFile10. super class base class simple question11. what is overridden12. StringBUffer question


part 1: apptitute test -30question (20min)part 2: technical Test -30question (20min)
part 1:
1)find the range of x*x -5x+6>0X<=2 ; X >=3
2)if 5x*x+14*x+k=0 having two reciprocal roots find the value of k.

3&4)two sentence are given ,in between four sentence are given in change order . (like between 1 & 6 ,abcd four sentence are given 1 a b c d 6)
Find the correct order?
5)if first term of AP is 5 .16th term is 45.find the sum of first 16 terms.
6)x,y and z are odd no. not necessarly in sequence.then y=? (1)mean of x and z is 114. (2)mean of y and z is 113. Ans: 115
7)ram is 27 year old then mohan.after 7 year ram age is thrice as mohan age .find ram age?Ans : 67/2
8)if three tapes are filling a tank of capacity of 500lit with speed of 30lit/sec,48lit/sec and 36lit/sec. Find after how long time tank will fill?Ans : 500/114
9)find the root of given eq x-2/(x-1)=1-2/(x-2) if possible.Ans : x = 0
10)find the point of intersection of \ 15x+9y=15 5x+3y=21 Ans : NO
11)suppose in a pot 20 cards are there label 1-20 on that. find the probability of getting two prime.
Ans : 8/20 = 2 / 5
12)in an island three persons are there Jam ,Dam and Sam .sam having pencil,dam having cap and Jam having book .we have find who is author among them if. (1)Sam says ,Jam is author but author wearing cap. (2)Dam says ,I am author ,but author not having cap. (3)Sam says, I am author ,but author having note book. Find who is author? Ans : jam
13)Jo ,Do and So are three person.(1) So says Jo is football player, I also football player.(2) Do says Jo is football player, I also football player.(3) Jo says Do is football player, I also football player.Find the football player player among them.
Ans : jo

14-16)question based analogy . like LION:CUB find the pair in given choice.
17)in a basket 3 mangos,4 apples and 4 bananas are there. Find no of ways we select randomly 3 fruit from basket?
18) if a^x=b^y=c^z and b^2=ac then find x+z/xz=? Ans : 2/y
19)(loga)^2-(logb)^2 = ?
ans :- logab-loga/b
20)in a 60 liters of mixture of spirit and water is 7 %. in order to make water 19%,how much water should be added.(some thing like this)
21-25)A one and half page length passage will be given and 4 to 5 questions will be asked based on this passage.
26)
technical part:-==================pattern: 1) pl/sql--->7 quest 2) java--->5 quest 3) c & pointers--->9 quest 4) dbms and dfd's--->5 quest 5) ds--->4 quest
some quest are here:-
1.what is not a c- storage class
Ans.stack
2.if dba creates one user what are the privilages the user will get?
3. which keyword is used to const in java Ans. final
4.char *array[4]={"some string"}printf("%d",&amp;array[4]-(array));
Ans.4
5.remote object will be in the package
Ans.java.net (verity it)
6.#define sq(a) (a*a)printf ("%d",sq (3+2));
Ans.11
7.#define max 20printf ("%d", ++max);
Ans.lvalue required --- error

8.printf ("%d",sizeof (2>3?4?:4:3?4:2));(some thing like this)
Ans.syntax error
9. what is important of free().
10.property of constructor in java program.
11.impotance of macro.
12.underfolw condition of stack.
(1)empty,2)push,3)pop,4)none)====================
1)Which of the following is not a storage class in C?
Static Register Extern Stack
2)Which of the following 'return' statement is correct?
return, return; return(1, 2, 3); return(return 4); (return 5, return 6);
3)The second argument to fopen() function is?
char const char * int * FILE *
4)What is the output of the program?
#include
void main() { char buffer[10] = {"Genesis"}; printf(" %d ", &buffer[4]- (buffer)); }
3 4 0 Illegal pointer subtraction 4

5)If "arr" is an array of 5 x 5 dimension, arr[2][4] is same as
**(a+3+4) *(a+3)+*(a+4) **(a+3)+4 *(*(a+2)+4)


-----------------------------------------------------APTITUDE 30 questions
Log37 1: ------- = ? ( Log67 ) 1 + Log32
2: log(a-b) = log a - log b; then a = ? (b/(b2+1));
3: 3 black 7 white balls ......... prob of drawing 2 white balls ? (7/15)
4: In a lock of 4 rings there r five characters howmany unsuccessful attempts can be made ? (624)...
5: sqrt(6+sqrt(6+sqrt (6 + .................))))) = ? 3
6: a solution is prepared by mixing two solution with sprit 20% & 60%...In what ration they should be mixed to get the 50% spritin resultant solution .(1:3)
7: X2 - (A-3)X +(A+3) = 0for what value of A the sum of square of roots will beleast ? (A=2);
8: 'a' number of persons work daily 'b' hours toproduce 'c' items. If 'd' persons walks away from the group what will be thenumber of hours to produce 'c' items. ? (ab/(a-d))
9: - 13 Passage
14 - 18 venn diagram.
19-22 picking based (VERBAL);
23-25 picking odd once out (words )
26: m = ax , n = ay mxny = a2(x+y) find 1/x + 1/y? (1)
27 xy - 2y - 6 =0;x <> 2 x >2 ...y is always postive.

28 The diameter of circle can be determined from 1.area.2.circumference.
Ans either of them..
29:
sum of 2 no. is 7 & product s 10 fnd larger number.
30:



--------------------------------------------------------
TECHNCAL :
It will be really tough. They will manly concentrate on PL/SQLJava.C.
1. Output of the following program is
main(){ int i=0; for(i=0;i<20;i++) g1="FirstString" g1="g();" file="export.dmp" indexfile="newrite.sql." ratio =" (Logical" log_archive_format =" arch" log_archive_dest =" path." name =" ''" item =" PARAMETER" module="old_lib.pll" userid="scott/tiger">> if fvar is null then <<>> svar := svar + 5 end if; End;
What will be the value of svar after the execution ? a] Error b] 10 c] 5 d] None of the above
Ans : A
52. Which of the following is not correct about an Exception ? a] Raised automatically / Explicitly in response to an ORACLE_ERROR b] An exception will be raised when an error occurs in that block c] Process terminates after completion of error sequence. d] A Procedure or Sequence of statements may be processed.
Ans : C
53. Which of the following is not correct about User_Defined Exceptions ? a] Must be declared b] Must be raised explicitly c] Raised automatically in response to an Oracle error d] None of the above
Ans : C


54. A Stored Procedure is a a] Sequence of SQL or PL/SQL statements to perform specific function b] Stored in compiled form in the database c] Can be called from all client environmets d] All of the above
Ans : D
55. Which of the following statement is false a] Any procedure can raise an error and return an user message anderror number b] Error number ranging from 20000 to 20999 are reserved for userdefined messages c] Oracle checks Uniqueness of User defined errors d] Raise_Application_error is used for raising an user defined error.
Ans : C
56. Is it possible to open a cursor which is in a Package in anotherprocedure ? a] Yes b] No
Ans : A
57. Is it possible to use Transactional control statements in DatabaseTriggers ? a] Yes b] No
Ans : B
58. Is it possible to Enable or Disable a Database trigger ? a] Yes b] No
Ans : A
59. PL/SQL supports datatype(s) a] Scalar datatype b] Composite datatype c] All of the above d] None of the above
Ans C
60. Find the ODD datatype out a] VARCHAR2 b] RECORD c] BOOLEAN d] RAW
Ans : B


61. Which of the following is not correct about the "TABLE" datatype ? a] Can contain any no of columns b] Simulates a One-dimensional array of unlimited size c] Column datatype of any Scalar type d] None of the above
Ans : A
62. Find the ODD one out of the following a] OPEN b] CLOSE c] INSERT d] FETCH
Ans C
63. Which of the following is not correct about Cursor ? a] Cursor is a named Private SQL area b] Cursor holds temporary results c] Cursor is used for retrieving multiple rows d] SQL uses implicit Cursors to retrieve rows
Ans : B
64. Which of the following is NOT VALID in PL/SQL ? a] Select ... into b] Update c] Create d] Delete
Ans : C
65. What is the Result of the following 'VIK'NULL'RAM' ? a] Error b] VIK RAM c] VIKRAM d] NULL
Ans : C
66. Declare a number := 5; b number := null; c number := 10; Begin if a > b AND a <> ( Select count(*) from Emp E2 where E1.SAL > E2.SAL ) will retrieve a] 3500,5000,2500 b] 5000,2850 c] 2850,5750 d] 5000,5750
Ans : A
72. Is it possible to modify a Datatype of a column when column containsdata ? a] Yes b] No
Ans B

73. Which of the following is not correct about a View ? a] To protect some of the columns of a table from other users b] Ocuupies data storage space c] To hide complexity of a query d] To hide complexity of a calculations
Ans : B
74. Which is not part of the Data Definiton Language ? a] CREATE b] ALTER c] ALTER SESSION
Ans : C
75. The Data Manipulation Language statements are a] INSERT b] UPDATE c] SELECT d] All of the above
Ans : D
76. EMPNO ENAME SAL A822 RAMASWAMY 3500 A812 NARAYAN 5000 A973 UMESH A500 BALAJI 5750
Using the above data Select count(sal) from Emp will retrieve a] 1 b] 0 c] 3 d] None of the above
Ans : C
77. If an UNIQUE KEY constraint on DATE column is created, will it acceptthe rows that are inserted with SYSDATE ? a] Will b] Won't
Ans : B
78. What are the different events in Triggers ? a] Define, Create b] Drop, Comment c] Insert, Update, Delete d] All of the above
Ans : C79. What built-in subprogram is used to manipulate images in image items ? a] Zoom_out b] Zoom_in' c] Image_zoom d] Zoom_image
Ans : C
80. Can we pass RECORD GROUP between FORMS ? a] Yes b] No
Ans : A
81. SHOW_ALERT function returns a] Boolean b] Number c] Character d] None of the above
Ans : B
82. What SYSTEM VARIABLE is used to refer DATABASE TIME ? a] $$dbtime$$ b] $$time$$ c] $$datetime$$ d] None of the above
Ans : A
83. :SYSTEM.EFFECTIVE.DATE varaible is a] Read only b] Read & Write c] Write only d] None of the above
Ans : C
84. How can you CALL Reports from Forms4.0 ? a] Run_Report built_in b] Call_Report built_in c] Run_Product built_in d] Call_Product built_in
Ans : C
85. When do you get a .PLL extension ? a] Save Library file b] Generate Library file c] Run Library file d] None of the above
Ans : A
86. What is built_in Subprogram ? a] Stored procedure & Function b] Collection of Subprogram c] Collection of Packages d] None of the above
Ans : D
87. GET_BLOCK property is a a] Restricted procedure b] Unrestricted procedure c] Library function d] None of the above
Ans : D
88. A CONTROL BLOCK can sometimes refer to a BASETABLE ? a] TRUE b] FALSE
Ans : B
89. What do you mean by CHECK BOX ? a] Two state control b] One state control c] Three state control d] none of the above
Ans : C - Please check the Correcness of this Answer ( The correct answeris 2 )
90. List of Values (LOV) supports a] Single column b] Multi column c] Single or Multi column d] None of the above
Ans : C
91. What is Library in Forms 4.0 ? a] Collection of External field b] Collection of built_in packages c] Collection of PL/SQl functions, procedures and packages d] Collection of PL/SQL procedures & triggers
Ans : C
92. Can we use a RESTRICTED packaged procedure in WHEN_TEXT_ITEM trigger ? a] Yes b] No
Ans : B

93. Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ? a] Yes b] No
Ans : B
94. What type of file is used for porting Forms 4.5 applications to variousplatforms ? a] .FMB file b] .FMX file c] .FMT file d] .EXE file
Ans : C
95. What built_in procedure is used to get IMAGES in Forms 4.5 ? a] READ_IMAGE_FILE b] GET_IMAGE_FILE c] READ_FILE d] GET_FILE
Ans A
96. When a form is invoked with CALL_FORM does Oracle forms issuesSAVEPOINT ? a] Yes b] No
Ans : A
97. Can we attach the same LOV to different fields in Design time ? a] Yes b] No
Ans : A
98. How do you pass values from one form to another form ? a] LOV b] Parameters c] Local variables d] None of the above
Ans : B
99. Can you copy the PROGRAM UNIT into an Object group ? a] Yes b] No
Ans : B
100. Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5 ? a] Yes b] No
Ans : A
101. When is a .FMB file extension is created in Forms 4.5 ? a] Generating form b] Executing form c] Save form d] Run form
Ans : C
102. What is a Built_in subprogram ? a] Library b] Stored procedure & Function c] Collection of Subprograms d] None of the above
Ans : D
103. What is a RADIO GROUP ? a] Mutually exclusive b] Select more than one column c] Above all TRUE d] Above all FALSE
Ans : A
104. Identify the Odd one of the following statements ? a] Poplist b] Tlist c] List of values d] Combo box
Ans : C
105. What is an ALERT ? a] Modeless window b] Modal window c] Both are TRUE d] None of the above
Ans : B
106. Can an Alert message be changed at runtime ? a] Yes b] No
Ans : A
107. Can we create an LOV without an RECORD GROUP ? a} Yes b] No
Ans : B

108. How many no of columns can a RECORD GROUP have ? a] 10 b] 20 c] 50 d] None of the above
Ans D
109. Oracle precompiler translates the EMBEDDED SQL statemens into a] Oracle FORMS b] Oracle REPORTS c] Oracle LIBRARY d] None of the above
Ans : D
110. Kind of COMMENT statements placed within SQL statements ? a] Asterisk(*) in column ? b] ANSI SQL style statements(...) c] C-Style comments (/*......*/) d] All the above
Ans : D
111. What is the appropriate destination type to send the output to aprinter ? a] Screen b] Previewer c] Either of the above d] None of the above
Ans : D
112. What is TERM ? a] TERM is the terminal definition file that describes the terminalfrom which you are using R20RUN ( Reports run time ) b] TERM is the terminal definition file that describes the terminalfrom which you are using R20DES ( Reports designer ) c] There is no Parameter called TERM in Reports 2.0 d] None of the above
Ans : A
113. If the maximum records retrieved property of a query is set to 10,then a summary value will be calculated a] Only for 10 records b] For all the records retrieved c] For all therecords in the referenced table d] None of the above
Ans : A
114. With which function of a summary item in the COMPUTE AT optionrequired ? a] Sum b] Standard deviation c] Variance d] % of Total function
Ans : D
115. For a field in a repeating frame, can the source come from a columnwhich does not exist in the datagroup which forms the base of the frame ? a] Yes b] No
Ans : A
116. What are the different file extensions that are created by OracleReports ? a] .RDF file & .RPX file b] .RDX file & .RDF file c] .REP file & .RDF file d] None of the above
Ans : C
117. Is it possible to Disable the Parameter form while running the report? a] Yes b] No
Ans : A
118.What are the SQL clauses supported in the link property sheet ? a] WHERE & START WITH b] WHERE & HAVING c} START WITH & HAVING d] WHERE, START WITH & HAVING
Ans : D
119. What are the types of Calculated columns available ? a] Summary, Place holder & Procedure column b] Summary, Procedure & Formula columns c] Procedure, Formula & Place holder columns d] Summary, Formula & Place holder columns
Ans.: D
120. If two groups are not linked in the data model editor, what is thehierarchy between them? a] There is no hierarchy between unlinked groups b] The group that is right ranks higher than the group that is to theleft c] The group that is above or leftmost ranks higher than the groupthat is to right or below it d] None of the above
Ans : C
121. Sequence of events takes place while starting a Database is a] Database opened, File mounted, Instance started b] Instance started, Database mounted & Database opened c] Database opened, Instance started & file mounted d] Files mounted, Instance started & Database opened
Ans : B
122. SYSTEM TABLESPACE can be made off-line a] Yes b] No
Ans : B
123. ENQUEUE_RESOURCES parameter information is derived from a] PROCESS or DDL_LOCKS & DML_LOCKS b] LOG BUFFER c] DB_BLOCK_SIZE d] DB_BLOCK_BUFFERS
Ans : A
124. SMON process is used to write into LOG files a] TRUE b] FALSE
Ans : B
125. EXP command is used a] To take Backup of the Oracle Database b] To import data from the exported dump file c] To create Rollback segments d] None of the above
Ans : A
126. SNAPSHOTS cannot be refreshed automatically a] TRUE b] FALSEAns : B127. The User can set Archive file name formats a] TRUE b] FALSE
Ans : A
128. The following parameters are optional in init.ora parameter fileDB_BLOCK_SIZE, PROCESS a} TRUE b] FALSE
Ans : B129. NOARCHIEVELOG parameter is used to enable the database in Archievemode a] TRUE b] FALSE
Ans : B
130. Constraints cannot be exported through Export command? a] TRUE b] FALSE
Ans : B
131. It is very difficult to grant and manage common priveleges needed bydifferent groups of database users using roles a] TRUE b] FALSE
Ans : B
132. The status of the Rollback segment can be viewed through a] DBA_SEGMENTS b] DBA_ROLES c] DBA_FREE_SPACES d] DBA_ROLLBACK_SEG
Ans : D
133. Explicitly we can assign transaction to a rollback segment a] TRUE B] FALSE
Ans : A
134. What file is read by ODBC to load drivers ? a] ODBC.INI b] ODBC.DLL c] ODBCDRV.INI d] None of the above
Ans : A


1. precedence of PL/SQL2.in an employee table consisting of empid and supid to get supervisor id for employee (something like this related to ans. self join) we would useIntersectunionjoin subquery3.The order of execution in corelated queriesInner query executes first then outer query Outer query executes first then inner query each row of inner query is evaluated with outer queryeach row of outer query is evaluated with inner query4.declare i Number j Number k Numberbegin i:=0 for j = 1..5 i:=i+1; j:=j+1;k:=i+j+k;..........5.function of ROLLUP and CUBE6.Based on Group by clause rule that it should contain column found in select clause7.Can procedure in a package be overloaded8.public void static main(String []args){String s1=new String("test");String s2=new String("test");if(s1==s2)System.out.println("Both are equal");Boolean b1=new Boolean("true");Boolean b2=new Boolean("false");if(b1.equals(b2))System.out.println("some message");}output=?9.x=7;y=0;if(x=y)y=7;elsey=5;what is the value of y10.Threading in java a prg was given in which it had no exceptions and run function had string as its parametera.runtime errorb.compile time errorc.d.
11.what fuction can be repeated instead of comment....{public void aMethod(String S,int i);//here....}a.public void aMethod(int i ,String S);b.public void aMethod(String myobj,int j);c.public int aMethod(String S,int i);d.public void AMethod(String S,int i);12.Encapsulation is implemented bya.private variables and public methodsb.private variables and private methodsc.public variables and public methodsd.protected members13.Based on scope of a variable14.Recursive fuction are used to a.call itselfb.call other functionsc.return integersd....15.int a[]={0,1,2,3,4,5}int *pa=a;which of the following is not the correct way to accessa.a[5]b.*(a+5)c.*(pa+5)d.*(*pa+5)16.struct{char emp[12];int mpno;}e;struct e a[2]={{jack,2},{raj,8},{jill,2}}struct e *p;*p=a;p+=2......17.AVL tree is a balanced binary search tree18.order of B+tree19.Disadvantage of indexed sequential file20.queue can be called as full even if its capacity is'nt