3i INFO TECH INTERVIEW QUESTIONS

1. 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

2. Which program construct must return a value?
a) Package b) Function c) Anonymous block d) Stored Procedure
e) Application Procedure Ans: b

3. 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

4. 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

5. 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

6. What was the first name given to Java Programming Language.
a) Oak - Java b) Small Talk c) Oak d) None Ans:a

7. 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)

8. 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)

9. 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)

10. 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)

11. 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)

12. 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)

13. 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)

14. 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)

15. 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

16. 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)

17. 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)

18. 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)

19. 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)

20. How many bonds are present in CO2 molecule?
(a) 1 (b) 2 (c) 0 (d) 4 Ans: (d)


Verbal

1. (a) cheerleaders : pompoms
(b) audience:seats
(c) team:goalposts
(d) conductor:podium
(e) referee:decision
Ans: (a)

2. archipelago:islands::
(a) arbor:bower (b) garden:flower (c) mountain:valley (d) sand:dun
(e) constellation:star Ans: (a)

3. crow:boastful ::
(a) smirk:witty (b) conceal:s;y (c) pout:sulky (d) blush:coarse
(e) bluster:unhappy Ans: (a)

4. bracket:shelf ::
(a) hammer:anvil (b) girder:rivet (c) strut:rafter (d) valve:pipe
(e) bucket:well Ans: (a)

5. taxonomy:classification ::
(a) etymology:derivation (b) autonomy:authorization (c)
economy:rationalization (d) tautology:justification
(e) ecology:urbanization Ans: (a)

6. moderator:debate ::
(a) legislator:election (b) chef:banquet (c) auditor:lecture (d)
conspirator:plot (e) umpire:game Ans: (a)

7. glossary:words ::
(a) catalogue:dates (b) atlas:maps (c) almanac:synonyms (d)
thesaurus:rhymes (e) lexicon:numbers Ans: (a)

8. lumber: bear ::
(a) roost:hen (b) bray:donkey (c) waddle:goose (d) swoop:hawk (e)
chirp:sparrow Ans: (a)

9. celerity:snail :: (a) indolence:sloth (b) cunning:weasel (c)
curiosity:cat (d) humility:peacock
(e) obstinacy:mule Ans: (a)

10. wood:sand ::
(a) coal:burn (b) brick:lay (c) oil:polish (d) metal:burnish (e) stone:quarry
Ans: (a)

11. carpenter:saw ::
(a) stenographer:typist (b) painter:brush (c) lawyer:brief (d) runner:sneakers e) seamstress:scissors Ans: (a)

12. horns:bull ::
(a) mane:lion (b) wattles:turkey (c) antlers:stag (d) hooves:horse
(e) wings:eagle Ans: (a)

13. gullible:duped ::
(a) credible:cheated (b) careful:cautioned (c) malleable:moulded (d)
myopic:mislead e) articulate:silenced
Ans: (a)

14. marathon:stamina ::
(a) relay:independence (b) hurdle:perseverance (c) sprint:celerity (d)
job:weariness (e) ramble:directness
Ans: (a)

15. Skin:man ::
(a) hide:animal (b) jump:start (c) peel:potato (d) eat:food (e)
wool:cloth Ans: (a)

16. Bamboo:Shoot ::
(a) Bean:Sprout (b) Peas:Pod (c) Potato:Eye (d) Carrot:Root (e) Leaf:Stem
Ans: (a)

17.eflect:Missile ::
(a) Siege:Castle (b) Distract:Attraction (c) Protect:Honour (d) Drop:Catch
(e) Score:Goal Ans: (a)

18. Editor:magazine ::
(a) captain:ship (b) actor:movie (c) director:film (d) player:team
(e) jockey:horse Ans: (a)

19. Volcano : Lava ::
(a) Fault:earthquate (b) crack:wall (c) tunnel:dig (d) water:swim(e)
floor:polis Ans: (a)

20. Disregarded
(a) heed (b) hopeful (c) evade (d) dense Ans: (a)

21. Obviate
(a) becloud (b) necessitate (c) rationalize (d) execute Ans: (b)

22. Superficial
(a) profound (b) exaggerated (c) subjective (d) spirited Ans: (a)