Network People Services Technologies Business Analyst Interview Questions and Answers

Intermediate SQL Topics - Window Function, Subquery, Joins

Tables:
registration (userid string, regdate date);
txn(txndate date, userid string, amt int, game string);

1. Write a query to get proportion of users who have played a game within 2 days of registration
2. Find the most money spent on a game for each user
3. Get the list of users who played poker but not ludo

Coding test, technical round, HR round

Mcqs on javascript,. 1 coding question

Q1. React hooks related How to use them
Add your answer
Q2. About web socket real time messaging
Add your answer
Q3. About react router dom
Add your answer

Q1. What is supervised learing
Add your answer
Q2. What is mse
Add your answer

Q1. Tell us about a project you've worked on using the MERN stack.
Ans. 
Developed a task management application using the MERN stack to streamline team collaboration and project tracking.
• Utilized MongoDB for database management, storing user tasks and project details.

• Implemented Express.js to create RESTful APIs for task CRUD operations.

• Used React.js for building a responsive user interface, allowing users to add, edit, and delete tasks seamlessly.

• Incorporated Node.js for server-side logic...read more
Answered by AI
Add your answer
Q2. How do you manage routes in a MERN stack application?
Ans. 
Managing routes in a MERN stack involves defining API endpoints and client-side routes for seamless navigation and data handling.
• Use Express.js for backend routing: Define routes in a separate file, e.g., 'routes/user.js'.

• Implement RESTful API conventions: Use GET, POST, PUT, DELETE methods for CRUD operations.

• Utilize React Router for client-side routing: Set up routes in 'App.js' using <BrowserRouter> and <Ro...read more
Answered by AI
Add your answer

Q1. How did you collaborate with other team members during your internships?
Add your answer
Q2. Can you describe how you handled feedback from your senior developers or mentors?
Add your answer