Round 1: What was your role in previous company? What all types of testing you have done? what was your role Onsite? Write testcase for Date Text field: i.e for eg: In a screen there is one Date field which is of type Text, User can enter Date manually without Calendar. Write all possible test data for the same. What is SQL Injection? what is SQL joins? What is Left Join,Right Join,Inner Join,Outer Join? Write a Query: There is a table EMP which has EMP ID and MANAGER ID: 1 Manager can have multiple employees.so write a query which will return MGR ID and count of EMP ID. Write a Query: to select second highest salary of the employee Write a Query:to select Maximum salary of employee Round 2: Tell me about yourself What was your role as a tester? Have you worked in Agile Model? Do you know SQL Profiler? In which domain you have worked? Banking is very vast domain.which part of it you have worked on? when you say Normalization, how you used to do it? was there any tool for Normalization? Or you used do it manually? Assume a scenario where There is a defect in developer's code, you have to explain it to developer without creating misunderstanding and you need to resolve issue as well, how will you handle it? suppose there are 2 numbers: A=10 and B=5, You have to swap it then whats the process behind it? How will you do it? Have you worked onsite? Did you interact directly with client or you used to work with another team there? Assume a scenario where Client is logging a new requirement in JIRA.From here onwards how will you proceed further? DO you know Agile Story? Do you have any questions?
