Times Internet Business Associate Interview Questions and Answers

Q1. Joins and their output
Ans. 
Joins are used in SQL 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

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN re...read more
Answered by AI
Add your answer
Q2. Employees who earn more than their manager
Add your answer

Basis CAT like aptitude with 2 simple python coding question

Q1. What Central limit theorem
Ans. 
The Central Limit Theorem states that the sampling distribution of the sample mean approaches a normal distribution as the sample size increases.
• States that the sampling distribution of the sample mean will be approximately normally distributed regardless of the shape of the population distribution

• Helps in making inferences about the population mean based on the sample mean

• Important concept in statistics and hypothesis...read more
Answered by AI
Add your answer

Q1. Could you please provide your name and some information about yourself?
Add your answer
Q2. What are your hobbies and skills?
Add your answer

Python, SQL, Quant, Statistics, Numpy

Q1. SQL, Python, Puzzle total 9Q
Add your answer
Q2. Table, Query, 2 puzzle, Python 1 code (4 Sub code)
Add your answer

Q1. Yet to declare result for the round 2 i feel +ve for round 2 result lets se
Add your answer

MCQ Mostly - Aptitude and Time Distance

RCA - Drop in Metrics

Q1. SQL & Pythonassad
Add your answer

I was surprised to see that all applications were gathered at a huge meeting room. We were handed out 4 pages of a case study and we were told to create a business plan for our responsible market.

Q1. SQL joins, python
Add your answer
Q2. Root cause analysis case study
Add your answer
Q3. Puzzles were asked in the interview
Add your answer

Q1. What is your opinion about business?
Ans. 
Business is the backbone of the economy, driving innovation, growth, and prosperity.
• Business plays a crucial role in creating jobs and generating income for individuals and communities.

• It fosters competition, which leads to improved products and services for consumers.

• Businesses contribute to economic development by investing in infrastructure and technology.

• They provide opportunities for entrepreneurship and innovatio...read more
Answered by AI
View 1 more answer
Q2. Why business is important
Ans. 
Business is important because it drives economic growth, creates jobs, and fosters innovation.
• Business drives economic growth by producing goods and services that meet the needs and wants of consumers.

• Businesses create jobs by hiring employees and providing them with income and opportunities for career growth.

• Businesses foster innovation by investing in research and development, driving technological advancements.

• Busin...read more
Answered by AI
View 1 more answer