Amdocs

Guys most of the Amdocs tests are conducted by Mertitrack and would most probably be online. So keeping this in mind this page contains a link which contains an online sample paper of Amdocs and resembles very much with the actual test. But do study the text given here as pattern is not correctly given in sample paper.

Remember there would be 6 subjects sections comprising of

1. Quantitative aptitude: 20 questions, 25 mins

(Venn diagrams, DS, Some questions on average, 2 Logical Reasoning Caselets each comprising of 4-5 questions)

2. Attention TO detail (Easiest Section of paper): 15 questions 15 mins

(Pattern matching, arithmetic operators substitution (if + is *), 2 Decision making questions each comprising of 4-5 questtions.) This section in sample paper comprise mostly of pattern matching questions which is not the case in actual paper and would follow the above pattern.

3. Technical passage: 10 questions, 15 mins

(This sub-section comprise of a technical passage (USB, Cookies, Computer N/w, File Organization, O.S etc) and is followed by 10 questions. Don't commit the mistake of reading the whole passage as all the questions are direct, so just browse through the passage.)

4. Programming ability test (C / C++ / Java): 20 questions, 25 mins

I would recommend you to choose between C and C++ as Java was quite difficult and remember that based on your language selection in this test you would be asked question in technical interview.

5. SQL (Toughest section of paper): 15 questions, 15 mins

This is indeed the toughest section of the paper. There can be things which you must have not heard of earlier. Remember questions given in sample paper are quite different from what actually appears in paper

Questions asked are mainly based on:

1. Index (Clustered, Non Clustered)
2. Views (Updateble and read only views, How they are internally stored)
3. Where condtion involving columns that contain NUll values (so in this case you must remember how AND and OR operators work on NULL values)
4. INSERT statements to a table.
5. Some built in functions (Decode(), Substr(), Instr() )
6. Nested queries
7. Join operations (involves ANSI AND THETA notations)
8. Result of a Query (A table schema would be given and you would be  required to determine what would be its output whether it contains any error)

9. Error Correction in a Query i.e what should be modified to make a query run succesfully.
This mainly comprise of errors in group by, having clause, joins (for e.g. Joining two tables without any condition although is correct but would not yield the result)

Books: Ivan Bayross SQL, PL/SQL the Programming Language of Oracle.

6. UNIX: 15 questions, 15 mins

Basic commands
Tee, chmod (would always be asked), tail, head, cut, paste, sed, vi editor internal commands(i, I, a, A), grep, etc.

System calls
May or may not be asked.
Do remember meaning of special symbols such as $$,$!,$#,$*,$1 etc.
Books: Unix Concepts and Application by Sumitabha Das, Test Your Unix Skills by Yashwant Kanetkar.

Overall
1. 95 questions: 120 mins
2. 25% negative marking would be definitely present.

3. Need to score 60% Overall marks in Aptitude portion comprising of Quantitave Ability, Attention to detail and Learning ability (Technical Passage).

4. Need to score 60% Overall marks in SQL, UNIX, (C/ C++ / Java).

Amdocs had 6 sections:-
1. General Aptitude
2. Paying Attention
3. Learning ability
4. Java/ C++/ C
5. SQL
6. UNIX

First three sections were extremely easy. Try to score max. of these three sections.
Questions on Java were easy but covered vast concepts like OOPS. 1-2 questions were asked each from threading. exceptions, inner classes and collections.
SQL was bit difficult. You must know about views thoroughly. Just an overview might not be enough.
I didnt know anything about
UNIX. But other candidates were saying that it was easy only.
If you score more than 65 % overall you will get through.
In all there were 95 questions which have to be done in 120 minutes..
If you know techica; well (or do not know what to do in a particular section :)) time well be enough..
From about 600 students that gave the exam 49 were selected for the interviews. Luckily I was one of them. We recieved the call for interviews on 13 October and interviews were held on 16 October in their Office at Gurgaon...

Technical Interview panel was very cool.. They try to make you fully comfortable..

Q. Tell me about yourself

Q. What have you done in past months.

Q. Then in Java they asked about OOPS concepts.

Q. In different ways overloading can be implemented.

Q. Can main function be used more than once in java

Q. How many catch blocks can be put after try block

Q. What should be the order of preference for that

Q. Memory management in java

Q. Use of finalize function

Q. What project did you made in curriculum

Q. Why did you choose that?

Q. Innovative ideas that you putin that?

Q. Then a littlle code about project.

Q. What are the DDL, DCL, DQL, DML querries

Q. Difference between delete and drop?

Q, Joining a table?

Q. Different type of joins

Q. List 10 UNIX commands brethlessly..

Q. What are your likes and dislikes?

Q. What type of music deo you like?

Q. Sing a song for us?
Q. Solve this puzzle in 1 minute( Was not able to solve it)
The interview went for about 45 minutes. If you give 70% questions right you will be through. Results were announced about 4 hours later.. 15 students were selected for the HR round..

HR round
Q. Tell me about yourself
Q. Strengths nd weaknesses. Why?
Q. Achievements in life
Q. Why amdocs?
HR was like formality only. Around 12 students were finally selected.. With God's grace I was one of them We were given offer letters on the same evening.