Amdocs Interview Experience 2021

Date: 17 June 2021 3:00 PM

1. How are you?
2. Let’s go through your resume(3 min for reading)
3. Tell me something about yourself?
4. What you did in your internship?
5. What technology you used in that project? I said –  ML, Django, Android, python. Some basic questions on python:
6. What is the difference between list and tuple?
7. What is the difference between dict and list?
8. How to debug code in python?
9. So have you used a database in your project -I said No
10. So you don’t know about databases? I said I had worked on the database in my second year.
11. Question on oracle and MySQL
12. Write a query for creating a table in chatbox?
13. Do know joins explain
14. When you use left outer join and right outer join (gave the Sneiorio two tables A and B ) and write a query for it?
15. Write a query to fetch the record of the second highest salary from the emp table?
16. What SQL language you know such as DML etc – I said DML, TCL, DCL, with real-time example he said great
17. Can we delete a row from a table based on another table? – I said yes
18. Write a query for it?
19. Is possible to create a table without using create a statement? – I said yes
20. Write query in the chatbox?
21. I want 10 emp from table ?? Write a query
22. Is possible to fetch data of 10 emp from emp id 45 to 55? I said yes, I started writing he said no need
23. Tell one real-time example TCL? (early I explain DML only)
24. 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
25. Can you create an Android app for this automation?
26. You and another person gave the solution for the product? How you convince to select your idea!! (tricky one!!)
27. Based on what factors you choose your idea or your colleague?

That’s it, I have done with questions. Any questions??

I asked some question he answered very nicely(8-10 min discussion). Thank you so much

End

And I shortlisted for the HR round 

HR Interview: Basic questions were asked in hr round, I waiting for the results now.

Got Selected in Amdocs(to happy)

Thank you so much for reading!