Java SQL UNIX Interview for 2 year experienced @ AMDOCS

Your mantra to job success

Warning: This website contains electrifying content that may motivate you to work hard to get your dream job

Hello, you can subscribe us by E-mail, or Follow us on Twitter.

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:

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

Java Questions:

On a scale of 5, how do you rate yourself in Java?
What are the four pillars of Object Oriented Programming (OOPS)?
What is Encapsulation?
What is Abstraction?
What is the difference between Encapsulation and Abstraction?
What are access specifiers?
Explain each of the access specifiers: public, default, protected and private.
Is the default access specifier same as protected?
Can I access a default member from inside a Sub class?
Can I access a protected member from a Sub class outside the package of its Base class?
What is an anonymous class? Can you write code to define an anonymous class?
What is the difference between a String and a StringBuffer?
What is the output upon execution of the following code snippet?

String a = "Hello";
StringBuffer b = new StringBuffer("Hello");

if(a.equals(b)){
 System.out.println("Inside A");
}
else{
 System.out.println("Inside B")
}

How to use a StringTokenizer?
What are Collections in Java?
What is the difference between a Vector and an ArrayList?
Can you write a program that emulates a Linked List in Java without using the class LinkedList?
What is a thread in Java?
What are the uses of threads?
What is a process in Java?

Java EE Questions:

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

SQL Questions:

On a scale of 5, how do you rate yourself in SQL?
What is DDL?
What is DML?
What is the difference between DDL and DML?
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.

UNIX Questions:

On a scale of 5, how do you rate yourself in UNIX?
Explain the command mv?
Explain the command cp?
What is the difference between mv and cp?
How to use grep command?
What command do you use to see all the processes that are running in UNIX?
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

You can share this post on Twitter , or save it in your Delicious bookmark.

#12 admin

@Vijay Anand, Excellent answers! Thanks.

10/05/20 16:45

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

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

10/05/20 10:00

#10 admin

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

10/03/14 12:32

#9 soniyo

thnk u all , great help.

10/03/13 20:36

#8 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

10/02/19 14:55

#7 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?

10/02/19 13:50

#6 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

09/09/22 23:45

#5 Anonymous

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

09/09/21 17:14

#4 sridhar

Glad that it helped you. Good luck for your interview

09/09/01 17:12

#3 Samrat

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

This orients me to the level of questions asked !

09/09/01 17:11

#2 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);

09/08/20 22:13

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

09/08/20 21:58

Interview Mantra

Your mantra to job success