American Express Software Engineer Interview Questions and Answers

Use SQL JOIN to find common values in two tables.

• Use INNER JOIN to combine the two tables based on a common column

• Select the columns you want to display in the result

• Add a WHERE clause to filter out non-matching values

Program to find 2nd highest number in an unsorted array.

• Sort the array in descending order and return the second element.

• Iterate through the array and keep track of the two highest numbers.

• Handle edge cases like duplicates and small array sizes.

Database sharability refers to the ability of multiple users or applications to access and modify the same database concurrently.

• Allows multiple users or applications to access and modify the same database simultaneously

• Ensures data consistency and integrity by managing concurrent access

• Commonly used in multi-user systems or applications

• Examples include online banking systems where multiple users can access their ...read more

To find the mid element in a linked list while iterating only once, we can use the two-pointer approach.

• Use two pointers, one moving at twice the speed of the other.

• When the faster pointer reaches the end of the list, the slower pointer will be at the mid element.

Spring Boot is an extension of Spring Framework that simplifies the development of Spring-based applications.

• Spring Boot provides a pre-configured environment for building applications, while Spring Framework requires more configuration.

• Spring Boot includes an embedded server, while Spring Framework requires an external server.

• Spring Boot provides a variety of starter dependencies to quickly add functionality, whi...read more

This question is about basic concepts in C and C++ programming languages.

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

• Tokens are the basic building blocks of a program, such as keywords, identifiers, operators, and literals.

• Statements are instructions that perform a specific task.

• Functions are blocks of code that perform a specific task and can be called from other parts...read more