Technical Expert Interview Questions

185 technical expert interview questions shared by candidates

There are two tables: users and countries. Each has two columns. Countries lists a city name and then the country it is in (Moscow : Russia, New York : USA, etc). Users lists an ID and a city name (1 : New York, 2 : Helsinki, etc). Note that there are cities listed in users that do NOT appear in countries. Output a table listing all the IDs and the corresponding countries, but be sure any NULL value is changed to "unknown."
avatar

Technical Support Expert

Interviewed at Crossover for Work

4.1
Sep 11, 2020

There are two tables: users and countries. Each has two columns. Countries lists a city name and then the country it is in (Moscow : Russia, New York : USA, etc). Users lists an ID and a city name (1 : New York, 2 : Helsinki, etc). Note that there are cities listed in users that do NOT appear in countries. Output a table listing all the IDs and the corresponding countries, but be sure any NULL value is changed to "unknown."

General and Behavioral Questions: Why do you want to work for Apple, and specifically as a Technical Expert? How do you stay current with new technology and Apple’s product line? Can you describe a time when you had to deal with a difficult customer? How did you handle it? How do you manage multiple tasks or customers during busy times?
avatar

Technical Expert

Interviewed at Apple

4.2
Oct 15, 2024

General and Behavioral Questions: Why do you want to work for Apple, and specifically as a Technical Expert? How do you stay current with new technology and Apple’s product line? Can you describe a time when you had to deal with a difficult customer? How did you handle it? How do you manage multiple tasks or customers during busy times?

1 round: question of array, string manupulation,sql queries. Second round: create a deadlock situation, write palindrome with all possible conditions, c++ all normal questions, Design pattern, factory and builder pattern difference. Third round : singleton design pattern, finding missing number in unsorted( duplicate number available) from int array, optimize it, complexity. Give questions in inheritance and polymorphism. Ask to implement Design for shapes, circle and picture(collection of shapes)
avatar

Software Technical Expert

Interviewed at Amdocs

3.7
Feb 15, 2024

1 round: question of array, string manupulation,sql queries. Second round: create a deadlock situation, write palindrome with all possible conditions, c++ all normal questions, Design pattern, factory and builder pattern difference. Third round : singleton design pattern, finding missing number in unsorted( duplicate number available) from int array, optimize it, complexity. Give questions in inheritance and polymorphism. Ask to implement Design for shapes, circle and picture(collection of shapes)

Viewing 1 - 10 interview questions

Glassdoor has 185 interview questions and reports from Technical expert interviews. Prepare for your interview. Get hired. Love your job.