Comviva Technology Data Analyst Interview Questions and Answers

Coding test for all the student attending the first round, give your best practice every day all the best in your interview

Q1. What are your interest
Ans. 
My interests include data analysis, problem-solving, and continuous learning.
• Data analysis

• Problem-solving

• Continuous learning
Answered by AI
Add your answer
Q2. Java related question
Add your answer

Q1. What are SQL joins?
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• SQL joins are used to retrieve data from multiple tables based on a related column between them

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

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q2. What is normalisation?
Ans. 
Normalisation is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalisation involves breaking down data into smaller, more manageable tables

• It helps in reducing data redundancy and inconsistencies

• It ensures data integrity and improves database performance

• Example: Splitting a customer table into separate tables for customer details and orders
Answered by AI
Add your answer

Q1. How to rotate a Matrix?
Ans. 
To rotate a matrix, transpose it and then reverse each row.
• Transpose the matrix by swapping elements across the diagonal

• Reverse each row of the transposed matrix to rotate it clockwise

• For example, to rotate a 3x3 matrix clockwise: [[1, 2, 3], [4, 5, 6], [7, 8, 9]] -> transpose -> [[1, 4, 7], [2, 5, 8], [3, 6, 9]] -> reverse rows -> [[7, 4, 1], [8, 5, 2], [9, 6, 3]]
Answered by AI
Add your answer

Q1. Mostly Dax and sql related questions
Add your answer
Q2. ETL related questions
Add your answer

Q1. Explain the projects you worked on
Add your answer
Q2. Give the glance of your work and your role it.
Add your answer

Power bi SQL

Q1. Share details of your previous job.
Add your answer
Q2. What are your salary expectations?
Add your answer
Q3. Why should we hire you?
Add your answer
Q4. Where do you see yourself in 5 years?
Add your answer

Q1. How SQL DB works
Ans. 
SQL DB works by storing and managing data in a structured format using tables and relationships.
• SQL DB uses tables to store data in rows and columns.

• It allows for querying data using SQL commands like SELECT, INSERT, UPDATE, DELETE.

• Relationships between tables can be established using foreign keys.

• Indexes can be used to optimize query performance.

• ACID properties ensure data integrity and consistency.
Answered by AI
Add your answer