Infosys Senior Software Engineer Interview Questions and Answers

To reverse records in a ps file, you can use command-line tools like awk, sed, or sort.

• Use 'tac' command: 'tac filename.ps' reverses the order of lines in the file.

• With 'awk': 'awk '{print}' filename.ps | tac' can also achieve the same result.

• Using 'sed': 'sed -n '1!G;h;$p' filename.ps' reverses the lines.

• For specific fields, consider using 'cut' in combination with 'tac'.

SQL (Structured Query Language) is a standard language for managing and manipulating relational databases.

• SQL is used to perform tasks such as querying data, updating records, and managing database structures.

• Common SQL commands include SELECT (to retrieve data), INSERT (to add data), UPDATE (to modify data), and DELETE (to remove data).

• SQL supports various data types, including INTEGER, VARCHAR, DATE, and BOOLEAN...read more

The ideal team size varies, but typically ranges from 5 to 9 members for optimal collaboration and productivity.

• Smaller teams (5-7 members) often communicate more effectively, like a startup environment.

• Larger teams (8-12 members) can bring diverse skills but may face coordination challenges.

• Agile methodologies suggest 7 +/- 2 as the ideal team size for Scrum teams.

• Example: Google often uses small teams to foster ...read more

final is a keyword used to declare constants, finally is used in exception handling, and finalize is a method used for cleanup.

• final is used to declare constants in Java, preventing them from being modified

• finally is used in exception handling to define a block of code that will always be executed

• finalize is a method in Java that is called by the garbage collector before an object is destroyed

Use a key-value pair approach with a flexible schema to accommodate varying columns.

• Utilize a key-value store like MongoDB or a NoSQL database for flexibility.

• Store data as key-value pairs where the key represents the column name and the value is the data.

• Implement a dynamic schema design to allow for adding new columns without altering the database structure.

• Consider using JSON or XML data formats to store the dy...read more

Create a global exception handler to manage all unhandled exceptions in the application.

• Implement a global exception handler class that extends ExceptionHandler.

• Override the uncaughtException method to handle all unhandled exceptions.

• Log the exception details and notify the user about the error.

• Consider implementing different strategies for handling different types of exceptions.

• Test the global exception handler t...read more

Use a SQL query with ORDER BY and LIMIT to find the 2nd last student marks.

• Use ORDER BY clause to sort the marks in descending order

• Use LIMIT 1,1 to skip the last row and fetch the 2nd last row

Java avoids multiple inheritance to prevent complexity and ambiguity, particularly the diamond problem.

• Multiple inheritance can lead to the 'diamond problem', where a class inherits from two classes that have a common ancestor.

• For example, if class A has methods that are overridden in classes B and C, and class D inherits from both B and C, it becomes ambiguous which method D should inherit.

• Java uses interfaces to...read more