The Higher Pitch Interview Questions and Answers

Q1. Given a data set of hotel you need to find number of booking.
Add your answer
Q2. SQL Query based upon join leetcode.
Add your answer

Q1. 2 sum problem [leetcode]
Add your answer
Q2. Linkedlist problem
Ans. 
Implement various operations on a linked list and solve related problems like reversing a linked list or detecting a cycle.
• Understand the basic structure of a linked list with nodes containing data and a reference to the next node.

• For insertion, update the pointers of the nodes accordingly to maintain the sequence.

• For deletion, adjust the pointers to skip the node to be deleted.

• To reverse a linked list, iterate through...read more
Answered by AI
Add your answer

Easy leetcode data structure question

Q1. Write working code for calling a rest API, design rate limiter
Ans. 
Code for calling a REST API and designing a rate limiter
• Use a library like requests or axios to make the API call

• Implement a token bucket algorithm for rate limiting

• Set a maximum number of requests per second and queue excess requests

• Consider using a distributed rate limiter for scalability
Answered by AI
Add your answer

Q1. Design Database schema for instagram
Ans. 
Design a database schema for Instagram.
• Create tables for users, posts, comments, likes, and follows.

• Use primary and foreign keys to establish relationships between tables.

• Store user data such as username, email, and password securely.

• Include fields for post content, location, and timestamp.

• Track likes and comments on posts.

• Implement a notification system for follows and likes.

• Consider scalability and performance in the...read more
Answered by AI
Add your answer

It want really good, aptitude test, focus on basic

Q1. Case study, interview, guestimates, python, SQL, power bi, Excel
Add your answer

Q1. Some basic Python ETL Questions, based on list,dictionary.
Add your answer
Q2. SQL Basics Question
Add your answer

Q1. Explain your projects
Add your answer

Q1. What is design for you?
Ans. 
Design is the process of creating solutions that are visually appealing, functional, and user-friendly.
• Design involves problem-solving and creativity

• It focuses on creating visually appealing and aesthetically pleasing solutions

• Design considers user experience and functionality

• Examples include graphic design, product design, and web design
Answered by AI
Add your answer
Q2. What do you expect to learn from this role?
Add your answer