Tata Digital Senior Business Analyst Interview Questions and Answers

Lag is a delay in a process, while lead is an acceleration or advancement.

• Lag refers to a delay in a process or activity, where there is a gap between the desired outcome and the actual outcome.

• Lead refers to an acceleration or advancement in a process, where the desired outcome is achieved before the actual outcome.

• For example, in project management, lag time is the delay between the completion of one task and the sta...read more

Rank, Dense_Rank, and Row_Number are functions used in SQL to assign a ranking to rows in a result set.

• Rank assigns a unique rank to each row based on the specified column values.

• Dense_Rank assigns a unique rank to each row without any gaps, even if there are ties.

• Row_Number assigns a unique sequential integer to each row in the result set.

• Example: If we have a table of students with their scores, Rank would assign ran...read more