o9 Solutions Consultant Interview Questions, Process, and Tips

Q1. What is normalisation
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down data into smaller, more manageable tables.

• It helps in reducing data redundancy by storing data in a structured manner.

• Normalization ensures data integrity by avoiding update anomalies.

• There are different normal forms such as 1NF, 2NF, 3NF, and BCNF.

• Example: In a database, in...read more
Answered by AI
Add your answer
Q2. About the project done in final year
Add your answer
Q3. Demand planning process
Add your answer
Q4. Supply planning process
Add your answer

1.5hr SQL, verbal reasoning, statistics and probability

Q1. For what purpose trim used in sql?
Ans. 
Trim is used in SQL to remove leading and trailing spaces from a string.
• Trim function is used to remove leading and trailing spaces from a string

• It is commonly used to clean up data before performing comparisons or concatenations

• Syntax: TRIM([LEADING | TRAILING | BOTH] [characters] FROM [string])

• Example: SELECT TRIM(' hello ') as trimmed_string
Answered by AI
Add your answer

Easy to medium level aptitude and basic SQL questions.

Q1. SQL basic questions
Add your answer
Q2. DDL,DCl commands
Add your answer
Q3. Write down SQL commands
Ans. 
SQL commands are used to interact with databases and perform various operations.
• SELECT: retrieves data from a database

• INSERT: inserts new data into a database

• UPDATE: modifies existing data in a database

• DELETE: deletes data from a database

• CREATE: creates a new database, table, or view

• ALTER: modifies the structure of a database object

• DROP: deletes a database object

• JOIN: combines rows from two or more tables based on a re...read more
Answered by AI
Add your answer
Q4. OOPS concepts and applications
Ans. 
OOPS concepts and applications
• OOPS stands for Object-Oriented Programming System

• It is a programming paradigm that uses objects to represent and manipulate data

• Key concepts include encapsulation, inheritance, and polymorphism

• OOPS allows for modular and reusable code

• Examples of OOPS languages include Java, C++, and Python
Answered by AI
Add your answer
Q5. About project and explain in detail
Add your answer

The round consisted of 2 sections.
The first section was on Aptitude and the second round was on SQL queries.
Someone with good practice on both of this topic can easily crack the 1st round.
Bt u need to have a good cgpa atleast 8.5 to sit for the exam

Q1. 1.Various questions on supply chain 2.Then some case studies 3.Some technical questions on my projects (basic to moderate) 4.Moderate level of data analytics knowledge 5.The hard part of the interview was ...read more
Add your answer

Basic aptitude and SQL mcq questions

Q1. An interview with technical person, Questions depends on interviewer ,it might be technical, behavioural or general discussion
Add your answer
Q2. Topics related to Supply chain, Guesstimate, Questions on project
Add your answer