Basic SQL questions. Describe a join to a non-technical person. How do you handle a query that does not perform quickly? They want to know that you can use 'explain plans', which I currently do not use (I'm still entry level). Select all customers who purchased at least two items on two separate days. Given a table with a combination of flight paths, how would you identify unique flights if you don't care which city is the destination or arrival location.
What shift are you interested in? Why do you want to work for Aldi?
Most of the questions will be based on how you handle hard situations with other people. Also it will be important to mention how you work with other people. Keep in mind you will be interacting with people all day long.
Logic question - You are alone on an island with these items; cigarette lighter, cell phone, 2 fuse ropes Known: - each rope is consumed by fire in 60 seconds - you can't assume constant burn rate for any portion of rope, only total time - you can't cut ropes Problem: How to measure 45 seconds
Tell me a time you wished ou had done something differently
The accent of the interviewer was very hard to understand. Given an array with N - 2 elements (two missing) from 1 to N, find the two missing elements in linear time and constant memory usage.
You have 1 seat left on a flight, and you have 5 passengers waiting on standby, a military man in uniform, a pregnant woman, a woman and her infant child, an elite customer(one who is a frequent flyer of NWA), and a gentleman trying to go an see his ill sister. Who will be the one to get the empty seat on the flight, and why?
Why Mesa?
In the assessment centre asked why this job motivates me
do you want to work here?
Viewing 831 - 840 interview questions