Skip to contentSkip to footer

Product Support Interview Questions

Salaries
Interviews

2,281 product support interview questions shared by candidates

Unfortunately I cannot remember the questions verbatim but they went about a very unconventional way of asking certain questions Ex. Instead of asking "Why did you leave your last job?" They would ask "So how did you get into your current role, looking at your resume your previous roles we’re pretty unique?" So, they were kind of indirect ways of asking certain questions . I honestly believe if I didn’t prep for the interview as much as I had for that full week leading up to it I would’ve been stumped.
avatar

Product Support Representative II

Interviewed at UKG

3.2★
Jul 28, 2022

Unfortunately I cannot remember the questions verbatim but they went about a very unconventional way of asking certain questions Ex. Instead of asking "Why did you leave your last job?" They would ask "So how did you get into your current role, looking at your resume your previous roles we’re pretty unique?" So, they were kind of indirect ways of asking certain questions . I honestly believe if I didn’t prep for the interview as much as I had for that full week leading up to it I would’ve been stumped.

As most of the common interview questions such as why I applied for the job etc were asked in the phone interview, the questions in the face to face interview included open-end questions where I had to give 3 examples of challenging scenarios and how I did overcome them.
avatar

Product Support Specialist

Interviewed at Medtronic

3.7★
Sep 15, 2019

As most of the common interview questions such as why I applied for the job etc were asked in the phone interview, the questions in the face to face interview included open-end questions where I had to give 3 examples of challenging scenarios and how I did overcome them.

Table 1: Analysis.dimProducts Column DataType ProductID INT(PK) Identity Name Varchar(100) Cost money Table 2: Analysis.dimCustomers Column DataType CustomerID Int (PK) IDENTITY FirstName Varchar(100) LastName Varchar(100) Table 3: Analysis.dimSales Column DataType SalesID INT (PK) IDENTITY ProductID INT (FK) CustomerID INT (FK) Quantity INT Questions 1. Write a query that would return the cost associated with a product of the name of “Shampoo” 2. Write a query that would return the first and last name (with one column as the return set instead of two) of all customers 3. Write a query that would return all sales associated with a customer with the first name of “Bob” and the last name of “Smith” 4. Write a query that would return the total number of products purchased by a customer with the first name of “Bob” and the last name of “Smith”. 5. Alter the query in question #4 to return the total number of products purchased by a customer with the first name of “Bob” and the last name of “Smith”, but still returning a value of zero if that name had no sales 6. Write a query that would return the amount of money made in revenue total based on the sales made of products. The result should be just one column. 7. Insert a new customer with the name of “Phil” and the last name of “Frank” 8. Delete a product with the name of “Shampoo” (make sure to incorporate all tables that would need to be validated before you do this delete) 9. Using joins, update the amount of the product “Shampoo” ordered by a customer with the name “Bob Smith” to 5 (assume there’s only one SaleID that represents this customer)
avatar

Senior Product Support Analyst

Interviewed at Crowe LLP

3.6★
Nov 11, 2023

Table 1: Analysis.dimProducts Column DataType ProductID INT(PK) Identity Name Varchar(100) Cost money Table 2: Analysis.dimCustomers Column DataType CustomerID Int (PK) IDENTITY FirstName Varchar(100) LastName Varchar(100) Table 3: Analysis.dimSales Column DataType SalesID INT (PK) IDENTITY ProductID INT (FK) CustomerID INT (FK) Quantity INT Questions 1. Write a query that would return the cost associated with a product of the name of “Shampoo” 2. Write a query that would return the first and last name (with one column as the return set instead of two) of all customers 3. Write a query that would return all sales associated with a customer with the first name of “Bob” and the last name of “Smith” 4. Write a query that would return the total number of products purchased by a customer with the first name of “Bob” and the last name of “Smith”. 5. Alter the query in question #4 to return the total number of products purchased by a customer with the first name of “Bob” and the last name of “Smith”, but still returning a value of zero if that name had no sales 6. Write a query that would return the amount of money made in revenue total based on the sales made of products. The result should be just one column. 7. Insert a new customer with the name of “Phil” and the last name of “Frank” 8. Delete a product with the name of “Shampoo” (make sure to incorporate all tables that would need to be validated before you do this delete) 9. Using joins, update the amount of the product “Shampoo” ordered by a customer with the name “Bob Smith” to 5 (assume there’s only one SaleID that represents this customer)

Viewing 441 - 450 interview questions

Glassdoor has 2,281 interview questions and reports from Product support interviews. Prepare for your interview. Get hired. Love your job.