Add office photos
Engaged Employer

EXL Service

3.7
based on 7.1k Reviews
Video summary
Filter interviews by

10+ Comvision Interview Questions and Answers

Updated 5 Nov 2024
Popular Designations

Q1. There is table which holds details of matches played between the countries in first 2 columns and who won the match in 3rd column. write a query to get no. of matches played by each team and no. of matches won...

read more
Ans.

Query to get number of matches played and won by each team from a table of match details.

  • Use GROUP BY clause to group the data by team name.

  • Use COUNT() function to get the number of matches played by each team.

  • Use SUM() function with a condition to get the number of matches won by each team.

Add your answer

Q2. Python code for factorial

Ans.

Python code to calculate factorial of a number.

  • Use a loop to iterate from 1 to the given number.

  • Multiply each number with the previous result.

  • Return the final result.

View 1 answer

Q3. Difference between having and where cause

Ans.

HAVING is used with GROUP BY to filter groups, WHERE is used to filter rows

  • HAVING is used with GROUP BY clause to filter the groups based on aggregate functions

  • WHERE is used to filter rows based on conditions

  • HAVING is applied after the GROUP BY clause, WHERE is applied before

  • HAVING can only be used with SELECT statement that contains a GROUP BY clause

  • Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

  • Example: SELECT * FROM em...read more

Add your answer

Q4. Python string is changable or not

Ans.

Python strings are immutable, meaning they cannot be changed once created.

  • Python strings are immutable, so any operation that appears to modify a string actually creates a new string object.

  • For example, when you use string concatenation or slicing, a new string is created instead of modifying the original string.

  • To modify a string in Python, you would need to create a new string with the desired changes.

Add your answer
Discover Comvision interview dos and don'ts from real experiences

Q5. Python using remove duplicate value

Ans.

Use Python's set() function to remove duplicate values from an array of strings.

  • Convert the array to a set to automatically remove duplicates

  • Convert the set back to a list if needed

Add your answer

Q6. how to improve process

Ans.

Improving processes involves identifying inefficiencies, implementing changes, and continuously monitoring and adjusting for optimal results.

  • Identify bottlenecks and areas of inefficiency

  • Implement automation and technology solutions

  • Streamline communication and collaboration between teams

  • Regularly review and analyze data to identify areas for improvement

  • Seek feedback from stakeholders and incorporate suggestions for enhancement

Add your answer
Are these interview questions helpful?

Q7. how shouild ovrcome negativity

Ans.

Negativity can be overcome by practicing gratitude, surrounding yourself with positive people, and focusing on solutions rather than problems.

  • Practice gratitude by keeping a gratitude journal or regularly reflecting on things you are thankful for

  • Surround yourself with positive people who uplift and support you

  • Focus on solutions rather than dwelling on problems - brainstorming ways to address challenges can help shift your mindset

Add your answer

Q8. Sql to find 2nd highest salary

Ans.

Use SQL query with ORDER BY and LIMIT to find 2nd highest salary

  • Use ORDER BY clause to sort salaries in descending order

  • Use LIMIT 1,1 to skip the highest salary and get the second highest

  • Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1

Add your answer
Share interview questions and help millions of jobseekers 🌟

Q9. Merge 2 arrays in python

Ans.

Use the concatenate function from numpy to merge two arrays in Python.

  • Import numpy library

  • Use np.concatenate() function to merge the arrays

  • Ensure both arrays have the same data type

Add your answer

Q10. Sql for running total

Ans.

Running total in SQL is achieved by using window functions like SUM() with OVER() clause.

  • Use SUM() function with OVER() clause to calculate running total.

  • Specify the window frame with ORDER BY in the OVER() clause.

  • Running total can be reset based on certain conditions using PARTITION BY in the OVER() clause.

Add your answer

Q11. FUNCTION ON SQL AND EXCEL

Ans.

Functions in SQL and Excel are used to perform calculations, manipulate data, and automate tasks.

  • Functions in SQL are used to perform calculations, manipulate data, and automate tasks within a database.

  • Common SQL functions include SUM, AVG, COUNT, MAX, MIN, and CONCAT.

  • Functions in Excel are used to perform calculations, manipulate data, and automate tasks within spreadsheets.

  • Common Excel functions include SUM, AVERAGE, IF, VLOOKUP, and CONCATENATE.

Add your answer

Q12. Sort array in python

Ans.

Use the sorted() function to sort an array of strings in Python.

  • Use the sorted() function with the array as input to get a new sorted array.

  • You can use the reverse parameter to sort in descending order.

  • You can use the key parameter to specify a custom sorting key.

  • Example: sorted_array = sorted(array)

Add your answer

Q13. architecture of gans

Ans.

Generative Adversarial Networks (GANs) are a type of deep learning model that consists of two neural networks, the generator and the discriminator, which are trained simultaneously.

  • GANs consist of two neural networks - the generator and the discriminator.

  • The generator creates new data instances, while the discriminator evaluates them.

  • The two networks are trained in a competitive manner, where the generator tries to fool the discriminator and the discriminator tries to disting...read more

Add your answer
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at Comvision

based on 17 interviews
3 Interview rounds
Resume Shortlist Round
Aptitude Test Round
Technical Round
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Data Analyst Interview Questions from Similar Companies

4.1
 • 32 Interview Questions
3.7
 • 27 Interview Questions
3.8
 • 25 Interview Questions
3.9
 • 16 Interview Questions
3.7
 • 13 Interview Questions
4.2
 • 10 Interview Questions
View all
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
70 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter