Write a query to mark is_deleted flag true for all duplicate emails from the table keeping the row with the smallest id as it is This was the users table : CREATE TABLE users ( id serial, email text, is_deleted boolean default false ); Bad experience. I couldn't solve it, but they dint ask any more questions
Lead Backend Developer Interview Questions
9,386 lead backend developer interview questions shared by candidates
What are the challenges I faced in the take-home assignment?
They focused more on the logical thinking part rather than producing code.
Share your experience and some basic questions
They asked me about backend token questions
Algorithmic question to maximize completed jobs in a week based on different worker types and different job types.
1. https://www.geeksforgeeks.org/minimize-maxai-bj-ck-minai-bj-ck-three-different-sorted-arrays/ but N arrays 2. Some DP problem - a variation of coin change
Design a system to store message hashes at scale
Explain how to unit test scenarios given. How to design a database schema on scenario given. General social skills questions.
Unit testing. Database queries and security. Technical debt
Viewing 5191 - 5200 interview questions