About the interview
Only 2 memebers are there in the interview panel.I entered into the room and they offered me a seat and asked me for my resume and the interview printout.I handed it over to the guy.He looks into my resume and asked me ..
1) what is your qualification?
My answer: XX from X university
I guessed: Anyone who looks at my resume should ask one more
question, or atleast show interest in the qualification..because
that is different..but nothing happened
2) Can you introduce yourself?
My answer: I told what i am doing curently..as i am
experienced...and how i can fit ito the job..
My guess: they are expecting a very traditional answer...like i am Mr X..finished X degree and blah blah about personal details.
3)How can you relate your experience to the IT field?
My answer: I had experience in financial services..and told them how it is useful to the company as 3i is also in the same domain
offering its products and services.
My guess: They seem to have no idea about financial services and the type of work i am doing ..so a bit not satisfied.
4)Have you done any IT courses?
I told them what i have done..i have done an ERP course
panel response: I dont think there is nothing to learn in the ERP
My guess:If you know C++, Java then only they feel it is an IT
course.
5) what are your strenghts?
I told what i got..including the transferable skills which i can
bring from my previous job..
My guess: They are looking for hardcore technical skills
6)Do you have any questions?
I told Yes..and asked them about the training programme and the bond details..they havent told any thing about until i asked about it.
Now i am a bit disappoined about what they said about the bond.
That it..interview lasted about 6 to 8 minutes..same for
everyone!...same questions..some people are being asked on personal and about family details.There is nothing technical.
MY OPINION
Everyone who attended the interview are very much disapointed about the bond..many are of the opinion they wouldnt have attended the test if they mentioned the bond in the first place.
All those who got selected in the test are from BTech, Mtech,Btech +MBA backgrounds.I did nt find a single student from BSc background.Just they mentioned in the advert so that they will also pay the money...
Ok folks hope u got the details and think about the offer even u
make it in the interview..
Exclusively for 3I infotech
81. You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
a) CREATE INdEX emp_empno_idx ON employee, empno;
b) CREATE INdEX emp_empno_idx FOR employee, empno;
c) CREATE INdEX emp_empno_idx ON employee(empno);
d) CREATE emp_empno_idx INdEX ON employee(empno); Ans: c
82. Which program construct must return a value?
a) Package b) Function c) Anonymous block d) Stored Procedure
e) Application Procedure Ans: b
83. Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY
constraint and all depending constraints fromthe EMPLOYEE table?
a) ALTER TABLE employee dROP PRIMARY KEY CASCAdE;
b) ALTER TABLE employee dELETE PRIMARY KEY CASCAdE;
c) MOdIFY TABLE employee dROP CONSTRAINT employee_id_pk CASCAdE;
d) ALTER TABLE employee dROP PRIMARY KEY employee_id_pk CASCAdE;
e) MOdIFY TABLE employee dELETE PRIMARY KEY employee_id_pk CASCAdE;
Ans: a
84. Which three commands cause a transaction to end? (Chosse three)
a) ALTER b) GRANT c) DELETE d) INSERT e) UPdATE
f) ROLLBACK Ans: a ,b ,f
85. Under which circumstance should you create an index on a table?
a) The table is small.
b) The table is updated frequently.
c) A columns values are static and contain a narrow range of values
d) Two columns are consistently used in the WHERE clause join condition
of SELECT statements.
Ans:d
86. What was the first name given to Java Programming Language.
a) Oak - Java b) Small Talk c) Oak d) None Ans:a
87. A certain radioactive element A, has a half life = t seconds. In (t/2) seconds the fraction of the initial quantity of the element so
far decayed is nearly
(a) 29% (b) 15% (c) 10% (d) 45% Ans: (a)
88. Which of the following plots would be a straight line ?
(a) Logarithm of decay rate against logarithm of time
(b) Logarithm of decay rate against logarithm of number of decaying nuclei
(c) Decay rate against time
(d) Number of decaying nuclei against time Ans: (b)
89. A radioactive element x has an atomic number of 100.
It decays directly into an element y which decays directly into element z.
In both processes a charged particle is emitted.
Which of the following statements would be true?
(a) y has an atomic number of 102 (b) y has an atomic number of 101
(c) z has an atomic number of 100 (d) z has an atomic number of 101
Ans: (b)
90. If the sum of the roots of the equation ax2 + bx + c=0 is equal to the sum of
the squares of their reciprocals then a/c, b/a, c/b are in
(a) AP (b) GP (c) HP (d) None of these Ans: (c)
91. A man speaks the truth 3 out of 4 times. He throws a die and reports it to be a 6.
What is the probability of it being a 6?
(a) 3/8 (b) 5/8 (c) ¾ (d) None of the above Ans: (a)
92. If cos2A + cos2B + cos2C = 1 then ABC is a
(a) Right angle triangle (b) Equilateral triangle (c) All the angles are acute
(d) None of these Ans: (a)
93. Image of point (3,8) in the line x + 3y = 7 is
(a) (-1,-4) (b) (-1,4) (c) (2,-4) (d) (-2,-4) Ans: (a)
94. The mass number of a nucleus is
(a) Always less than its atomic number (b) Always more than its atomic number
(c) Sometimes more than and sometimes equal to its atomic number
(d) None of the above Ans: (c)
95. The maximum KE of the photoelectron emitted from a surface is dependent
on (a) The intensity of incident radiation (b) The potential of the collector
electrode (c) The frequency of incident radiation
(d) The angle of incidence of radiation of the surface Ans: (c
96. Which of the following is not an essential condition for interference
(a) The two interfering waves must be propagated in almost the same direction or
the two interfering waves must intersect at a very small angle
(b) The waves must have the same time period and wavelength
(c) Amplitude of the two waves should be the same
(d) The interfering beams of light must originate from the same source
Ans: (c)
97. When X-Ray photons collide with electrons
(a) They slow down (b) Their mass increases (c) Their wave length
increases (d) Their energy decreases Ans: (c)
98. An electron emits energy
(a) Because its in orbit (b) When it jumps from one energy level to another
(c) Electrons are attracted towards the nucleus
(d) The electrostatic force is insufficient to hold the electrons in orbits
Ans: (b)
99. An electron emits energy
(a) Because its in orbit (b) When it jumps from one energy level to another
(c) Electrons are attracted towards the nucleus
(d) The electrostatic force is insufficient to hold the electrons in orbits
Ans: (b)
100. How many bonds are present in CO2 molecule?
(a) 1 (b) 2 (c) 0 (d) 4 Ans: (d)
Verbal
1. Depreciation: deflation, depression, devaluation, fall, slump
2. Deprecate : feel and express disapproval,
3. Incentive : thing one encourages one to do (stimulus)
4. Echelon : level of authority or responsibility
5. Innovation : make changes or introduce new things
6. Intermittent : externally stopping and then starting
7. Detrimental: harmful
8. Conciliation : make less angry or more friendly
9. Orthodox: conventional or traditional, superstitious
10. Fallible : liable to error
11. Volatile : ever changing
12. Manifest: clear and obvious
13. Connotation : suggest or implied meaning of expression
14. Reciprocal: reverse or opposite
15. Agrarian : related to agriculture
16. Vacillate : undecided or dilemma
17. Expedient : fitting proper, desirable
18. Simulate : produce artificially resembling an existing one.
19. Access : to approach
20. Compensation: salary
21. Truncate : shorten by cutting
22. Adherence : stick
23. Heterogeneous: non similar things
24. Surplus : excessive
25. Assess : determine the amount or value
26. Cognizance : knowledge
27. Retrospective : review
28. Naive : innocent, rustic
29. Equivocate : tallying on both sides, lie, mislead
30. Postulate : frame a theory
31. Latent : dormant, secret
32. Fluctuation : wavering,
33. Eliminate : to reduce
34. Affinity : strong liking
35. Expedite : hasten
36. Console : to show sympathy
37. Adversary : opposition
38. Affable : lovable or approachable
39. Decomposition : rotten
40. Agregious : apart from the crowd, especially bad
41. Conglomeration: group, collection
42. Aberration: deviation
43. Augury : prediction
44. Creditability : ability to common belief, quality of being credible
45. Coincident: incidentally
46. Constituent : accompanying
47. Differential : having or showing or making use of
48. Litigation : engaging in a law suit
49. Moratorium: legally or officially determined period of delay before fulfillment of the agreement of paying of debts.
50. Negotiate : discuss or bargain
51. Preparation : act of preparing
52. Preponderant : superiority of power or quality
53. Relevance : quality of being relevant
54. Apparatus : appliances
55. Ignorance : blindness, in experience
56. Obsession: complex enthusiasm
57. precipitate : speed, active
58. corroborative: refutable
59. obnoxious : harmless
60. sanction: hinder
61. empirical: experimental
62. aborigine: emigrant
63. corpulent : emaciated
64. officious: pragmate
65. Agitator : Firebrand :: Renegade : Turncoat
66. Burst : Sound :: Tinder : Fire
67. Star : cluster :: Tree : clump
68. Piston : Cylinder :: elevator : shaft
69. Mitigate : punishment :: commute : sentence
70. Erudite : scholar :: illiterate : ignorant
71. Fire : Ashes :: explosion : debris
72. mason : wall :: Author : Book
73. Fire : Ashes :: Event : memories
74. (a) cheerleaders : pompoms
(b) audience:seats
(c) team:goalposts
(d) conductor:podium
(e) referee:decision
Ans: (a)
75. archipelago:islands::
(a) arbor:bower (b) garden:flower (c) mountain:valley (d) sand:dun
(e) constellation:star Ans: (a)
76. crow:boastful ::
(a) smirk:witty (b) conceal:s;y (c) pout:sulky (d) blush:coarse
(e) bluster:unhappy Ans: (a)
77. bracket:shelf ::
(a) hammer:anvil (b) girder:rivet (c) strut:rafter (d) valve:pipe
(e) bucket:well Ans: (a)
78. taxonomy:classification ::
(a) etymology:derivation (b) autonomy:authorization (c)
economy:rationalization (d) tautology:justification
(e) ecology:urbanization Ans: (a)
79. moderator:debate ::
(a) legislator:election (b) chef:banquet (c) auditor:lecture (d)
conspirator:plot (e) umpire:game Ans: (a)
80. glossary:words ::
(a) catalogue:dates (b) atlas:maps (c) almanac:synonyms (d)
thesaurus:rhymes (e) lexicon:numbers Ans: (a)
81. lumber: bear ::
(a) roost:hen (b) bray:donkey (c) waddle:goose (d) swoop:hawk (e)
chirp:sparrow Ans: (a)
82. celerity:snail :: (a) indolence:sloth (b) cunning:weasel (c)
curiosity:cat (d) humility:peacock
(e) obstinacy:mule Ans: (a)
83. wood:sand ::
(a) coal:burn (b) brick:lay (c) oil:polish (d) metal:burnish (e) stone:quarry
Ans: (a)
84. carpenter:saw ::
(a) stenographer:typist (b) painter:brush (c) lawyer:brief (d) runner:sneakers e) seamstress:scissors Ans:(a)
85. horns:bull ::
(a) mane:lion (b) wattles:turkey (c) antlers:stag (d) hooves:horse
(e) wings:eagle Ans: (a)
86. gullible:duped ::
(a) credible:cheated (b) careful:cautioned (c) malleable:moulded (d)
myopic:mislead e) articulate:silenced
Ans: (a)
87. marathon:stamina ::
(a) relay:independence (b) hurdle:perseverance (c) sprint:celerity (d)
job:weariness (e) ramble:directness
Ans: (a)
88. Skin:man ::
(a) hide:animal (b) jump:start (c) peel:potato (d) eat:food (e)
wool:cloth Ans: (a)
89. Bamboo:Shoot ::
(a) Bean:Sprout (b) Peas:Pod (c) Potato:Eye (d) Carrot:Root (e) Leaf:Stem
Ans: (a)
90. Deflect:Missile ::
(a) Siege:Castle (b) Distract:Attraction (c) Protect:Honour (d) Drop:Catch
(e) Score:Goal Ans: (a)
91. Editor:magazine ::
(a) captain:ship (b) actor:movie (c) director:film (d) player:team
(e) jockey:horse Ans: (a)
92. Volcano : Lava ::
(a) Fault:earthquate (b) crack:wall (c) tunnel:dig (d) water:swim(e)
floor:polis Ans: (a)
93. Disregarded
(a) heed (b) hopeful (c) evade (d) dense Ans: (a)
94. Obviate
(a) becloud (b) necessitate (c) rationalize (d) execute Ans: (b)
95. Superficial
(a) profound (b) exaggerated (c) subjective (d) spirited Ans: (a)
96. chief : tribe :: governer : state
97. epaulette : shoulder :: tiara : head
98. guttural : throat :: gastric : stomach
99. inept : clever :: languid : active
100. Erudite : scholar :: illiterate : ignorant
