o9 Solutions Interview Questions and Answers for Freshers

Round duration - 60 Minutes
Round difficulty - Medium

Mostly questions were of aptitude and verbal reasoning including some 5-10 questions on basics of programming and sql queries. Time was the important factor for clearing the test as questions were somewhat easy but time was limited.

Q1. Write an SQL query to find students with scores above a particular threshold and sort them according to their scores and then by their names.
Ans. 
SQL query to find and sort students with scores above a threshold
• Use the SELECT statement to retrieve the required data

• Use the WHERE clause to filter students with scores above the threshold

• Use the ORDER BY clause to sort the results by score and then by name
Answered by AI
Add your answer

Round duration - 50 minutes
Round difficulty - Medium

I was having just the second slot at 9:30 am.
Video call was done via google meet. Most of the interview went around my resume and my introduction. Interviewer was fairly impressed by my projects and discussed it in detail with me. After that he gave me a simple coding question to reverse a string and asked me to write it within 3 minutes. after that 2 questions on sql and 1 puzzle was asked.

Q1. 
Reverse the String Problem Statement
You are given a string STR which contains alphabets, numbers, and special characters. Your task is to reverse the string.
Example:
Input:
STR = "abcde"
Output:
"e...read more
Ans. 
The task is to reverse a given string that may contain lowercase letters, uppercase letters, digits, and special characters.
• Iterate through the string from the last character to the first character and append each character to a new string.

• Alternatively, you can use built-in string reversal functions or methods available in your programming language.

• To solve the follow-up question with O(1) space complexity, you can us...read more
Answered by AI
View 1 more answer
Q2. How would you fetch data from two given tables with a common column without using the WHERE keyword?
Ans. 
Fetch data from two tables with a common column without using WHERE keyword.
• Use JOIN keyword to combine the two tables based on the common column.

• Specify the common column in the ON clause of the JOIN statement.

• This will retrieve all the rows where the common column values match in both tables.
Answered by AI
Add your answer

Was test containing three sections, Aptitude test, SQL Based questions and Supply Chain domain related questions

Q1. Basic Resume based questions and few Supply chain domain based questions
Add your answer

Q1. This was final interview round where they again asked few functional and resume based questions, and few questions from past work experience
Add your answer

Round duration - 45 minutes
Round difficulty - Easy

This was a technical interview round where DSA questions were discussed. Questions on subjects related to my branch(EEE) and some questions on maths as I had mentioned my Olympiad rank were also asked.

Q1. 
Angle Calculation Between Clock Hands
Given a specific time in hours and minutes, your task is to calculate the smallest possible angle between the hour hand and the minute hand of a clock.
Example:
Inp...read more
Ans. 
Calculate the smallest angle between the hour and minute hands of a clock for a given time.
• Calculate the angles of the hour and minute hands based on the input time.

• Find the absolute difference between the angles of the hour and minute hands.

• Return the smaller angle between the two possible angles.

• Ensure to handle cases where the smaller angle is greater than 180 degrees.
Answered by AI
Add your answer
Q2. 
Factorial Calculation Problem Statement
Develop a program to compute the factorial of a given integer 'n'.
The factorial of a non-negative integer 'n', denoted as n!, is the product of all positive integ...read more
Ans. 
Develop a program to compute the factorial of a given integer 'n'.
• Create a function to calculate factorial using a loop or recursion

• Handle edge cases such as negative input or input exceeding constraints

• Return 'Error' if factorial is undefined

• Example: For input 5, output should be 120
Answered by AI
Add your answer