Omniscient Software Java Developer Interview Questions and Answers

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