Java SQL UNIX Interview for 2 year experienced @ AMDOCS

by Sridhar Jammalamadaka on August 16, 2009


These questions were asked in a job posting at Amdocs, Pune. The job was for developers experienced in Java, SQL, UNIX. The interview lasted for 40 minutes. Answers to these questions would be posted soon. If you wish to answer any of these questions, please comment below, the Section Name, Question Number along with your Answer.

General Questions:

  1. Tell me about yourself?
  2. Tell me about the project that you are currently working on?
  3. What are the technologies used in your current project?
  4. Why did you change your previous company?
  5. Do you have any questions? (at the end of the interview)

Java Questions:

  1. On a scale of 5, how do you rate yourself in Java?
  2. What are the four pillars of Object Oriented Programming (OOPS)?
  3. What is Encapsulation?
  4. What is Abstraction?
  5. What is the difference between Encapsulation and Abstraction?
  6. What are access specifiers?
  7. Explain each of the access specifiers: public, default, protected and private.
  8. Is the default access specifier same as protected?
  9. Can I access a default member from inside a Sub class?
  10. Can I access a protected member from a Sub class outside the package of its Base class?
  11. What is an anonymous class? Can you write code to define an anonymous class?
  12. What is the difference between a String and a StringBuffer?
  13. What is the output upon execution of the following code snippet?
    14. String a = "Hello";
StringBuffer b = new StringBuffer("Hello");

if(a.equals(b)){
 System.out.println("Inside A");
}
else{
 System.out.println("Inside B")
}
  14. How to use a StringTokenizer?
  15. What are Collections in Java?
  16. What is the difference between a Vector and an ArrayList?
  17. Can you write a program that emulates a Linked List in Java without using the class LinkedList?
  18. What is a thread in Java?
  19. What are the uses of threads?
  20. What is a process in Java?

Java EE Questions:

  1. Do you know Java EE?
  2. On a scale of 5, how do you rate yourself in Java EE?
  3. Do you know EJB?
  4. What is Life Cycle of a Servlet?
  5. What are the methods in the Class GenericServlet?
  6. What is the difference between GenericServlet and HttpServlet?

SQL Questions:

  1. On a scale of 5, how do you rate yourself in SQL?
  2. What is DDL?
  3. What is DML?
  4. What is the difference between DDL and DML?
  5. Assume there is a table by name Employee, that has columns emp_name, emp_id and salary.

    6. Write a query that prints emp_name of the employee earning the maximum salary.

UNIX Questions:

  1. On a scale of 5, how do you rate yourself in UNIX?
  2. Explain the command mv?
  3. Explain the command cp?
  4. What is the difference between mv and cp?
  5. How to use grep command?
  6. What command do you use to see all the processes that are running in UNIX?
  7. Do you know shell scripting?

Read 15 more Java interview questions asked in Amdocs.

You may want to

Answer these questions by commenting below

About the Author:  Sridhar Jammalamadaka is the Editor of Interview Mantra. He's a typically non-typical Software Engineer from Pune, India. He likes entrepreneurship, web technologies and Micro Controller programming. He enjoys playing cricket and piano (but rarely does these activities). Through this website, he wishes to gather a large community of aspiring engineers, entrepreneurs and professionals from all parts of the globe. You can connect with him on Facebook - http://www.facebook.com/sridhar.j

2,274 readers have already subscribed to email updates!

Enter your email address:

Tagged as: Interview Questions, Java

  • The Practical Idealist

    UNIX Questions:
    2. mv moves files / folders from one directory to another.
    3. cp copies files / folders from one directory to another.
    4. After a mv command, the original files / folders are removed from the source location; with cp, the files / folders are still available
    5. grep is used to find strings within files. E.g., grep “a*” somefiles*.txt will find all multiple occurrences of the letter “a” from all files that start with the name “somefiles” and end with a “txt” extension.
    6. ps is the command to view processes. To see all the processes that are running, use ps -a, or ps -e depending on what flavor of UNIX you#39;re running.

  • http://www.maheshj.info/ The Practical Idealist

    SQL Questions:
    2. DDL – data definition language. Set of commands that are used to create / alter tables, table structures and databases.
    3. DML – data manipulation language. Set of commands that are used to modify / retrieve / insert data into tables.
    4. DML is all about changing the very structure of databases, whereas DML is concerned only about the data.
    5. In PL-SQL, this could be (though I may be wrong):
    select emp_name from employee where salary = (select max(salary) from employee);

  • Samrat

    Thank you .. I am appearing for the same interview in couple of days ..

    This orients me to the level of questions asked !

  • http://www.interviewmantra.net sridhar

    Glad that it helped you. Good luck for your interview

    –Interview Mantra

  • Anonymous

    Man u rock none of the site I visited has given that much systematic contents as at urs.
    Thanks

  • http://www.interviewmantra.net sridhar

    @Anonymous, your encouragement means a lot to us. Thanks! Keep visiting this blog, will put more useful interview related stuff in near future.

    -The Editor

  • pamitra

    Hi,

    Thanks a lot. i went through all the java questions listed above as a last minute revision before an interview i just attended with amdocs and most of these questions were asked.

    It was a great help. In addition to it, following are some of the questions asked to me:

    1. where and why do we use the synchronized keyword?
    2. give example of polymorphism with code?
    3. what are the classes and interfaces used in Collection framework, breifly explain them?
    4. what are inner classes and why do we need them?
    5. Do we name the java file using the Outer class’s name?
    6. how to access the inner class?
    7. Why do we need an abstract class from design perspective?
    8. difference between keywords and variables?
    9. what is the deployment process of your application?
    10. explain MVC?
    11. which sre the components in your application that correspond to Model View and Controller components?
    12. which application server do u use to deploy your app?
    13. what database do u use and how do u connect to the database?
    14. what is JNDI?
    15. what is EJB?
    16. what do u mean by serialization? how do we achieve it in java?

  • admin

    Hi Pamitra,
    Thanks a ton for sharing the questions asked in your interview with AMDOCS company. Good luck for your selection. Keep visiting us.

    –Interview Mantra

  • soniyo

    thnk u all , great help.

  • admin

    Welcome! If you are yet to attend the interview with Amdocs, our best wishes to you.

  • Vijay Anand

    1. On a scale of 5, how do you rate yourself in SQL?
    Answer: How much you are confident with this technology just rate yourself based on to that and then answer this question. Remember rating should be justifiable.
    2. What is DDL?
    Answer: DDL stands for Data Definition Language and it is used to define the definition of Oracle Objects. For example Create, Alter, Drop, Truncate are DDL statements.
    3. What is DML?
    Answer: DML stands for Data Manipulation Language and is used to perform the manipulation with the data. Insert Update and Delete are the DML statements available in Oracle.
    4. What is the difference between DDL and DML?
    The main difference is:
    DDL statements are Auto Committed whereas DML statements are not auto committed.
    5. Assume there is a table by name Employee, that has columns emp_name, emp_id and salary.

    Write a query that prints emp_name of the employee earning the maximum salary.

    select emp_name from Employee where salary = (select max(salary) from Employee)

  • admin

    @Vijay Anand, Excellent answers! Thanks.

  • http://asd shirish

    sad

  • Apurv

    select emp_name, max(salary)
    from Employee
    group by emp_name

    I think … this should work ….

  • http://www.codeofcoders.com Chetan Pagar

    Thank you friends… It’s really great help…

    Regards,
    Chetan Pagar,
    http://www.codeofcoders.com
    http://www.javadevforum.com

  • Abhimaniu

    Hello everyone,

    I have one query……..i have to appear for amdocs interview in some time from now……i am good at java but not so much at sql and unix……so my question is ….do they take ppl good at java only….

Previous post:

Next post: