Qa Associate Interview Questions

34,666 qa associate interview questions shared by candidates

SQL Questions > Tables are given below: Structure of Department table with sample data ---------------------------------------------------------------- ID DEPARTMENT_NAME 10 ACCOUNTING 20 HR 30 IT 40 SECURITY 50 MANAGEMENT ----------------------------------------------------------------- Structure of Employee Table with sample data ID FIRST_NAME LAST_NAME DEPT_ID SALARY BONUS 1 John Smith 10 20000 400 2 Sharon Smith 10 30000 4000 3 Mary Lee 10 30000 2000 4 David Lee 10 40000 2000 5 Rob Lee 20 40000 2000 6 Joanna Jones 20 34000 2050 7 Emma Smith 20 54000 5050 8 Maria Jones 30 52000 2250 9 Jose Enriquez 30 54000 4450 10 Ashok Dey 30 55000 4450 11 Raj Singh 40 34000 4450 12 Yvonne Everts 40 35000 4450 13 Sam Leland 40 44000 5550 14 Dave Freeman 50 74000 10098 15 Andy Lee 50 75000 5600 16 Red James 50 75200 8700 1. > Show the sql that will give the count of employees in each department Dept_id count 10 4 20 3 30 3
avatar

Software QA Engineer

Interviewed at EK Health Services Inc.

3.4
Jun 23, 2017

SQL Questions > Tables are given below: Structure of Department table with sample data ---------------------------------------------------------------- ID DEPARTMENT_NAME 10 ACCOUNTING 20 HR 30 IT 40 SECURITY 50 MANAGEMENT ----------------------------------------------------------------- Structure of Employee Table with sample data ID FIRST_NAME LAST_NAME DEPT_ID SALARY BONUS 1 John Smith 10 20000 400 2 Sharon Smith 10 30000 4000 3 Mary Lee 10 30000 2000 4 David Lee 10 40000 2000 5 Rob Lee 20 40000 2000 6 Joanna Jones 20 34000 2050 7 Emma Smith 20 54000 5050 8 Maria Jones 30 52000 2250 9 Jose Enriquez 30 54000 4450 10 Ashok Dey 30 55000 4450 11 Raj Singh 40 34000 4450 12 Yvonne Everts 40 35000 4450 13 Sam Leland 40 44000 5550 14 Dave Freeman 50 74000 10098 15 Andy Lee 50 75000 5600 16 Red James 50 75200 8700 1. > Show the sql that will give the count of employees in each department Dept_id count 10 4 20 3 30 3

Most of the questions were fairly straight-forward, however to test ones analytical thinking, they did ask a few logic questions. One of them being, if you had a book that you wanted to give to an employee, and you had 5 employees, and only a coin, heads and ties, to use to make the decision, which employee would get the book? And assume the employees are all the same skills/experience wise.
avatar

QA Lead/Manager

Interviewed at Kelly Benefits

3.3
Sep 8, 2014

Most of the questions were fairly straight-forward, however to test ones analytical thinking, they did ask a few logic questions. One of them being, if you had a book that you wanted to give to an employee, and you had 5 employees, and only a coin, heads and ties, to use to make the decision, which employee would get the book? And assume the employees are all the same skills/experience wise.

Viewing 951 - 960 interview questions

Glassdoor has 34,666 interview questions and reports from Qa associate interviews. Prepare for your interview. Get hired. Love your job.