Simpl Interview Questions and Answers for Experienced

Q1. Trie Opearation
Add your answer
Q2. Binary Search based Question
Add your answer
Q3. SQL queries using group by and order by
Ans. 
SQL queries using group by and order by
• Use GROUP BY to group rows that have the same values into summary rows

• Use ORDER BY to sort the result set in ascending or descending order

• Example: SELECT department, COUNT(*) FROM employees GROUP BY department ORDER BY COUNT(*) DESC
Answered by AI
Add your answer

Q1. Merge 2 Sorted linked list
Ans. 
Merge two sorted linked lists into a single sorted linked list
• Create a new linked list to store the merged result

• Iterate through both input linked lists and compare nodes to determine the order in which they should be merged

• Update the next pointers of the nodes in the new linked list accordingly
Answered by AI
Add your answer

If its for the SDE 1 , mostly they will start with javascript fundamentals and deep dive in the hard topics

Questions around latency , p99 and p999 and how to build low latency systems

Q1. System design round
Add your answer
Q2. Question around detection of files with malware
Add your answer

Q1. More of a discussion - deployment, service refactoring, selection of tech , tooling etc
Add your answer

Prepare basics such as group by, case functions, aggregation and some theoretical part such as sequence of sql query execution, basic concepts of dbms

Case study on analytics side like think like a product analyst and define metrics for a feature for example feature that count your daily steps.

Q1. Culture related Queries
Add your answer
Q2. Salary expectations and negotiation deal
Add your answer