16-04-2012, 12:49 PM
AMDOCS
Amdocs.doc (Size: 224.5 KB / Downloads: 146)
Guys most of the AMDOCS tests are conducted by MERTITTRACK and would most probably be online
Aptitude Part Consist of 6 sections:
• Quantitative Aptitude
• Attention to Details
• Technical Passage
• Programming Ability Test
• SQL
• UNIX
Quantitative Aptitude: 20 Q : 25min
Venn diagrams,DS,some questions on average,2 Logical Reasoning Caselets each comprising of 4-5 questions.
Attention to Details:15Q 15min
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.
Technical passage: 10 Q :15 min
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.
Programming Ability Test (c / c++ / java): 20Q : 25min
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.
SQL: 15Q :15min
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)
UNIX: 15Q :15min
Basic commands tee,chmod would always be asked,tail,head,cut,paste,sed,vi editor internal commands(i,I,a,A..),grep,chgrp ,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. 95Q : 120 MIN
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.
Exam/Interview Date:21-Apr-2011
No of Rounds : Aptitude Test
Contributor Name: Yogendra
Paper: Amdocs Placement Paper (Verbal, Quantitative, SQL, C, Unix etc)
1. All fat people are not dancers, food loving people are all fat .Find the contradictory statement?
2. The day before yesterday was WEDNESDAY then the day after 2morrow is?
3. A goes to the party if B goes
B goes to the party if C goes
C goes to the party if D goes
Totally how many will go to the party?
4. Mary's father's brother is Andrews Andrews daughter's son is Sunil Brothers name is Sam Who is Sam to Sunil?
5. If A>B,A<C,B>D,B<DFind the Shortest?
6. There are A,B techers and C,D doctors.Find the possible no of combinations that should not be repeated more than once?
7. There are 3 males and 2 females,find the possible no of orders that can be made by making the arrangement as in between two males one women is allowed to sit?
8. Computer checking:eeeDD
1.eeggg 2.eeeDD3.eerrt,4.DDeee The write answer is 2)eeeDD
9. The syntax of command statement in UNIX
10. If the permission for a file is 000,then the file can be accessed by whom?
11. Where we can run two same programs on a UNIX console at the same time?
12. Which is the Shell of UNIX?
13. Wat is the number of the masked code ee@?
14. We are UPDATING a field in SQL and ALTER the row also.After giving the COMMIT command the system is crashed.Wat will happen to the commands given,whether it will UPDATE and ALTER the table r not?
15. If we r terminated at the middle of the program execution in UNIX,wat will happen to the program,it will continue running r terminate r the o/p will be send to ur mail?
16. How will add additional conditions in SQL?
17. How will u print TATA alone from TATA POWER using string copy and concate commands in C?
18. If switch(n)
case 1:printf("CASE !");
case(2):printf("default")
break;
What will be printed?
19. How will u divide two numbers in a MACRO?
20. int a,b;
1.main()
2.{
3.scanf("..",&a,&b);
4.if...{
5.printf("Print A");
6.else
7.Printf("...");
8.endif}
9..
A.Wat will come in the 9 dash?
B.Wat will happen if we replace Print A as Print X?
C.Wat will come in the 3 dash?
D.Wat will happen if we interchange 4 and 7?
E.Wat will come in the 4 dash?