Whole-Testpaper |   19698

Whole-Testpaper

 

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.     

    1max222
    2allen333
    3rony444

    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

  1. Question on pointers

  2. On file handling…

  3. On functions….

  4. Structures and unions

  5. From bitwise

       C++

  6. Inheritance 

  7. Scope of protected 

  8. Static member function

  9. File handling

  10. Copy constructor


       HR – Interview

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

  12. UR family background…

  13. UR education background…

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

  15. Tell me abt urself.

  16. what u think…u should devolp in urself..

  17. why u want to join accenture…


      Technical  Interview

  18. What is the need of normalisation in data base.

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

  20. What is semafore in o.s.

  21. What is paging and demand paging.

  22. How memeory works in a computer system.

  23. How recursion works in c

  24. Which data structure used in recursion.

  25. deference between structure n union.

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

  27. What is reengineering in erp

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

feedback