Infosys Developer Interview Questions and Answers

Retrieve the second highest salary from an employee table using SQL.

• Use the 'DISTINCT' keyword to avoid duplicate salaries.

• Utilize 'ORDER BY' to sort salaries in descending order.

• Use 'LIMIT' with 'OFFSET' to skip the highest salary and get the second.

• Example query: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;

Objects in programming are instances of classes that encapsulate data and behavior.

• Objects are created from classes, which act as blueprints for the object's structure and behavior

• Objects have attributes (data) and methods (behavior) that define their characteristics and actions

• Objects allow for modular and reusable code by grouping related data and functions together

CPP is better due to its performance, memory management, and object-oriented features.

• CPP is faster than many other programming languages due to its compiled nature.

• CPP allows for manual memory management, which can lead to more efficient use of resources.

• CPP supports object-oriented programming, which can make code more modular and easier to maintain.

• CPP has a large community and many libraries available, making ...read more

The most popular SDLC model is Agile.

• Agile is iterative and flexible, allowing for changes throughout the development process.

• It emphasizes collaboration and customer satisfaction.

• Other popular models include Waterfall, Spiral, and V-Model.

• Agile is commonly used in software development, but can be applied to other industries as well.

Try-catch-finally is a mechanism for handling exceptions in programming, ensuring graceful error management.

• Try block: Contains code that may throw an exception. Example: `try { int result = 10 / 0; }`

• Catch block: Catches and handles the exception. Example: `catch (ArithmeticException e) { System.out.println(e.getMessage()); }`

• Finally block: Executes code after try/catch, regardless of whether an exception occurre...read more

C and C++ are programming languages used for system and application development.

• C is a procedural language used for system programming and embedded systems.

• C++ is an object-oriented language used for application development and game programming.

• Both languages are compiled and have a strong influence on modern programming languages.

• C++ is an extension of C with additional features like classes, templates, and excep...read more