Games24x7 Data Analyst Interview Questions and Answers

Q1. What is the difference between Union and Union all ?
Ans. 
Union combines the results of two or more SELECT statements, while Union all includes all rows, including duplicates.
• Union removes duplicate rows from the result set, while Union all includes all rows.

• Union sorts the result set, while Union all does not.

• Union is slower than Union all because it performs a distinct operation.

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FRO
Answered by AI
Add your answer
Q2. Which query is more faster , joins or union?
Ans. 
Joins are generally faster than unions.
• Joins are typically faster than unions because they combine data from multiple tables based on a common column, while unions combine data from multiple queries into a single result set.

• Joins can utilize indexes on the columns being joined, which can improve performance.

• Unions involve combining the results of multiple queries, which can be slower as it requires merging and sorting ...read more
Answered by AI
Add your answer

Q1. Details about the projects in your resume
Add your answer
Q2. MYSQL codes in window function
Ans. 
MYSQL window functions allow for calculations across rows in a result set.
• Window functions are used to perform calculations across rows in a result set

• They are used with the OVER() clause

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()

• They can be used to calculate running totals, moving averages, and more
Answered by AI
Add your answer
Q3. Mostly questions related to cricket tables which was told to be assumed
Add your answer

SQL based leetcode medium and hackerrank

Python take home EDA case study assessment

Q1. SQL based questions
Add your answer
Q2. Guesstimate on estimating # users on the application
Ans. 
Estimate the number of users on the application based on market research, user demographics, and industry trends.
• Consider the total addressable market (TAM) for the application

• Analyze user demographics and behavior to estimate adoption rate

• Look at industry benchmarks and competitor data for reference

• Use surveys, focus groups, and user feedback to gather insights

• Consider factors like market saturation, growth potential,
Answered by AI
Add your answer

70 Technical and Aptitude mcqs to solve in 50 minutes

Q1. What is overloading and overriding?
Ans. 
Overloading is having multiple methods with the same name but different parameters. Overriding is implementing a method in a subclass that is already defined in the parent class.
• Overloading allows a class to have multiple methods with the same name but different parameters.

• Overriding occurs when a subclass provides a specific implementation of a method that is already provided by its parent class.

• Overloading is resolve...read more
Answered by AI
Add your answer
Q2. What is difference between Primary and unique key in dbms?
Ans. 
Primary key uniquely identifies a record in a table, while unique key ensures all values in a column are distinct.
• Primary key does not allow NULL values, while unique key allows one NULL value.

• A table can have only one primary key, but multiple unique keys.

• Primary key is a combination of unique and not null constraints.

• Primary key is used to establish relationships between tables, while unique key is used to enforce un
Answered by AI
Add your answer

Q1. Basic question about qualification about experience suitable for role or not
Add your answer

Q1. Oops concepts should be strong.
Add your answer
Q2. Strong knowledge with c#
Add your answer
Q3. Asp .net, MVC, web APIs, .net core .
Add your answer

Q1. Senior lead will take this round and deep knowledge of technology
Add your answer

Q1. Manager round with skills and experience
Add your answer

Q1. International call one to one
Add your answer

Q1. Final discussion for salary and all
Add your answer

Link list program, few objective based on cpp

Q1. Good Core knowledge cpp
Add your answer
Q2. Pointer, static , constant used in multiple scenario. Oops, STL
Add your answer