American Express Product Intern Interview Questions and Answers

Topics that where coverd in MCQ test are OS, DBMS, OOPS, AND some CS fundamentals

Q1. What is #include
Ans. 
The #include directive is used in C and C++ programming languages to include the contents of another file in the current file.
• Used to include header files that contain function prototypes and declarations

• Improves code organization and reusability

• Example: #include includes the standard input/output library in the current file
Answered by AI
Add your answer
Q2. What are pointers
Ans. 
Pointers are variables that store memory addresses of other variables in programming languages like C and C++.
• Pointers are used to directly access and manipulate memory locations.

• They are often used for dynamic memory allocation and deallocation.

• Pointers can be used to pass variables by reference to functions.

• Example: int *ptr; // declaring a pointer variable
Answered by AI
Add your answer
Q3. What is main difference between Java and cpp
Ans. 
Java is platform-independent, object-oriented language while C++ is platform-dependent, procedural language.
• Java is platform-independent, meaning it can run on any platform with the help of Java Virtual Machine (JVM)

• C++ is platform-dependent, meaning the code needs to be compiled separately for each platform

• Java is an object-oriented language with features like inheritance, encapsulation, and polymorphism

• C++ is a proce...read more
Answered by AI
Add your answer

Q1. Resume questions
Add your answer

It was good but prepared on technical basis

Q1. What is primary key
Ans. 
Primary key is a unique identifier for each record in a database table.
• Primary key ensures each record in a table is unique

• It can be a single column or a combination of columns

• Primary key values cannot be NULL

• Example: In a table of students, student ID can be a primary key
Answered by AI
Add your answer
Q2. What is foreign key
Ans. 
Foreign key is a column or a set of columns in a table that uniquely identifies a row in another table.
• A foreign key establishes a relationship between two tables in a database.

• It ensures referential integrity by enforcing a link between the data in the two tables.

• Foreign key constraints prevent actions that would destroy links between tables, such as deleting a row that is referenced by another table.

• Example: In a dat...read more
Answered by AI
Add your answer

Work / task prioritisation

Q1. About qualifications
Add your answer

Interview with people with different roles

Q1. Joins in SQL with example
Ans. 
Joins in SQL are used to combine data from two or more tables based on a related column.
• INNER JOIN returns only the matching rows from both tables

• LEFT JOIN returns all rows from the left table and matching rows from the right table

• RIGHT JOIN returns all rows from the right table and matching rows from the left table

• FULL OUTER JOIN returns all rows from both tables

• CROSS JOIN returns the Cartesian product of both tables
Answered by AI
Add your answer
Q2. What were roles and responsibilities?
Add your answer

Case study was regarding Banking sector

Q1. What are different type of payment files you worked on?
Ans. 
I have worked on various types of payment files including ACH, wire transfers, and credit card transactions.
• ACH (Automated Clearing House) files

• Wire transfer files

• Credit card transaction files
Answered by AI
Add your answer
Q2. What is the minimum response time?
Ans. 
The minimum response time is the shortest amount of time it takes for a system to respond to a request.
• The minimum response time can vary depending on the system and its capabilities.

• Factors that can affect the minimum response time include network latency, server load, and processing speed.

• For example, a high-performance website may have a minimum response time of 100 milliseconds, while a slower system may have a min
Answered by AI
Add your answer

5 sections - Quant, DI LR, English, Stats and Big fata coding

Q1. Based on Resume and past experience
Add your answer
Q2. Situation based question - how to risk profile credit card customers
Add your answer
Q3. Python based basic coding question
Add your answer

Q1. Resume based question
Add your answer
Q2. Questions about Machine Learning
Add your answer
Q3. Leadership questions
Add your answer