Domande di colloquio presso ASIFlex

✅ Round-Wise Prep Plan 🔹 1. Aptitude Test (Quants + Reasoning + English) 🔸 Topics to Cover: Percentages, Profit & Loss, Time & Work, Averages Seating arrangement, directions, puzzles Syllogisms, blood relations, number series Synonyms, antonyms, reading comprehension 🔸 Resources: IndiaBix GeeksforGeeks Aptitude [RS Aggarwal Aptitude Book (PDF or hardcopy)] 🔸 Practice: 10–15 questions daily for 7 days 🔹 2. Technical Test (SQL, OOPs, DSA) 🔸 Important SQL Concepts: Joins (inner, left, self) Group By, Having, Order By Subqueries & Nested Queries Window Functions (ROW_NUMBER, RANK) Normalization (1NF to 3NF), Indexing 📌 Practice Queries: sql Copy Edit -- Q: Find 2nd highest salary from employee table SELECT MAX(salary) FROM employee WHERE salary < (SELECT MAX(salary) FROM employee); 🔸 OOP Concepts: Inheritance, Polymorphism, Encapsulation, Abstraction Real-life examples (e.g., Animal -> Dog/Cat classes) Java/C++/Python class syntax 🔸 DSA Topics (for light MCQs): Arrays, Strings, Sorting (bubble, selection) Recursion basics Stack/Queue concepts 🔹 3. Technical Interview Prep This is the most crucial round. You’ll be grilled on: ✅ SQL You must be fluent in writing SQL queries on paper or in editor Sample Qs: Write a query to fetch top 3 highest-paid employees per department Normalize a flat table into 2NF