KreditBee Analyst Interview Questions and Answers

Q1. Joins outputs for various types of joins
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table

• FU...read more
Answered by AI
Add your answer
Q2. Query using window functions
Ans. 
Window functions are used to perform calculations across a set of table rows related to the current row.
• Window functions are used in SQL to perform calculations on a set of rows related to the current row.

• They allow you to perform calculations like ranking, moving averages, and cumulative sums.

• Examples of window functions include ROW_NUMBER(), RANK(), and SUM() OVER().
Answered by AI
Add your answer

Q1. Output of basic sql queries
Add your answer

Q1. RCA with SQL and aptitude questions
Add your answer

RCA + more heavy on analytical side

Q1. Open ended problem solving round
Add your answer

15 questions 30 Minuities

2 or 3 case study the will ask

Q1. Regarding CTC & Interests in the org.
Add your answer

Q1. Find median of 2D array
Ans. 
Find median of 2D array of strings
• Flatten the 2D array into a 1D array

• Sort the 1D array

• Calculate the median based on the length of the array
Answered by AI
Add your answer

Q1. LLD of Twitter System
Add your answer

There were 2 easy question 1 medium
Question were good but have weak test case.

This was project or lld round.
You just be aware of class and other stuff.

Q1. Discussion on project Asked graph coding question in real scenerio. Like asked what algorithm you will use for different real life problems
Add your answer

Q1. Why engineering and what u know about cred
Add your answer

Q1. Basics on profile,work experience etc
Add your answer
Q2. Skills discussion based on role and resume
Add your answer

DSA in preferred language, Java coding testt