Copperpod Digital Senior Business Analyst Interview Questions and Answers

I had to evaluate a software and let them understand where this software could be implemented and the pros and cons of the software.

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

Q1. What is useState in React.js
Ans. 
useState is a React hook that allows functional components to manage state.
• useState is imported from React: `import React, { useState } from 'react';`

• It initializes state in functional components: `const [count, setCount] = useState(0);`

• The first element is the current state value, and the second is a function to update it.

• State updates are asynchronous and can be batched for performance.

• Example of updating state: `set...read more
Answered by AI
Add your answer
Q2. Difference between useState and useEffect
Ans. 
useState manages state in functional components; useEffect handles side effects like data fetching and subscriptions.
• useState is a Hook that allows you to add state to functional components.

• Example: const [count, setCount] = useState(0);

• useEffect is a Hook that lets you perform side effects in function components.

• Example: useEffect(() => { document.title = `Count: ${count}`; }, [count]);

• useState is synchronous and u...read more
Answered by AI
Add your answer

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. 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