The Brihaspati Infotech Software Engineer Interview Questions and Answers

Basic to medium questions on array string SQL

Q1. Project related questions
Add your answer

Basic aptitude followed with english and reasoning

Q1. Core java technical questions , spring , spring boot
Add your answer
Q2. What is JIT in java
Add your answer
Q3. Explain lifecyxle of thread in java
Ans. 
The lifecycle of a thread in Java includes several stages from creation to termination.
• A thread is created using the Thread class or implementing the Runnable interface.

• The thread goes through the new, runnable, and blocked states before running.

• Once running, the thread can be paused, resumed, or stopped.

• Finally, the thread reaches the terminated state and cannot be restarted.
Answered by AI
Add your answer

Technical questions

Q1. Questions was based on SQL
Add your answer
Q2. SQL queries and joins and
Add your answer

Q1. Explain the acid properties
Ans. 
ACID properties ensure reliable transactions in databases: Atomicity, Consistency, Isolation, Durability.
• Atomicity: Transactions are all-or-nothing. Example: If a bank transfer fails, no money is deducted.

• Consistency: Transactions must leave the database in a valid state. Example: A transaction should not violate any integrity constraints.

• Isolation: Transactions occur independently. Example: Concurrent transactions do ...read more
Answered by AI
Add your answer
Q2. Explain the indexing
Ans. 
Indexing is a data structure technique that improves the speed of data retrieval operations on a database or data set.
• Indexing creates a data structure (like a B-tree) that allows for faster searches.

• For example, a book index helps locate topics quickly without scanning every page.

• In databases, an index on a column allows for quicker query results, e.g., searching for a user by email.

• Indexes can be unique (no duplicate...read more
Answered by AI
Add your answer

Q1. What is your minimum salary expectation?
Add your answer
Q2. Are you planning to stay long-term in this position?
Ans. 
I am committed to long-term growth and contribution in this position, aligning my goals with the company's vision.
• I believe in building strong relationships with my team and the organization, which takes time and dedication.

• For example, I aim to take on increasing responsibilities and contribute to long-term projects.

• I am eager to develop my skills and grow within the company, ensuring I can add value over time.

• I see t...read more
Answered by AI
Add your answer

Q1. How internally work HashMap ?
Ans. 
HashMap uses key-value pairs, hashing, and buckets for efficient data retrieval and storage.
• HashMap stores data in key-value pairs, where each key is unique.

• It uses a hash function to compute an index (hash code) for each key.

• The computed index points to a bucket in an array where the value is stored.

• If multiple keys hash to the same index (collision), they are stored in a linked list or tree structure.

• Example: For a k...read more
Answered by AI
Add your answer
Q2. Write the logic of prime number
Ans. 
A prime number is a natural number greater than 1 that cannot be formed by multiplying two smaller natural numbers.
• A prime number has exactly two distinct positive divisors: 1 and itself.

• Examples of prime numbers include 2, 3, 5, 7, 11, and 13.

• The number 1 is not prime because it has only one positive divisor.

• The number 4 is not prime because it can be divided by 1, 2, and 4.

• To check if a number n is prime, test divisi...read more
Answered by AI
Add your answer
Q3. Difference between hash map and hash set?
Ans. 
HashMap stores key-value pairs; HashSet stores unique keys without values.
• HashMap allows duplicate values but not duplicate keys. Example: {1: 'A', 2: 'B', 1: 'C'} results in {1: 'C', 2: 'B'}.

• HashSet only stores unique elements. Example: {1, 2, 2} results in {1, 2}.

• HashMap provides O(1) average time complexity for get and put operations.

• HashSet provides O(1) average time complexity for add, remove, and contains operati...read more
Answered by AI
Add your answer