OodlesTechnologies Senior Associate Consultant Interview Questions and Answers

1st round of the company was an online assessment with 40 questions,2 coding questions :- cake distribution problem, Palindrome and else there were 6-7 SQL questions and other were Aptitude questions (basic) whole test was for 1 hr.

Q1. Basic oops, basic questions on loops etc
Add your answer
Q2. SQL:- add a column on a table, find max salary of employee
Ans. 
Use ALTER TABLE to add a new column and then use MAX function to find the highest salary.
• Use ALTER TABLE statement to add a new column to the table.

• Use MAX function in SQL to find the maximum salary of employees.
Answered by AI
Add your answer
Q3. SUM OF DIGITS OF A NUMBER(DSA)
Ans. 
Calculate the sum of digits of a given number.
• Iterate through each digit of the number and add them together.

• Use modulo operator to extract each digit.

• Repeat until all digits are processed.

• Example: For number 123, sum of digits = 1 + 2 + 3 = 6.
Answered by AI
Add your answer

Mathematics,General Aptitute,three coding question

Face to face interview.Ask questions on Data structure and algorithms

Q1. Where do you look from 5 years from now
Add your answer

There are Verbal, logical reasoning, quantitative, coding questions (2 Qtns) and a descriptive essay on "How you used the pendamic duration for study" ( Minimum 200 words) required. And coding questions are DSA Medium level one was: " Find the maximum profit percentage during the buy and sell of stock of a company. ". Verbal round was mostly (4 -5 questions) on make meaning full sentence. All the first round test was conducted on "Xobin online test" platform.

Q1. There are two questions available 1. Write a business solution, technical solution using frontend or back-end technology to overcome the problem a) There is a new metro started in your city but the proble...read more
Add your answer
Q2. 2nd question was find solution for dynamic seat booking and price change during booking of ticket for a cinema hall.
Add your answer

Q1. Some questions on DSA like difference between merge sort and bubble sort. Sort available alphabets in a string array from vowel to consonant. In HR round HR will ask about your background and career then a...read more
Add your answer

Verbal, non-verbal, English and Numerical Aptitude

Q1. OOPs implementation in project
Ans. 
Implemented OOPs concepts like inheritance, encapsulation, and polymorphism in project design.
• Used inheritance to create a base class with common attributes and methods shared by subclasses.

• Implemented encapsulation by restricting access to certain data and methods within classes.

• Utilized polymorphism to allow objects of different classes to be treated as objects of a common superclass.

• Example: Created a class hierarch...read more
Answered by AI
Add your answer
Q2. React hooks like useEffect, useState
Add your answer
Q3. DBMS Normalization concept like 2NF
Add your answer

Q1. Ecommerce salesforce
Add your answer
Q2. Ecommerce and salesforce
Add your answer

Q1. Ecommerce salesforce
Add your answer
Q2. Salesforce com ecommerce
Add your answer

Personal platform their is no any functional support .

1 hour both (coding + Aptitude)

Q1. How to perform state management in react
Ans. 
State management in React involves managing and updating the state of components efficiently.
• Use React's built-in state management with setState() method

• Utilize React Context API for managing global state

• Implement Redux for complex state management in larger applications
Answered by AI
Add your answer

Basic aptitude questions.

Basic Dsa questions like array, string