Razorpay Data Analyst Interview Questions and Answers

Q1. Different types of Joins in SQL and what are the outputs when you join two tables with nulls.
Ans. 
Different types of Joins in SQL and the outputs when joining two tables with nulls.
• Types of joins in SQL include inner join, left join, right join, and full outer join.

• When joining two tables with nulls, the output depends on the type of join used.

• In an inner join, null values are excluded from the result.

• In a left join, all rows from the left table and matching rows from the right table are included, with nulls for no...read more
Answered by AI
View 1 more answer
Q2. Can you union tables with different datatypes.
Ans. 
Yes, but it requires careful handling of data types and potential conversion.
• Union can be performed on tables with different datatypes, but the resulting table will have a common datatype for each column.

• Data types should be compatible, otherwise conversion may be necessary.

• For example, a table with a column of integers can be unioned with a table with a column of floats, but the resulting column will be of type float.

• ...read more
Answered by AI
Add your answer

Q1. Given a data set, should write sql queries to answer a few questions
Add your answer
Q2. A few puzzles would be asked to evaluate the problem solving skills.
Add your answer

Q1. Business Case studies - try parctising profitablility and other cases
Add your answer

Q1. An Excel round will also be there if you apply for business analyst role.
Add your answer

Easy questions based on Logical Reasoning, Mathematics, English

Be sure to put your thoughts on the topic you get, and try to put a point that meets the goals or aspirations of the company.

Q1. Tell me about yourself Tell me something from your resume Desribe your project
Add your answer

Q1. General questions and sql questions
Add your answer

Q1. SQL Window functions projects
Add your answer

Q1. ML questions case study
Add your answer