Amdocs Software Engineer, Associate interview questions

Round 1: It had 5 sections for a duration of 2 hrs. Each section had its own time limit, and we could not go back to the previous section. Aptitude: It consisted of typical questions on quantitative and logical reasoning. If you're good at aptitude then it'll be easy for you but if you haven't practiced then time duration may cost you. English: It consisted of comprehension and grammar. It was fairly easy and time duration was enough. Core CS subjects: It consisted of questions from OS, DBMS, DSA. It did NOT have questions on Linux. If you're good with fundamentals then it'd be easy. I'd suggest watching Knowledge gate or Gate smashers videos. Coding and SQL: It had 2 questions on coding and 2 on SQL queries. For coding, you could choose the language from C+, C, Java. I don't remember if there was Python or not. For SQL, it was restricted to MySQL. SQL queries were on joins, aggregate functions, group by, order by. Coding questions: 1. Replace array elements by the sum of the next two consecutive elements. 2. Find the longest Even Length Substring such that Sum of First and Second Half is same. In the 2nd question, we had to print the substring. O(n^3) solution was accepted. Language-specific question: I chose C++. Questions were on OOP and output questions Round 2: Explain SDLC. Which SDLC model is the best model? Concept of stack and queue? How will you insert an element at 3rd position in a stack? (Just the approach, no coding) What is a Linked list, circular linked list, doubly linked list? Difference between task, thread, program, and software? Have you used multithreading in your project? (I didn't) How will you use multithreading in your project? What is heap memory? What will happen if a memory allocated at the heap is not deleted? How will you check if a memory allocated at the heap is deleted or not? (I explained for both Java and CPP) What are the different types of DBMS functions? Which DBMS function will you use to get the maximum from a column? What are the different types of joins? What is a foreign key? Is it necessary to have the primary key of another table in a foreign key or any column that can be used? (He was trying to confuse me) What is the race condition? How will you prevent race conditions? What is mutex? Round 3: Introduce yourself. How many family members and what do they do? Everyone in your family has a govt job so why you're applying for a private job? Strengths and weaknesses. Why Amdocs? Your biggest achievements. What do you do in your leisure time?