Ipsos Interview Questions and Answers

Normal 10 Mcq questions

Advantages and disadvantages of GenAl

Q1. Sql query on subquery
Ans. 
A subquery is a query nested within another SQL query, used to retrieve data based on the results of the outer query.
• Subqueries can be used in SELECT, INSERT, UPDATE, or DELETE statements.

• Example: SELECT * FROM employees WHERE department_id IN (SELECT id FROM departments WHERE location = 'New York');

• Subqueries can return single or multiple values.

• They can be correlated (dependent on the outer query) or non-correlated (...read more
Answered by AI
Add your answer
Q2. Explain about ur project
Add your answer

Q1. Suppose you have to reverse a string, while reversing which index will print first.
Ans. 
Reversing a string involves printing characters from the end to the start, with the last index printed first.
• To reverse 'hello', start from index 4 (last character 'o') and end at index 0 (first character 'h').

• The reversed string of 'hello' is 'olleh'.

• In Python, you can reverse a string using slicing: 'hello'[::-1] results in 'olleh'.

• In Java, you can use StringBuilder: new StringBuilder('hello').reverse().toString() gi...read more
Answered by AI
Add your answer
Q2. Write a sql query to get only 3 column with age range from 30 to 40.
Ans. 
This SQL query retrieves three specific columns for individuals aged between 30 and 40.
• Use the SELECT statement to specify the three columns you want to retrieve.

• Utilize the WHERE clause to filter records based on the age range.

• Example: SELECT name, age, email FROM users WHERE age BETWEEN 30 AND 40;
Answered by AI
Add your answer

Q1. About SQL basics such as difference between delete and truncate, and some basic definitions.
Add your answer
Q2. About Python basics such as list, tuple and all.
Add your answer
Q3. Basic questions about Excel.
Add your answer

Q1. Salary Negotiation
Add your answer
Q2. About Company Work Culture
Add your answer

Basic aptitude questions

Q1. SQL basics questions like joins
Add your answer
Q2. Pandas basics for data manipulation
Add your answer

Q1. Introduce youself
Add your answer
Q2. How are you suitable for this role
Add your answer
Q3. Explain your projects
Add your answer

Q1. Introduce yourself
Ans. 
I am a passionate research intern with a background in biology and a keen interest in data analysis and scientific discovery.
• Currently pursuing a degree in Biology with a focus on molecular genetics.

• Completed a summer internship at XYZ Lab, where I assisted in research on gene editing techniques.

• Skilled in data analysis using Python and R, with experience in statistical modeling.

• Participated in a collaborative project ...read more
Answered by AI
Add your answer
Q2. Why do you want to join ipsos
Ans. 
I want to join Ipsos to contribute to impactful research that drives decision-making and enhances understanding of consumer behavior.
• Ipsos is a global leader in market research, providing insights that shape strategies for businesses.

• I admire Ipsos' commitment to innovation, such as using advanced analytics and technology to gather data.

• The opportunity to work with diverse teams and clients across various industries ex...read more
Answered by AI
Add your answer