Aricent Interview of Isha Gupta

1. Tell me about yourself.
2. Wat is your favorite subject (I replied DBMS and OS)
3. Wat is referential integrity constraint?
4. Wat is normalization all about?
5. Give an example of insertion anomaly. (Since I mentioned it in the answer to the previous ques).
6. Which RDBMS have have you worked on?
7. Are there other types of DBMS also? (I mentioned ODBMS and explained it giving its advantages over RDBMS).
8. Give a disadvantage of ODBMS.
9. Is an RDBMS useful in case of BLOBs(Binary Large OBjects)?

Next he came to 'C' programming lang:
10. Write d structure of link list and write a program to sort d link list. (I gave the code for bubble sort)
11. He asked if dere is a more efficient way.
12. Suppose i have a tree with thousands of nodes and we have to search a     value. Is this a CPU- intensive task or memory-intensive task? Consider both the cases- DFS and BFS.

Next ws Networking:
13. How will two processes on different computers communicate? Basically he wanted to ask dat how will i recognize for which process the packet is meant, as dere will b many processes running on a computer. (He was indicating towards socket programming).
14. How does a URL get converted to an IP address?
15. Where is the DNS stored?
16. Dere may b many DNSs.. how will ur computer know which DNS to contact?

OS:
17. Wat is PCB? (dat was all from OS)

18. You have written some code/program and delivered it to d customer. Now u dont have the source code with u. The program is not working fine at the customer's place. How will u catch the bug?(remember u dont have the source code wid u).

19. You have written a C-program on ur system. will it be portable to any other system? What all aspects determine whether a program will be portable or not?
20. Why is java code portable?
21. Have you done assembly language programming? (He said- "you shud do it")
22. Have you studied compilers in your Msc/Bsc?


Software Engg:
23. How will u test the software that you have developed? (I discussed white box and black box testing)
24. Are both of them necessary or are they alternatives?

HR ques:
25. You are working in a team in which some people are slow workers and some are fast workers. How will you manage?
26. Again you are working in a team. You gave an approach/algorithm to solve a prob. Another member presented his approach which you think/know is incorrect. How will you convince other team members or how will you justify your approach?