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."
Technical Expert Interview Questions
185 technical expert interview questions shared by candidates
Detailed technical questions
Can you explain a technical concept related to the payment, telecommunication, or identity industries to someone without a technical background?
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?
To paraphrase, think of a time you and a colleague encountered a challenging social situation, and how did you overcome it as an individual, together, and as a team? To paraphrase: Describe a difficult iPhone appointment, what was the issue and how did you find a solution? There is a 3rd or 4th question but it changes every so often.
Q: Why should we choose you as a candidate for this position.
You walk into a fast food restaurant and see a whole bunch of angry people. What do you do?
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)
How would you handle a project urgent challenge to be fixed?
what was your publications? which technical field are you expert in?
Viewing 1 - 10 interview questions