Most difficult was probably a moderately complicated SQL query.. at the time I had been doing lots of rails and my head was not in the pure SQL mode at all. It was my fault for not brushing up on that before coming in, but I did my best and talked it out as I wrote it. I got the entirety of the idea correct and the majority of the syntax correct, but some of it was a little railsified out of lack of wholly memorized SQL syntax.
Meeting with hiring manager.
Questions about Rails internals, databases, optimisations techniques, etc
Describe rails models using Single Table Inheritance
first "screening" they asked rate and very very generic. I don't think the screeners are technical at all.
Why we use "var" to declare the variable in JS, because we can declare variable without it?
Round 1 : 60 mins coding test on their own portal with moderate questions. Round 2 : 1. Identify Circular Linked List or not with optimization. 2. Palindrome with linked list 3. What is rate count in API how to implement it. 4. Diff between Rest and Soap 5. What is static and dynamic language 6. Http verbs 7. Sql query for users, language and mapping table, find username who speaks more than 3 language. 8. Http response status 400 series 9. OAuth Round 3 : Design Database for Exam and question, one exam can have multiple questions and question can have 3 types, 1: multi choice 2. true false 3. match the answer. you need to store all options and it's answer as well. What is indexing, it's type and advantage and disadvantage SQL Query : You have rows with timestamp, get number of entries in last 24 hrs group by 1 hr. Round 4 : 1. What is the reason behind leaving all previous companies?(Be care full while answering this, it went negative for me) 2. When to use SQL and NoSql 3. Design whatsapp server side in 5-10 mins. Round 5 : Asked about my thesis research and how do you approach today with same problem.
You are running a car wash. Here are the rules: - Your car wash accepts cars and trucks. - You charge $5 for cars. - You charge $10 for trucks. - Your car wash charges $2 extra if the truck has mud in the bed. - Your car wash does not accept trucks with the bed let down. - If the vehicle comes in a second time, they get 50% off. - If the license plate equals 1111111, the vehicle is stolen and does not get a car wash.
This interview did not have specific questions for problems but scenarios.
L1 Assessment - To build users, carts and cart items table for online ordering service. L2 F2F Technical Round - They mostly asked about sql queries. some of the listed questions are Materialized Views in sql Why Active record? Window functions ORM Querying JSON typed data Querying based on part of data in strings Shortening links without using third party CORS Cdn links Security Measure that you follow to APIs some of the questions are like Challenging task That I worked blunders that you did Work Experience
Viewing 51 - 60 interview questions