Odessa Interview Questions, Process, and Tips

Q1. What is rank function?
Ans. 
Rank function is used to assign a rank to each row within a result set based on specified criteria.
• Rank function is commonly used in SQL queries to order and rank data.

• It assigns a unique rank to each row based on the specified criteria.

• The rank of a row is determined by its position in the ordered result set.

• If two rows have the same values, they will be assigned the same rank.

• The next rank will be skipped if there ar...read more
Answered by AI
View 1 more answer
Q2. What is dependency Injection?
Ans. 
Dependency Injection is a design pattern that allows objects to receive dependencies rather than creating them internally.
• Dependency Injection is a way to achieve loose coupling between objects.

• It allows for easier testing and maintenance of code.

• There are three types of Dependency Injection: Constructor Injection, Setter Injection, and Interface Injection.

• Example: Instead of creating a database connection object insid...read more
Answered by AI
Add your answer

Q1. Why are you looking for a change?
Add your answer

The first round is a online test

1 question is given to solve , easy one

Common Apti questions, basics of finance and accounts

Q1. Introduction, Basics of Finance and Accounting & Lease accounting.
Add your answer

Case study based on the role

Q1. Basic HR questions were asked
Add your answer

Q1. Out vs ref etc basic c# questions, then moved on to sql temp table vs CTE performance comparison etc. Then we moved to SOLID principles and Design patterns.( also what i have worked on before which is stan...read more
Add your answer
Q2. SQL temp table etc
Add your answer
Q3. SOLID principles
Add your answer
Q4. Design patterns
Add your answer

Q1. Mostly wanted to know about my previous organization database architecture followed. Garbage collection in OOPS etc
Add your answer

The coding test consisted of two programming questions hosted on a platform

Q1. I was asked about various OOP concepts
Add your answer
Q2. Questions related to LinkedList and Stack
Add your answer

Two coding questions were asked and some 20-30 MCQs were present. 1 coding question was of moderate level and 1 was a bit standard question. One of them was string based and other one was DP based.

Q1. 1 hr long technical interview(questions revolved around my CV). I was asked questions from DSA,DBMS,OS as well as networking as these were mentioned in my CV. I was asked to briefly explain what my project...read more
Add your answer

Q1. Second technical interview - I was asked to code in an editor, one of them was a moderately easy question based on string where I had to remove all consecutive vowels from a string. The other question was ...read more
Add your answer