Omniscient Software Interview Questions, Process, and Tips

A basic aptitude test was conducted comprising of java logical resoaning and maths.

It was a GD where along with discussion of particular topic some tech questions were also asked.

Q1. SQL type of joints.
Ans. 
SQL joints are used to combine rows from two or more tables based on a related column between them.
• Types of SQL joints include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left t...read more
Answered by AI
Add your answer

Q1. What was your last project and the tables that were in the database.
Ans. 
My last project was a web application for a retail company. The database had tables for customers, products, orders, and inventory.
• Tables in the database: customers, products, orders, inventory

• Example: customers table had columns for customer ID, name, email, and address

• Example: products table had columns for product ID, name, price, and quantity

• Example: orders table had columns for order ID, customer ID, product ID, a...read more
Answered by AI
Add your answer

Pen Paper test aptitude test with 2 long answer questions

Q1. OOP Concepts- Polymorphism , what are its types
Ans. 
Polymorphism is the ability of a single function or method to operate on different types of data.
• Types of polymorphism: compile-time (method overloading) and runtime (method overriding)

• Compile-time polymorphism is achieved through function overloading, where multiple functions have the same name but different parameters

• Runtime polymorphism is achieved through function overriding, where a subclass provides a specific im...read more
Answered by AI
Add your answer
Q2. Coding question to find the first occurring letter in a string
Ans. 
Find the first occurring letter in a string
• Iterate through the string and store the count of each letter in a hashmap

• Return the first letter with count 1
Answered by AI
Add your answer

In this round they asked 20 technical questions on java and 10 analytical question on reasoning and 3 theory questions we need to solve only 2 out of 3 total 32 questions are there in first round.

In the GD they ask about your projects

Duration was 1 hour, there were 10 quantitative questions and 20 technical questions based on c, java, dbms.

GD was of 10 minutes per group, topics were e-learning platform, impact of AI, ect.

Q1. OOPS Concepts of java
Ans. 
OOPS concepts in Java refer to the principles of Object-Oriented Programming such as Inheritance, Encapsulation, Polymorphism, and Abstraction.
• Inheritance: Allows a class to inherit properties and behavior from another class.

• Encapsulation: Bundling data and methods that operate on the data into a single unit.

• Polymorphism: Ability of a method to do different things based on the object it is acting upon.

• Abstraction: Hidi...read more
Answered by AI
Add your answer
Q2. About project done at graduation
Add your answer