Razorpay Associate Analytics Interview Questions and Answers

SQL, Aptitude based questions

Q1. SQL, resume related questions
Add your answer

Case studies and SQL questions

Q1. Case studies, mathematical
Add your answer

Normal aptitude test. Test format was some what like cat paper. Maths and reasoning was asked. Fast calculation and practice us required for solving all the problema under given time

Q1. Explain inner and outer join
Ans. 
Inner join returns only the matching records from both tables, while outer join returns all records from both tables.
• Inner join combines rows from two tables based on a related column.

• Outer join combines rows from two tables and includes unmatched rows from one or both tables.

• Inner join is used to retrieve data that exists in both tables.

• Outer join is used to retrieve data that may or may not exist in both tables.

• Examp...read more
Answered by AI
View 2 more answers
Q2. If two table have 5 and 3 entry and we apply inner join then what will be the maximum and minimum number of entry possible in final result
Ans. 
Inner join of two tables with 5 and 3 entries can result in a minimum of 0 and a maximum of 3 entries.
• Inner join returns only the matching rows from both tables.

• The maximum number of entries in the result will be equal to the number of matching rows.

• If there are no matching rows, the result will have 0 entries.

• In this case, the maximum number of entries will be 3, as there can be at most 3 matching rows.
Answered by AI
View 1 more answer
Q3. Mention 3 differrnce tuple and list in python
Ans. 
Tuple and list are two data structures in Python with different properties.
• Tuple is immutable while list is mutable

• Tuple uses () while list uses []

• Tuple is faster than list for accessing elements
Answered by AI
Add your answer
Q4. One simple query ( w3 school and some practice on hackerrank is Enough)
Add your answer

Q1. This round contains mainly puzzles. 3 puzzles were asked and 2 were from gfg
Add your answer
Q2. Then questions were asked about resume. For example I had nlp intern so they asked me about forward feed neural network and how to optimize it. Other questions were also asked regarding intern. Overall you...read more
Add your answer

Q1. What are your strengths and weaknesses?
Add your answer
Q2. Why should we hire you?
Add your answer
Q3. Why razorpay? , tell me about something that you have done that you are proud of.
Add your answer
Q4. What do you know about rzorpay
Add your answer