Amdocs Assistant Software Engineer (ASE) interview questions

How are you? Let’s go through your resume(3 min for reading) Tell me something about yourself? What you did in your internship? What technology you used in that project? I said – ML, Django, Android, python. Some basic questions on python: What is the difference between list and tuple? What is the difference between dict and list? How to debug code in python? So have you used a database in your project -I said No So you don’t know about databases? I said I had worked on the database in my second year. Question on oracle and MySQL Write a query for creating a table in chatbox? Do know joins explain When you use left outer join and right outer join (gave the Sneiorio two tables A and B ) and write a query for it? Write a query to fetch the record of the second highest salary from the emp table? What SQL language you know such as DML etc – I said DML, TCL, DCL, with real-time example he said great Can we delete a row from a table based on another table? – I said yes Write a query for it? Is possible to create a table without using create a statement? – I said yes Write query in the chatbox? I want 10 emp from table ?? Write a query Is possible to fetch data of 10 emp from emp id 45 to 55? I said yes, I started writing he said no need Tell one real-time example TCL? (early I explain DML only) Every day I got one mail on outlook, I want the screenshot of this mail to my Whatsapp? Give me a solution for this?Again he asks Can you create an Android app for this automation? You and another person gave the solution for the product? How you convince to select your idea!! (tricky one!!) Based on what factors you choose your idea or your colleague?

Questions about my resume and a programming question