KGISL Associate Software Engineer Interview Questions and Answers

Questions was regarding sql queries mostly

Q1. Basic question regarding sql like aggregate functions , joins
Add your answer
Q2. Told to write sql query scenario based question
Add your answer

Q1. Java , collection , spring boot
Add your answer
Q2. What is internal working of hashmap
Ans. 
HashMap is a data structure that stores key-value pairs and uses hashing to efficiently retrieve values.
• HashMap internally uses an array of linked lists to store key-value pairs.

• When a key-value pair is added, the key is hashed to determine the index in the array where it will be stored.

• If multiple keys hash to the same index, a linked list is used to handle collisions.

• To retrieve a value, the key is hashed again to fi...read more
Answered by AI
Add your answer

Q1. Spring security, oops , hibernate
Add your answer

Aptitude and logical reasoning

String problem
basic java

Q1. Tell me about yourself
Add your answer
Q2. Describe your passion
Add your answer
Q3. Why should i hire you
Add your answer

Group discussion was on a topic not related to computer science. It was a topic that anyone could speak.

Q1. Explain where clause in sql
Ans. 
WHERE clause is used to filter data in SQL queries.
• WHERE clause is used after the FROM clause in a SQL query.

• It is used to specify a condition that must be met for the query to return data.

• Multiple conditions can be combined using logical operators such as AND and OR.

• Examples: SELECT * FROM customers WHERE age > 18;

• Examples: SELECT * FROM orders WHERE status = 'shipped' AND total_amount > 1000;
Answered by AI
Add your answer
Q2. Explain joins in sql
Ans. 
Joins in SQL are used to combine data from two or more tables based on a related column.
• Joins are used to retrieve data from multiple tables in a single query

• There are different types of joins such as inner join, left join, right join, and full outer join

• Inner join returns only the matching rows from both tables

• Left join returns all the rows from the left table and matching rows from the right table

• Right join returns a...read more
Answered by AI
Add your answer

Q1. Bubble sort code
Add your answer
Q2. 2nd max salary sql query
Add your answer
Q3. Linked list implementation
Ans. 
Linked list is a data structure where each element points to the next element in the sequence.
• Nodes contain data and a reference to the next node

• Operations include insertion, deletion, and traversal

• Example: Singly linked list: 1 -> 2 -> 3 -> null
Answered by AI
Add your answer