There's not much information about this internship role on the forum, and what's there is outdated, so today I'll share my OA to help others out (and also help myself next year when I'm looking for full-time).
The OA got a lot harder this year — it used to be three questions in one hour, but now it's five questions in 50 minutes.
The questions were two easy SQL questions, two easy-medium LeetCode-style coding questions, and one fairly simple object-oriented programming question. For the SQL questions, one mainly tested whether you know how to use summary functions, and the other tested whether you know how to use join and aggregate functions.
One of my coding questions gave you a list of numbers and asked you to find the kth smallest number not in the list. The constraints were pretty tight, so you had to be optimal. The other question gave you a series of string operations along with their execution times, and said that if the same operation showed up three times within a given time window it counted as redundant, then asked how many redundancies there were.
The last question, the OOP one, just had you define the object's properties and write out the format for the returned text. Honestly, I didn't think it was as hard as the two coding questions before it, and I'm not sure why they rated this one as medium difficulty. But I ran out of time, so I didn't get the format exactly right and didn't get points for it — I'm guessing I failed.
Discussion
Loading comments…