Cygnet Infotech Associate Software Engineer Interview Questions and Answers

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

Q1. Difference between job and positions
Ans. 
A job refers to a specific task or set of tasks performed by an individual, while a position refers to a role or title within an organization.
• A job is temporary and can change frequently, while a position is more permanent and stable.

• A job can be specific to a project or assignment, while a position is typically broader and encompasses multiple tasks and responsibilities.

• A job can be held by multiple individuals at dif...read more
Answered by AI
Add your answer
Q2. Process of data migration
Ans. 
Data migration involves transferring data from one system to another while ensuring data integrity and minimal downtime.
• Identify the data to be migrated and its format

• Choose a migration method (manual or automated)

• Test the migration process on a small sample of data

• Perform the actual migration with proper backup and security measures

• Verify the migrated data for accuracy and completeness
Answered by AI
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

Q1. Decorators and oops concepts
Add your answer

Q1. College projects
Add your answer