o9 Solutions Associate Consultant Interview Questions and Answers

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