Techno World Inc - The Best Technical Encyclopedia Online!

Accenture Test Paper :81

 Paper Type     : Whole Testpaper
 Test Date        : 19  August  2004
 Test Location  : CUSAT, COCHIN


    CUSAT campus on 19th august 2004.

      DBMS

   1.

      data model is
       a) Entity b) Constriants c) Entity relationship d) All the above
        ans:- c

   2.

      Choise the correct one select emp.name ,emp.age from emp1,emp2 where emp.sno = 456;
        a) cluster   b) non-cluster c) index   d) none of these

   3.

      What is index?
        a) atrendum selectio of colum
          ans) a

   4.

      Match the following
        1- one to one      a) manager to employ
        2- one to many    b) employ to employ
        3- many to one    c) unique object
        4- many to many d) employ to manager
         a) 1-a ,2-b ,3-c,4-d b) 1-c,2-d,3-a,4-b c) 1-c,2-a,3-d,4-b d) 1-d,2-b,3-a,4-c           ans) c

   5.

         
      1    max    222
      2    allen    333
      3    rony    444

      Select first.name from first where first.age = (select first.age from first where first.sno = 3);
        a) max   b) allen   c) rony   d)  noneof these

   6.

      THERE were 3 question on same type of queries(u should be good in foreign key relationship and relationship with in a single table).

   7.

      One question was based on INDEX

   8.

      Also one more mapping relationship given based upon the figure.

      REASONING

   9.

      Questions based upon equality of number’s …means  three no’s given ……
        a) if all equal
        b) if 1,2 same
        c) if 2,3 same
        d) none…..
        DAM –easy

  10.

      Questions based upon equality of symbols …means if + means * and * means / and – means + and + means –
      then mean of 28*40/4+2-6

  11.

      Question upon set theory means   if 100 r selecting in maths and 90 in physics 120 in chemistry & 22 in phy& maths both ,33 in maths & chemisty both 44 in ches & phy…11 in all  then

       1.

          How many only in maths…….
       2.

          Only in physics…
       3.

          Only in chemistry…….
       4.

          How many in atleast 2……

        C

  12.

      Question on pointers

  13.

      On file handling…

  14.

      On functions….

  15.

      Structures and unions

  16.

      From bitwise

         C++

  17.

      Inheritance

  18.

      Scope of protected

  19.

      Static member function

  20.

      File handling

  21.

      Copy constructor


         HR – Interview

  22.

      If u have any question then ask me…..( it was asked as a first question in interview from many….)

  23.

      UR family background…

  24.

      UR education background…

  25.

      If i will not select u then what u will do ????

  26.

      Tell me abt urself.

  27.

      what u think…u should devolp in urself..

  28.

      why u want to join accenture…


        Technical  Interview

  29.

      What is the need of normalisation in data base.

  30.

      1-5 all normalise forms( from many they directly asked 4th and 5th normanilise..(mostly from m.c.a.’s)

  31.

      What is semafore in o.s.

  32.

      What is paging and demand paging.

  33.

      How memeory works in a computer system.

  34.

      How recursion works in c

  35.

      Which data structure used in recursion.

  36.

      deference between structure n union.

  37.

      What is erp…..(accenture having work in erp…as we m.c.a’s having erp in 3rd sem so…the person highlighted or wrote sth in resume ,they asked abt erp from them only).

  38.

      What is reengineering in erp

  39.

      If u have too much cash in ur hand, then what u will do in behalf of the company…..