AskmeOffers.com interview question

Technical Questions: Coding and Algorithms: Write a function to find the longest common prefix among an array of strings. Implement a function to reverse a linked list. Given an array of integers, write a function to move all zeros to the end while maintaining the relative order of the non-zero elements. Explain the difference between depth-first search (DFS) and breadth-first search (BFS). Provide a use case for each. Write a function to check if a binary tree is balanced. Data Structures: Explain how a hash table works. What are its time complexities for insertion, deletion, and lookup operations? Implement a queue using two stacks. Describe the operations of a priority queue and its typical applications. System Design: Design a scalable URL shortening service like bit.ly. How would you design a high-traffic notification system? Describe how you would design an online book reader system. How would you design a scalable database system to handle millions of transactions per second? Database and SQL: Write a SQL query to find the second highest salary from an Employee table. Explain the differences between SQL and NoSQL databases. Provide examples of when to use each. How would you design a database schema for an e-commerce application? APIs and Web Services: Explain RESTful web services. What are the main principles behind REST? How would you handle rate limiting in an API design? Describe how OAuth works. What are its main advantages and disadvantages? Behavioral Questions: Describe a challenging project you worked on. How did you overcome the challenges? How do you handle tight deadlines and pressure? Give an example of a time when you had to learn a new technology quickly. How did you approach it? Describe a situation where you had a conflict with a team member. How did you resolve it? What motivates you to perform your best at work? How do you prioritize your tasks when working on multiple projects? Can you give an example of a time when you provided a creative solution to a problem? Describe your experience with agile development methodologies. How do you ensure the quality of your code?