4. If total compensation = salary+Bonus then show the query to show the total compensation of each employee in department 50. Order the result to show the greatest compensation first. id first_name last_name total_compensation 14 Dave Freeman 84098 16 Red James 83900 15 Andy Lee 80600
6. Find the Employee with the same salary in department 10. id first_name last_name salary 2 Sharon Smith 30000 3 Mary Lee 30000
What was a time when I had to make a quick decision and think on my feet and react quickly to solve a problem?
Tell me about yourself? How did you deal with a situation using the SHINE method? What do you know about the company? Why do you want to work for Avantor?
Can you stayback if there are customer complaint?
What elements would you have in place to control product quality for a PCBA contract manufacturer ?
What are the different types of testing?
What do you do when it is Friday and some work left and there is a deadline on Monday. ?
All question where related job scenario for supplier. how to react, action when situation given.
Mostly QA testing based scenarios not at all technical. Then gave me a 30 minutes quiz ( I was told by the recruiter that it will be 1 hr). I was given a small laptop where you needed to switch between the 2 quiz screens and write your answers on a note pad. The first part was 2 page write up with screen shots of the product under test. You are asked to write test cases in an excel sheet provided. The reading and comprehending itself takes 10 minutes and covering every scenario would take another 30 minutes. There were 7 sql queries in the second part of the quiz, they were not difficult but time to read and write is not there even for a SQL expert. The QA guy who was monitoring the quiz, asked me to just explain verbally if I had run out of time. I did and he was satisfied.
Viewing 1871 - 1880 interview questions