CupShup MIS Executive Interview Questions and Answers

Q1. What are joins and how do you use it?
Ans. 
Joins are used in databases to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q2. Processing speed of different scriting languages?
Ans. 
Processing speed of scripting languages varies based on factors like code complexity and optimization.
• Processing speed can vary based on the specific task being performed.

• Compiled languages like C++ tend to be faster than interpreted languages like Python.

• Optimizing code can improve processing speed.

• JavaScript can be faster than Python for certain tasks.

• Consider using libraries or frameworks optimized for performance.
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Qualifications and work experience
Add your answer

Q1. Work experience
Add your answer
Q2. Elabouration of work
Ans. 
Elaborating on work experience and responsibilities in previous roles.
• Provide detailed descriptions of tasks and projects worked on

• Explain how responsibilities were managed and executed

• Highlight any achievements or successes in previous roles
Answered by AI
Add your answer

Q1. About myself & my work experience
Add your answer

Q1. SQL & Python related Qs
Add your answer

Q1. 1. Explain about your self and the current company you work with.
Add your answer
Q2. 2. Any revenues achieved if yes was it a team target or on Individual role?
Add your answer
Q3. 3. Do you have any idea about our company 3 Minds Digital ?
Add your answer

Q1. 1. Explain about yourself, overall journey and your current role.
Add your answer
Q2. 2. Explain about your revenue contribution to the company.
Add your answer
Q3. 3. Explain about what understanding you have about the company 3 Minds Digital.
Add your answer
Q4. 4. One to One Client Game.
Add your answer

1. Basic Aptitude Test in order to check the ability. Duration was about 60 minutes.

Online , via third party software. Too lengthy sand same set of questions for all the levels .

Q1. Nothing much , over Google meet. The interviewer was rather unprepared and in a rush.
Add your answer

Q1. With the co founder virtually.
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

Reverse a binary tree

Q1. Basics of Spring
Add your answer
Q2. Explain Spring MVC
Ans. 
Spring MVC is a framework for building web applications in Java.
• Spring MVC stands for Model-View-Controller

• It provides a way to structure your web application

• It uses annotations to define controllers, request mappings, etc.

• It supports RESTful web services

• It integrates with other Spring frameworks like Spring Boot
Answered by AI
Add your answer