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?
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?
Favorite apple product and why
How you can manage people of remote areas,where work culture is not there?
what was your publications? which technical field are you expert in?
How can you control the cardiotoxicity of Doxorubicin by applying CNT in formulation?
Viewing 1 - 10 interview questions