GEICO Senior Software Engineer Interview Questions and Answers

Q1. What are new features in java 11?
Add your answer
Q2. Explain parameterised testing in juint?
Add your answer

Q1. Tell me about yourself?
Add your answer
Q2. Introduction round about yourself
Add your answer
Q3. About work experience in past company
Add your answer

Q1. Basic Java and react question
Add your answer

Q1. Little technical and project oriented question
Add your answer

Basic hacker rank problem

Q1. Asked few questions on react and java
Add your answer

Duration : 1 hours
Question type : Greedy algo question(DSA)
Platform : of any choice

Q1. LLDs Designing on any system
Ans. 
LLDs are detailed design documents that describe the software architecture of a system.
• LLDs typically include detailed information on modules, components, interfaces, and data for a system.

• They help in understanding how different parts of the system interact and communicate with each other.

• Examples of LLDs include class diagrams, sequence diagrams, and data flow diagrams.

• LLDs are crucial for developers to implement the
Answered by AI
Add your answer

Q1. Coding plus behavioral plus LLD
Add your answer

Q1. Basic of oops concept
Add your answer
Q2. Basic of .net and design pattern
Add your answer

Q1. What are indexes in the database? what is the difference between clustered and non-clustered indexes?
Ans. 
Indexes are used to improve database performance. Clustered indexes determine the physical order of data, while non-clustered indexes do not.
• Indexes are used to speed up data retrieval operations in a database.

• Clustered indexes determine the physical order of data in a table, while non-clustered indexes do not.

• A table can have only one clustered index, but multiple non-clustered indexes.

• Clustered indexes are generally ...read more
Answered by AI
Add your answer
Q2. Write a query to delete duplicate rows from a table.
Ans. 
Query to delete duplicate rows from a table
• Use GROUP BY clause to group the rows by their unique values

• Use HAVING clause to filter out the groups with count greater than 1

• Use DELETE statement to delete the duplicate rows
Answered by AI
Add your answer
Q3. Class A { public string A() { return "hello"; } } what is wrong with above code?
Add your answer
Q4. What is a singleton pattern and how to implement it?
Ans. 
Singleton pattern restricts the instantiation of a class to a single instance and provides a global point of access to it.
• Create a private constructor to restrict instantiation of the class

• Create a private static instance of the class

• Create a public static method to access the instance

• Ensure thread safety if necessary

• Examples: Database connection, Logger, Configuration settings
Answered by AI
Add your answer
Q5. How do you handle exceptions in stored procedures?
Ans. 
Handle exceptions in stored procedures by using TRY-CATCH blocks.
• Use TRY-CATCH blocks to catch and handle exceptions

• Log the error message and severity level

• Rollback the transaction if necessary

• Rethrow the error if it cannot be handled

• Use RAISERROR to raise custom error messages
Answered by AI
Add your answer
Q6. Explain SOLID principles.
Ans. 
SOLID principles are a set of five design principles that help in creating maintainable and scalable software.
• S - Single Responsibility Principle: A class should have only one reason to change.

• O - Open-Closed Principle: Software entities should be open for extension but closed for modification.

• L - Liskov Substitution Principle: Subtypes should be substitutable for their base types.

• I - Interface Segregation Principle: C...read more
Answered by AI
Add your answer
Q7. Difference between throw and throw exception?
Ans. 
throw is used to throw an exception while throw exception is used to throw a specific exception.
• throw is used to throw any type of exception while throw exception is used to throw a specific type of exception.

• throw exception is followed by the type of exception that needs to be thrown.

• throw can be used to throw any object while throw exception can only be used to throw an exception object.

• Example: throw new Exception("
Answered by AI
Add your answer

Q1. Longest common subsequence
Ans. 
Longest common subsequence is the longest sequence of characters that appear in the same order in both strings.
• Use dynamic programming to solve this problem efficiently.

• Create a 2D array to store the lengths of longest common subsequences of substrings.

• Traverse the array to find the longest common subsequence.
Answered by AI
Add your answer
Q2. O(1) data structure
Add your answer

Q1. Java 8 features
Add your answer
Q2. Explain lamda function and thread concept
Ans. 
Lambda function is an anonymous function used for short tasks. Threads allow for concurrent execution in a program.
• Lambda function is a concise way to define small functions without a name.

• Threads allow multiple tasks to run concurrently in a program.

• Lambda functions are often used in functional programming and for callbacks.

• Threads can improve performance by utilizing multiple cores of a CPU.

• Example of lambda function...read more
Answered by AI
Add your answer
Q3. Explain cicd functionality
Ans. 
CI/CD stands for Continuous Integration/Continuous Deployment, a practice in software development to automate the process of testing and deploying code changes.
• CI/CD automates the process of integrating code changes from multiple developers into a shared repository.

• It includes automated testing to ensure that code changes do not break existing functionality.

• CI/CD also automates the deployment of code changes to product...read more
Answered by AI
Add your answer