DivIni Software Senior Software Engineer Interview Questions and Answers for Experienced

Q1. What is hibernate transaction?
Ans. 
Hibernate transaction is a way to manage database transactions in Hibernate framework.
• Hibernate transaction allows grouping multiple database operations into a single unit of work.

• It ensures data consistency and integrity by either committing all changes or rolling back in case of failure.

• Transactions in Hibernate are managed using Session interface.

• Example: session.beginTransaction(); session.save(entity); session.get
Answered by AI
Add your answer
Q2. How to handle million of data which need to be save in the DB?
Ans. 
Use efficient database design, indexing, partitioning, and caching to handle large amounts of data.
• Optimize database schema for efficient storage and retrieval.

• Implement indexing on frequently queried columns to speed up search operations.

• Partition data to distribute load across multiple servers or disks.

• Utilize caching mechanisms like Redis or Memcached to reduce database load.

• Consider using sharding to horizontally s...read more
Answered by AI
Add your answer

They give a standard application to develop in mvvm or clean architecture, don't forget to write unit tests

Q1. Mostly discuss on the implementation of the project you've done in round one
Add your answer
Q2. Flutter is addon
Ans. 
Flutter is a UI toolkit for building natively compiled applications for mobile, web, and desktop from a single codebase.
• Flutter is an open-source framework developed by Google.

• It uses the Dart programming language.

• Flutter allows for hot reload, which enables developers to see changes instantly.

• It provides a rich set of pre-built widgets for building user interfaces.

• Flutter can be used to create apps for iOS, Android, w
Answered by AI
Add your answer
Q3. Explain about compose way of thinking.
Ans. 
Compose way of thinking involves breaking down complex problems into smaller, manageable parts and then combining them to create a solution.
• Break down a problem into smaller components

• Solve each component individually

• Combine the solutions to create a complete solution

• Example: Using functions to break down a complex task into smaller functions and then combining them to achieve the desired outcome
Answered by AI
Add your answer
Q4. Difference between presenter and viewmodel
Add your answer
Q5. Explain about lifecycle of view
Ans. 
Lifecycle of view refers to the stages a view goes through from creation to destruction in an application.
• Creation: View is initialized and loaded into memory.

• Layout: View is positioned and sized on the screen.

• Display: View is rendered and displayed to the user.

• Interaction: User interacts with the view through input events.

• Destruction: View is removed from memory when no longer needed.
Answered by AI
Add your answer

Q1. About prev project experience
Add your answer

Aptitude test was taken for campus placements.

Q1. Question was asked about college project
Add your answer
Q2. Basic of Java programming and sql
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. Angular concepts like : Interpolation, services, directives, pipes
Add your answer
Q2. Observables, promises, components
Add your answer

Q1. Extension methods in C#
Ans. 
Extension methods allow adding functionality to existing types without modifying them.
• Extension methods are defined in a static class.

• They must be marked with the 'this' keyword before the first parameter.

• They can be called on instances of the extended type as if they were instance methods.

• Extension methods can be used to add functionality to third-party or built-in types.

• Example: 'myString.Reverse()' where 'Reverse' i
Answered by AI
Add your answer
Q2. When an int is declare with 0 value and passed as an out parameter to a method what will be the output
Ans. 
The output will depend on the implementation of the method.
• The method may or may not modify the value of the int parameter.

• The method may or may not return a value based on the int parameter.

• Without knowing the implementation of the method, it is impossible to predict the output.
Answered by AI
Add your answer
Q3. How do you inherit a partial class
Ans. 
To inherit a partial class, use the 'partial' keyword in both the base and derived classes.
• Use the 'partial' keyword in both the base and derived classes

• Ensure that the partial classes have the same name and are in the same namespace

• Add the necessary code to the derived class to inherit the properties and methods from the base class
Answered by AI
Add your answer
Q4. What is "using" keyword
Ans. 
The 'using' keyword is used in C# to declare a code block that uses an object and automatically disposes of it when done.
• The 'using' keyword is followed by a set of parentheses that contain the object to be used.

• The object must implement the IDisposable interface.

• The 'using' block ensures that the object is disposed of when the block is exited, even if an exception is thrown.

• Example: using (FileStream fileStream = new ...read more
Answered by AI
Add your answer
Q5. Tools in visual studio for memory management, rectify unused variable and unnecessary code
Add your answer
Q6. Why do we need WebAPIs
Ans. 
WebAPIs allow communication between different systems and enable access to data and functionality over the internet.
• WebAPIs provide a standardized way for different systems to communicate with each other over the internet.

• They allow access to data and functionality from remote servers, enabling the creation of web and mobile applications.

• WebAPIs can be used to integrate different systems, such as payment gateways, soci...read more
Answered by AI
Add your answer
Q7. Can DML statements be written in functions
Ans. 
Yes, DML statements can be written in functions.
• Functions can contain DML statements like INSERT, UPDATE, DELETE.

• Functions can also return values based on the DML statements executed.

• However, functions cannot be used to execute DDL statements like CREATE or ALTER.
Answered by AI
Add your answer
Q8. What are triggers in sql
Ans. 
Triggers in SQL are special types of stored procedures that are automatically executed in response to certain events.
• Triggers can be used to enforce business rules or data integrity

• They can be executed before or after an INSERT, UPDATE, or DELETE statement

• Triggers can also be used to audit changes to data

• Examples of triggers include sending an email notification when a new record is inserted or updating a related table
Answered by AI
Add your answer
Q9. How to you fetch a record from table
Ans. 
To fetch a record from a table, use SELECT statement with appropriate conditions.
• Use SELECT statement with appropriate columns and table name

• Add conditions using WHERE clause to filter the record

• Use LIMIT clause to limit the number of records returned

• Example: SELECT * FROM users WHERE id = 1 LIMIT 1
Answered by AI
Add your answer
Q10. Inbuilt methods that follow overriding
Ans. 
Inbuilt methods that follow overriding
• In Java, methods that can be overridden are marked with the 'override' keyword

• The overridden method must have the same name, return type, and parameters as the original method

• The 'super' keyword can be used to call the overridden method from the subclass

• Overriding can be used to provide a different implementation of a method in a subclass
Answered by AI
Add your answer

Q1. Your aspirations and reason for job change.
Ans. 
Seeking new challenges and opportunities for growth in a dynamic environment.
• Looking to expand my skill set and take on more responsibilities

• Interested in working on cutting-edge technologies and projects

• Seeking a company culture that values innovation and collaboration
Answered by AI
Add your answer