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.
Books to look for exploring C, test your skills in C, Pointers in C
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)
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)
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.
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.
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).