Add office photos
Employer?
Claim Account for FREE

American Express

4.2
based on 3.1k Reviews
Video summary
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by

100+ TTK Prestige Interview Questions and Answers

Updated 20 Feb 2025
Popular Designations

Q101. How do you handle major outages in your Apps

Ans.

I handle major outages in my Apps by following a structured incident response process.

  • Immediately assess the impact and severity of the outage

  • Communicate with stakeholders and provide regular updates

  • Engage the necessary technical teams to troubleshoot and resolve the issue

  • Conduct a post-mortem analysis to identify root causes and prevent future outages

Add your answer

Q102. How AMEX is different from Visa/Master card?

Ans.

AMEX offers charge cards while Visa/Mastercard offer credit cards. AMEX has higher fees but better rewards.

  • AMEX is a charge card, requiring full payment each month, while Visa/Mastercard offer credit cards with the option to carry a balance.

  • AMEX typically has higher annual fees compared to Visa/Mastercard.

  • AMEX is known for its premium rewards and benefits, catering to a more affluent customer base.

  • Visa/Mastercard are accepted at more locations worldwide compared to AMEX.

Add your answer

Q103. What do you know of american financial markets

Ans.

American financial markets refer to the various exchanges and platforms where securities are bought and sold in the United States.

  • American financial markets include major stock exchanges like the New York Stock Exchange (NYSE) and the NASDAQ.

  • They also encompass bond markets, commodity markets, and derivative markets.

  • Regulatory bodies like the Securities and Exchange Commission (SEC) oversee these markets to ensure fair trading practices.

  • Investors can trade a wide range of fin...read more

Add your answer

Q104. What fo you understand by credit card company

Ans.

A credit card company is a financial institution that issues credit cards to consumers for making purchases and borrowing money.

  • Credit card companies issue credit cards to consumers for making purchases and borrowing money

  • They charge interest on outstanding balances and fees for late payments

  • They provide customer service for cardholders and handle disputes and fraud claims

  • Examples include Visa, Mastercard, American Express, and Discover

Add your answer
Discover TTK Prestige interview dos and don'ts from real experiences

Q105. How to use joins in SQL?

Ans.

Joins are used to combine data from two or more tables based on a related column.

  • Use JOIN keyword followed by the name of the table to join

  • Specify the columns to join on using ON keyword

  • Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN

  • Example: SELECT * FROM table1 JOIN table2 ON table1.column = table2.column

  • Use aliases to simplify the query

View 2 more answers

Q106. How to convince the customer to buy the product?

Ans.

To convince the customer to buy the product, focus on highlighting its benefits, addressing their needs, building trust, and offering incentives.

  • Highlight the unique features and benefits of the product

  • Address the customer's needs and pain points

  • Build trust by providing testimonials or case studies

  • Offer incentives such as discounts, free trials, or guarantees

  • Provide excellent customer service and support

Add your answer
Are these interview questions helpful?

Q107. How to implement security in microservices

Ans.

Implement security in microservices by using authentication, authorization, encryption, and monitoring.

  • Use authentication mechanisms like OAuth, JWT, or API keys to verify the identity of clients accessing the microservices.

  • Implement authorization controls to define what actions users can perform within the microservices.

  • Encrypt data in transit and at rest using protocols like HTTPS and TLS, and tools like Vault or AWS KMS.

  • Implement monitoring and logging to detect and respon...read more

Add your answer

Q108. What do you know about Amex?

Ans.

Amex is a financial services company known for its credit cards and charge cards.

  • Amex stands for American Express.

  • It was founded in 1850 and is headquartered in New York City.

  • Amex offers a variety of credit cards, including rewards cards and travel cards.

  • It also offers charge cards, which require the balance to be paid in full each month.

  • Amex is known for its customer service and perks, such as airport lounge access and travel insurance.

Add your answer
Share interview questions and help millions of jobseekers 🌟

Q109. 1) Difference between Inner join and outer join. Explain it to a non technical person

Ans.

Inner join combines only matching rows from two tables, while outer join includes all rows from one table and only matching rows from the other.

  • Inner join only includes rows that have matching values in both tables

  • Outer join includes all rows from one table and only matching rows from the other

  • Example: Inner join would return only customers who have made a purchase, while outer join would return all customers with their purchases if available

Add your answer

Q110. Difference between Spring & Spring Boot

Ans.

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, while Spring Framework requires manual dependency management.

  • Sprin...read more

Add your answer

Q111. Difference between query and path param in spring boot

Ans.

Query param is used to pass parameters in the URL query string, while path param is used to define parameters in the URL path itself.

  • Query param is specified after the '?' in the URL, like '?param=value'

  • Path param is specified in the URL path itself, like '/{param}'

  • Query params are optional and can be used for filtering or sorting data

  • Path params are used to define variables in the URL path, like IDs or names

Add your answer

Q112. How did you align a person not perfoming well

Ans.

I addressed poor performance by setting clear expectations, providing feedback, offering support, and creating a performance improvement plan.

  • Set clear expectations and goals for the individual

  • Provide constructive feedback on areas of improvement

  • Offer support and resources to help the person succeed

  • Create a performance improvement plan with specific steps and timelines

  • Regularly monitor progress and provide ongoing feedback

Add your answer

Q113. Deep equations and understading of DL and ML Algorithms

Ans.

Understanding deep equations and algorithms in DL and ML is crucial for a data scientist.

  • Deep learning involves complex neural network architectures like CNNs and RNNs.

  • Machine learning algorithms include decision trees, SVM, k-means clustering, etc.

  • Understanding the math behind algorithms helps in optimizing model performance.

  • Equations like gradient descent, backpropagation, and loss functions are key concepts.

  • Practical experience with implementing algorithms in Python or R i...read more

Add your answer

Q114. How to copy one file to another

Ans.

Use a file copy command to copy one file to another

  • Use the 'cp' command in Unix/Linux systems

  • Syntax: cp source_file destination_file

  • Example: cp file1.txt file2.txt

Add your answer

Q115. How to manage multiple stakeholders?

Ans.

Managing multiple stakeholders requires clear communication, prioritization, and active listening.

  • Identify key stakeholders and their interests

  • Establish clear communication channels and expectations

  • Prioritize stakeholder needs and manage expectations

  • Actively listen to feedback and adjust accordingly

  • Maintain transparency and keep stakeholders informed

  • Address conflicts and concerns proactively

Add your answer

Q116. How sort function works in cpp

Ans.

Sort function in C++ sorts elements in an array in ascending or descending order.

  • The sort function is part of the library in C++.

  • It takes two iterators as arguments, representing the beginning and end of the array to be sorted.

  • By default, it sorts the array in ascending order, but a custom comparison function can be provided to sort in descending order.

  • The time complexity of the sort function is O(n log n).

Add your answer

Q117. What is curse of dimensionality

Ans.

Curse of dimensionality refers to the issues that arise when working with high-dimensional data, leading to increased computational complexity and sparsity of data points.

  • High-dimensional data requires exponentially more data points to maintain the same level of data density.

  • Distance between data points becomes less meaningful as dimensions increase, making it harder to interpret relationships.

  • Increased computational complexity and storage requirements when working with high-...read more

Add your answer

Q118. what is DHCP and explain FSMO rules?

Ans.

DHCP is a network protocol that automatically assigns IP addresses to devices. FSMO rules are roles in Active Directory that control specific operations.

  • DHCP stands for Dynamic Host Configuration Protocol

  • DHCP automatically assigns IP addresses to devices on a network

  • FSMO (Flexible Single Master Operations) roles are specialized roles in Active Directory that control specific operations like schema master, domain naming master, etc.

Add your answer

Q119. SQL Query of case when then statement

Ans.

SQL query using CASE WHEN THEN statement

  • Use CASE WHEN statement to create conditional logic in SQL queries

  • Syntax: SELECT column_name, CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ELSE result3 END AS new_column_name FROM table_name

  • Example: SELECT name, CASE WHEN age < 18 THEN 'Minor' ELSE 'Adult' END AS age_group FROM customers

Add your answer

Q120. How credit card companies make money

Add your answer

Q121. Find top 3 horses from 25 horses set

Ans.

To find the top 3 horses from a set of 25 horses, we can sort them based on their performance or rankings.

  • Sort the horses based on their performance or rankings

  • Select the top 3 horses from the sorted list

  • Consider factors like speed, endurance, and previous race results

Add your answer

Q122. Explain oop concepts class, encapsulation etc

Ans.

OOP concepts include class, encapsulation, inheritance, and polymorphism.

  • Class is a blueprint for creating objects with shared properties and methods.

  • Encapsulation is the practice of hiding implementation details and exposing only necessary information.

  • Inheritance allows a class to inherit properties and methods from a parent class.

  • Polymorphism allows objects to take on multiple forms or behaviors depending on the context.

  • Example: A class 'Car' can have properties like 'make'...read more

Add your answer

Q123. How to convince customer to pay more

Ans.

Convince customers to pay more by highlighting the value of the product/service, offering discounts for early payment, and providing flexible payment options.

  • Highlight the value of the product/service and how it meets the customer's needs

  • Offer discounts for early payment to incentivize prompt payment

  • Provide flexible payment options such as installment plans or payment extensions

  • Emphasize the benefits of paying more, such as access to premium features or exclusive offers

Add your answer

Q124. Estimate the number of credit cards in India?

Ans.

The number of credit cards in India can be estimated based on population, income levels, banking penetration, and consumer spending habits.

  • Estimate based on population size and percentage of population with access to banking services

  • Consider income levels and consumer spending habits to gauge demand for credit cards

  • Look at the number of active credit card users in India and extrapolate to estimate total number of credit cards

  • Take into account the growth rate of credit card us...read more

Add your answer

Q125. Explain difference between threat, vulnerability and risk with examples

Ans.

Threat is a potential danger, vulnerability is a weakness that can be exploited, and risk is the likelihood of a threat exploiting a vulnerability.

  • Threat: External or internal factor that can cause harm to an organization's assets (e.g. malware, hackers, natural disasters)

  • Vulnerability: Weakness in a system or process that can be exploited by a threat (e.g. outdated software, lack of encryption)

  • Risk: The likelihood of a threat exploiting a vulnerability and the impact it woul...read more

Add your answer

Q126. Difference between union and union all

Ans.

Union combines and removes duplicates, Union All combines all rows including duplicates.

  • Union removes duplicates from the result set, while Union All does not.

  • Union is slower than Union All because it has to perform an additional step to remove duplicates.

  • Union is used when you want to combine and remove duplicates, while Union All is used when you want to combine all rows including duplicates.

Add your answer

Q127. Understanding of NPs and it's calculation

Ans.

NPs are numerical values used to measure the performance of a process or system.

  • NPs stand for Numerical Performance

  • They are used to measure the efficiency and effectiveness of a process or system

  • Calculation of NPs involves defining the desired outcome, measuring the actual outcome, and comparing the two

  • Examples of NPs include customer satisfaction scores, defect rates, and cycle time

  • NPs can be used to identify areas for improvement and track progress over time

Add your answer

Q128. Factors to account for ATM placements in city?

Ans.

Factors such as foot traffic, proximity to banks, crime rates, and demographics should be considered for ATM placements in a city.

  • Foot traffic in the area

  • Proximity to banks or financial institutions

  • Crime rates in the neighborhood

  • Demographics of the area (income levels, age groups)

  • Accessibility and visibility of the location

  • Local regulations and zoning laws

  • Availability of power and network connections

  • Competition from other ATMs or financial services

  • Potential for growth and dev...read more

Add your answer

Q129. 3 ants around a triangle problem

Ans.

Three ants are at the corners of an equilateral triangle. Each ant randomly picks a direction and starts moving. What is the probability that they do not collide?

  • Calculate the probability of each ant moving in a direction that does not lead to a collision.

  • Consider the possible outcomes for each ant and calculate the total number of favorable outcomes.

  • Divide the number of favorable outcomes by the total number of possible outcomes to find the probability of no collision.

Add your answer

Q130. What interest you in data analysis

Ans.

I am fascinated by the ability to uncover insights and make informed decisions based on data analysis.

  • Data analysis allows me to identify trends and patterns in data that can drive business decisions

  • I enjoy the challenge of transforming raw data into meaningful information

  • Data analysis helps me understand customer behavior and preferences, leading to improved strategies and outcomes

Add your answer

Q131. How does Amex earns money?

Ans.

American Express earns money primarily through fees charged to merchants and cardholders, interest on outstanding balances, and investment income.

  • Merchant fees: Amex charges merchants a fee for accepting their cards as payment, typically higher than other credit card companies.

  • Cardholder fees: Amex charges annual fees, late fees, and foreign transaction fees to cardholders.

  • Interest income: Amex earns interest on outstanding balances from cardholders who carry a balance from m...read more

Add your answer

Q132. How does Amex make money?

Ans.

American Express makes money primarily through fees charged to merchants and cardholders, as well as interest on outstanding balances.

  • Merchant discount fees charged to businesses for accepting Amex cards

  • Annual fees and interest charges on cardholders' balances

  • Foreign exchange fees for international transactions

  • Lending and investment services

  • Partnerships with other companies for co-branded cards

Add your answer

Q133. Guwss no. Of credits cards in india

Ans.

The number of credit cards in India is constantly changing due to various factors such as economic conditions and consumer behavior.

  • The number of credit cards in India is estimated to be around 50-60 million.

  • The number of credit cards issued in India has been steadily increasing over the years.

  • Major credit card issuers in India include HDFC Bank, ICICI Bank, SBI, and Axis Bank.

Add your answer

Q134. What are KRA'S?

Ans.

KRA's are Key Result Areas, which are specific areas of focus that define an individual's or organization's goals and objectives.

  • KRA's are used to measure and evaluate performance.

  • They help in setting clear expectations and priorities.

  • KRA's are typically aligned with the overall goals and objectives of the organization.

  • Examples of KRA's for a Complaint Analyst could be: reducing customer complaints by a certain percentage, improving complaint resolution time, increasing custo...read more

View 1 answer

Q135. How to motivate staffs Chemicals Chalanges

Ans.

Motivating staff in housekeeping involves recognition, communication, and training.

  • Recognize and reward good performance

  • Communicate regularly and provide feedback

  • Offer training and development opportunities

  • Set clear goals and expectations

  • Lead by example and maintain a positive attitude

  • Encourage teamwork and collaboration

  • Provide a safe and comfortable work environment

  • Address any concerns or issues promptly

  • Celebrate successes and milestones

Add your answer

Q136. How to you train XG boost model

Ans.

XGBoost model is trained by specifying parameters, splitting data into training and validation sets, fitting the model, and tuning hyperparameters.

  • Specify parameters for XGBoost model such as learning rate, max depth, and number of trees

  • Split data into training and validation sets using train_test_split function

  • Fit the XGBoost model on training data using fit method

  • Tune hyperparameters using techniques like grid search or random search

Add your answer

Q137. How set firewall outside Policy?

Ans.

To set firewall outside policy, you need to adjust the rules and configurations to allow or block specific traffic.

  • Review the current firewall policy to understand what is allowed and what is blocked

  • Identify the specific traffic or IP addresses that need to be allowed or blocked

  • Adjust the firewall rules and configurations accordingly

  • Test the changes to ensure they are working as intended

Add your answer

Q138. Machine learning models known

Ans.

Machine learning models are algorithms that can learn from data and make predictions or decisions.

  • Supervised learning models (e.g. linear regression, decision trees, neural networks)

  • Unsupervised learning models (e.g. clustering, dimensionality reduction)

  • Reinforcement learning models (e.g. Q-learning, policy gradients)

  • Deep learning models (e.g. convolutional neural networks, recurrent neural networks)

  • Natural language processing models (e.g. sentiment analysis, language transla...read more

Add your answer

Q139. Tell me about your projec5

Ans.

I led a project to streamline inventory management processes for a retail company.

  • Identified inefficiencies in current inventory management system

  • Implemented barcode scanning system to track inventory in real-time

  • Collaborated with cross-functional teams to ensure successful implementation

Add your answer

Q140. What is a dispute?

Ans.

A dispute is a disagreement or argument between two or more parties over a particular issue.

  • Disputes can arise in various settings such as personal, professional, legal, or political.

  • They can be resolved through negotiation, mediation, arbitration, or litigation.

  • Examples of disputes include contract disputes, property disputes, employment disputes, and family disputes.

Add your answer

Q141. How can u make sell on daily basis

Ans.

By identifying potential leads, building relationships, understanding customer needs, and offering solutions.

  • Identify potential leads through networking, cold calling, and referrals.

  • Build relationships with customers by providing excellent customer service and follow-up.

  • Understand customer needs by asking probing questions and actively listening.

  • Offer solutions that meet the customer's needs and provide value.

  • Follow up with customers to ensure satisfaction and secure repeat b...read more

Add your answer

Q142. A program to print 1 to n prime numbers

Ans.

Program to print 1 to n prime numbers

  • Iterate from 2 to n and check if each number is prime

  • Use a function to check if a number is prime

  • Print the prime numbers found

Add your answer

Q143. How do you define model Gini?

Ans.

Model Gini is a measure of statistical dispersion used to evaluate the performance of classification models.

  • Model Gini is calculated as twice the area between the ROC curve and the diagonal line (random model).

  • It ranges from 0 (worst model) to 1 (best model), with higher values indicating better model performance.

  • A Gini coefficient of 0.5 indicates a model that is no better than random guessing.

  • Commonly used in credit scoring and binary classification problems.

Add your answer

Q144. What is database sharability?

Ans.

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 accounts at the same time

Add your answer

Q145. Technology is good or bad?

Ans.

Technology is neither inherently good nor bad, but its impact depends on how it is used.

  • Technology has revolutionized communication, making it easier and faster.

  • It has improved efficiency and productivity in various industries.

  • Technology has enabled advancements in healthcare, leading to better treatments and diagnostics.

  • However, technology can also be misused, leading to privacy concerns and cybercrimes.

  • It can contribute to social isolation and addiction.

  • The ethical implicat...read more

View 1 answer

Q146. What all technology do I know

Add your answer

Q147. How can concatenate in sql?

Ans.

Concatenate in SQL is done using the CONCAT function or the + operator.

  • Use the CONCAT function to concatenate strings in SQL, for example: SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM employees;

  • Alternatively, you can use the + operator to concatenate strings, for example: SELECT first_name + ' ' + last_name AS full_name FROM employees;

Add your answer

Q148. Difference between abstract and interface

Ans.

Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.

  • Abstract class can have constructors, fields, and methods, while interface cannot have any of these.

  • A class can extend only one abstract class, but can implement multiple interfaces.

  • Abstract classes are used to provide a common base for subclasses, while interfaces are used to define a contract for classes to implement.

  • Example: Abstract class 'Animal' with abstract m...read more

Add your answer

Q149. What does Analyst do?

Ans.

Analysts gather, interpret, and present data to help organizations make informed decisions.

  • Analyze data to identify trends and patterns

  • Create reports and presentations to communicate findings

  • Provide recommendations based on data analysis

  • Use tools like Excel, SQL, and Tableau for data analysis

  • Work closely with stakeholders to understand business needs

Add your answer

Q150. Revenue sources for American Express

Ans.

American Express generates revenue from various sources including card fees, interest income, and merchant fees.

  • Card fees from annual fees, late fees, and foreign transaction fees

  • Interest income from carrying balances on credit cards

  • Merchant fees from transactions made with American Express cards

Add your answer

Q151. Flatten a tree in right preorder

Ans.

Flatten a tree in right preorder

  • Traverse the tree in right-preorder (root, right, left)

  • Use a stack to keep track of nodes

  • Pop nodes from stack and add to result array

Add your answer

Q152. What is bug life cycle

Ans.

Bug life cycle is the process of identifying, reporting, fixing, retesting, and closing a software bug.

  • Bug identification: Bug is identified by QA engineer during testing.

  • Bug reporting: QA engineer reports the bug with detailed information.

  • Bug fixing: Developer fixes the bug based on the reported details.

  • Bug retesting: QA engineer retests the fixed bug to ensure it is resolved.

  • Bug closing: Once the bug is confirmed fixed, it is closed.

Add your answer

Q153. Difference between array and array list

Ans.

Arrays have fixed size, while ArrayLists can dynamically resize. ArrayLists are part of Java Collections framework.

  • Arrays have a fixed size, while ArrayLists can dynamically resize.

  • Arrays can hold primitive data types and objects, while ArrayLists can only hold objects.

  • Arrays use square brackets [] for declaration, while ArrayLists use angle brackets <>.

  • Arrays are faster than ArrayLists for accessing elements directly by index.

  • Example: String[] names = new String[5]; ArrayLis...read more

Add your answer

Q154. how to debug and optimize code

Ans.

Debugging and optimizing code involves identifying and fixing errors and improving performance.

  • Use debugging tools like breakpoints, print statements, and logging to identify issues

  • Analyze code for inefficiencies and refactor where necessary

  • Optimize algorithms and data structures for better performance

  • Profile code to identify bottlenecks and optimize critical sections

  • Test changes to ensure they improve performance without introducing new bugs

Add your answer

Q155. How do you manage conflict?

Ans.

I manage conflict by actively listening, seeking common ground, and finding mutually beneficial solutions.

  • Actively listen to all parties involved to understand their perspectives

  • Seek common ground and areas of agreement to build rapport

  • Focus on finding mutually beneficial solutions rather than 'winning'

  • Communicate openly and honestly to address any misunderstandings or miscommunications

Add your answer

Q156. How AMEX makes money?

Ans.

American Express makes money primarily through fees charged to merchants and cardholders, as well as interest on outstanding balances.

  • AMEX charges merchants a fee for accepting their cards, known as interchange fees.

  • Cardholders pay annual fees, late fees, and interest on balances carried over from month to month.

  • AMEX also earns revenue from its travel services, insurance products, and investment services.

  • The company may also generate income from foreign exchange fees and part...read more

Add your answer

Q157. Explain Singleton design pattern.

Ans.

Singleton design pattern restricts the instantiation of a class to one object.

  • Ensures only one instance of a class exists in the system

  • Provides a global point of access to that instance

  • Used when only one instance of a class is required throughout the system

  • Example: Database connection manager, Logger class

Add your answer

Q158. What is regression

Ans.

Regression is a statistical technique used to understand the relationship between variables and make predictions based on that relationship.

  • Regression helps in identifying the strength and direction of the relationship between variables.

  • It is used to predict the value of a dependent variable based on one or more independent variables.

  • Common types of regression include linear regression, logistic regression, and polynomial regression.

  • Example: Predicting sales based on advertis...read more

Add your answer

Q159. Sale me anything.

Ans.

Introducing the revolutionary product that will change your life!

  • Our product is the solution to all your problems

  • It is affordable and easy to use

  • It has been tested and proven to be effective

  • Don't miss out on this life-changing opportunity

View 1 answer

Q160. Perform your perfect business pitch

Ans.

My perfect business pitch focuses on the unique value proposition, target market, and growth potential.

  • Start with a strong hook to grab attention

  • Clearly explain the problem your product/service solves

  • Highlight the unique features and benefits of your offering

  • Demonstrate market demand and potential for growth

  • Showcase your team's expertise and credibility

  • End with a call to action for next steps

Add your answer

Q161. What is p value?

Ans.

A p-value is a measure used in statistical hypothesis testing to determine the strength of evidence against the null hypothesis.

  • A p-value is the probability of obtaining results as extreme as the observed results, assuming the null hypothesis is true.

  • A p-value is compared to a significance level (usually 0.05) to determine if the null hypothesis should be rejected.

  • A p-value less than the significance level indicates strong evidence against the null hypothesis.

Add your answer

Q162. difference between append() and concat

Ans.

append() adds elements to a single DataFrame, while concat() combines multiple DataFrames.

  • append() is a method used to add rows to a DataFrame.

  • concat() is a function used to combine multiple DataFrames along a particular axis.

  • append() modifies the original DataFrame, while concat() returns a new DataFrame.

  • Example: df1.append(df2) vs pd.concat([df1, df2])

Add your answer

Q163. Write query for duplicate records

Ans.

Query to find duplicate records in a database table

  • Use GROUP BY clause with HAVING COUNT() function to identify duplicate records

  • Select columns to display duplicate records

  • Example: SELECT column1, column2, COUNT(*) FROM table_name GROUP BY column1, column2 HAVING COUNT(*) > 1

Add your answer

Q164. height of tree using Tree traversal

Ans.

Calculate the height of a tree using tree traversal algorithm.

  • Use depth-first search (DFS) or breadth-first search (BFS) to traverse the tree and calculate the height.

  • For DFS, recursively traverse each subtree and return the maximum height of the left and right subtrees.

  • For BFS, use a queue to traverse each level of the tree and increment the height at each level.

  • The height of a tree is the number of edges on the longest path from the root node to a leaf node.

Add your answer

Q165. Error codes while doing API call

Ans.

Error codes are used to identify and communicate specific issues encountered during API calls.

  • Error codes should be descriptive and provide information about the issue encountered.

  • Use standard HTTP status codes for common errors (e.g. 404 for not found, 500 for internal server error).

  • Include additional error details in the response body for more specific information.

  • Handle errors gracefully in the client code to provide meaningful feedback to users.

Add your answer

Q166. How to write SQL query

Ans.

Writing SQL queries involves selecting data from databases using specific syntax.

  • Start by specifying the columns you want to retrieve using the SELECT statement

  • Use the FROM statement to specify the table(s) you are querying

  • Add conditions using the WHERE clause to filter the results

  • Use JOIN statements to combine data from multiple tables

  • Aggregate functions like COUNT, SUM, AVG can be used for calculations

  • Order the results using ORDER BY clause

  • Group data using GROUP BY clause

  • Us...read more

Add your answer

Q167. How to optimize SQL Joins

Ans.

Optimizing SQL Joins involves using proper indexing, limiting the result set, and avoiding unnecessary joins.

  • Use indexes on columns involved in join conditions to improve performance

  • Limit the result set by using WHERE clause to filter out unnecessary rows before joining

  • Avoid unnecessary joins by only joining the tables that are needed for the query

Add your answer

Q168. How to optimize performance

Ans.

Optimizing performance involves setting clear goals, providing feedback, offering training and development opportunities, and fostering a positive work environment.

  • Set clear goals and expectations for employees

  • Provide regular feedback and recognition for good performance

  • Offer training and development opportunities to help employees improve their skills

  • Create a positive work environment that promotes collaboration and communication

  • Implement performance management systems to tr...read more

Add your answer

Q169. how to design scalable system

Ans.

Designing a scalable system involves considering factors like load balancing, horizontal scaling, and fault tolerance.

  • Utilize load balancing to distribute traffic evenly across servers.

  • Implement horizontal scaling by adding more servers to handle increased load.

  • Ensure fault tolerance by designing for redundancy and failover mechanisms.

  • Use caching and database sharding to improve performance and scalability.

  • Consider microservices architecture for better scalability and maintai...read more

Add your answer

Q170. R Square and adjusted r square

Ans.

R Square and adjusted R Square are statistical measures used in regression analysis to determine the proportion of variance in the dependent variable that is explained by the independent variables.

  • R Square is a measure of how well the independent variables explain the variability of the dependent variable.

  • Adjusted R Square takes into account the number of independent variables in the model, penalizing for adding unnecessary variables.

  • R Square ranges from 0 to 1, with 1 indica...read more

Add your answer

Q171. How do transformers work

Ans.

Transformers work by using electromagnetic induction to transfer electrical energy between two or more circuits.

  • Transformers consist of two coils of wire, known as the primary and secondary coils.

  • When an alternating current (AC) flows through the primary coil, it creates a changing magnetic field.

  • This changing magnetic field induces a voltage in the secondary coil, which can be used to power devices or transfer energy.

  • The ratio of the number of turns in the primary and second...read more

Add your answer
Ans.

Life in IIT is challenging yet rewarding.

  • Academic rigor is high with a focus on practical learning

  • Students are encouraged to participate in extracurricular activities

  • Hostel life is an integral part of the experience

  • Networking opportunities with alumni and industry professionals

  • Opportunities for research and innovation

  • Competitive environment fosters growth and development

Add your answer

Q173. what is java encapsulation

Ans.

Java encapsulation is the mechanism of wrapping data (variables) and code (methods) together into a single unit, preventing direct access to the data from outside the unit.

  • Encapsulation helps in data hiding and protects the data from being modified by external classes.

  • It allows the internal implementation of a class to be hidden from the outside world.

  • Access to the data is provided through public methods (getters and setters) which control how the data is accessed and modifie...read more

Add your answer

Q174. What is DNS record?

Ans.

DNS record is a database record that maps a domain name to an IP address.

  • DNS records are used to translate human-readable domain names into machine-readable IP addresses.

  • Common types of DNS records include A, CNAME, MX, TXT, and NS records.

  • For example, an A record maps a domain name to an IPv4 address, while a CNAME record maps a domain name to another domain name.

  • DNS records are stored in DNS servers and are essential for the functioning of the internet.

Add your answer

Q175. Explain the Risk Mitigation process

Ans.

Risk mitigation process involves identifying, assessing, prioritizing, and implementing measures to reduce risks.

  • Identify potential risks and vulnerabilities

  • Assess the likelihood and impact of each risk

  • Prioritize risks based on severity and likelihood

  • Implement controls and measures to reduce or eliminate risks

  • Monitor and review the effectiveness of risk mitigation measures

Add your answer

Q176. Guesstimates like B++ schools

Ans.

B++ schools guesstimate

  • B++ schools are likely to have a moderate to high number of students

  • The quality of education may vary depending on the specific school

  • Factors such as location, reputation, and resources can impact the guesstimate

Add your answer

Q177. Top risks in P2P process

Ans.

Top risks in P2P process include fraud, errors, compliance issues, and lack of control.

  • Fraudulent activities by vendors or employees

  • Errors in data entry or processing leading to incorrect payments

  • Non-compliance with regulations and policies

  • Lack of control over the entire procure-to-pay process

Add your answer

Q178. fav food and why

Ans.

My favorite food is sushi because of its fresh and unique flavors.

  • I love the combination of fresh fish, rice, and seaweed in sushi rolls.

  • The variety of sushi options allows for different flavors and textures in each bite.

  • Sushi is a healthy choice as it is low in calories and high in protein.

  • I enjoy the cultural experience of eating sushi, including using chopsticks and wasabi.

  • Some of my favorite sushi rolls include spicy tuna, salmon avocado, and California rolls.

Add your answer

Q179. system design of iot machine

Ans.

Designing a system for IoT machines involves creating a network that allows devices to communicate and share data.

  • Consider the communication protocols needed for devices to connect and exchange data

  • Implement security measures to protect data and prevent unauthorized access

  • Design a scalable architecture to handle a large number of devices and data

  • Utilize cloud services for storage and processing of IoT data

  • Include edge computing to process data closer to the source for faster ...read more

Add your answer

Q180. Define various metrics

Ans.

Metrics are quantifiable measures used to track and assess the performance of a product or process.

  • Metrics provide objective data for evaluating success or identifying areas for improvement

  • Common metrics include customer satisfaction, revenue growth, and time to market

  • Metrics should be specific, measurable, achievable, relevant, and time-bound (SMART)

  • Examples of metrics in product development include customer retention rate, feature adoption rate, and defect density

Add your answer

Q181. tell the output a**2

Ans.

The output of a**2 is the square of the value of a.

  • The output is the value of a multiplied by itself

  • For example, if a = 3, then the output would be 9 (3*3)

Add your answer

Q182. Variance vs Bias tradeoff

Ans.

Variance vs Bias tradeoff is a key concept in machine learning to balance model complexity and accuracy.

  • Bias refers to error from overly simplistic models that fail to capture the true relationship between features and target variable.

  • Variance refers to error from overly complex models that are too sensitive to noise in the training data.

  • The goal is to find the right balance between bias and variance to minimize overall error, known as the bias-variance tradeoff.

  • Regularizatio...read more

Add your answer

Q183. Explain Backpropagation

Ans.

Backpropagation is a method used in neural networks to update the weights by calculating the gradient of the loss function.

  • Backpropagation involves calculating the gradient of the loss function with respect to each weight in the network.

  • The gradient is then used to update the weights in the network in order to minimize the loss function.

  • This process is repeated iteratively until the network converges to a set of weights that minimize the loss function.

  • Backpropagation is essen...read more

Add your answer

Q184. define oops principle

Ans.

OOPs principles are the fundamental concepts of object-oriented programming that help in designing and implementing software solutions.

  • Encapsulation: Bundling data and methods that operate on the data into a single unit (class).

  • Inheritance: Allowing a class to inherit properties and behavior from another class.

  • Polymorphism: The ability of different classes to be treated as instances of a common superclass.

  • Abstraction: Hiding the complex implementation details and showing only...read more

Add your answer

Q185. SQL Query of join

Ans.

SQL query to join tables based on a common key

  • Use JOIN keyword to combine rows from two or more tables based on a related column between them

  • Specify the columns to be joined in the ON clause

  • Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

Add your answer

Q186. design a system like youtube

Ans.

Design a system similar to YouTube for video sharing and streaming

  • Implement user authentication and authorization for uploading and viewing videos

  • Create a database to store video metadata, user information, and comments

  • Develop a recommendation algorithm based on user preferences and viewing history

  • Utilize a content delivery network (CDN) for efficient video streaming

  • Include features like video monetization, live streaming, and video analytics

Add your answer

Q187. Threads using java8

Ans.

Java 8 introduced new features for working with threads, such as CompletableFuture and parallel streams.

  • Java 8 introduced CompletableFuture class for asynchronous programming.

  • Parallel streams in Java 8 allow for easy parallelization of operations on collections.

  • New methods like `join()` and `thenApply()` were added to the Thread class in Java 8.

Add your answer

Q188. BIP Reports in EBS

Ans.

BIP Reports in EBS are used for generating business intelligence reports in Oracle E-Business Suite.

  • BIP (Business Intelligence Publisher) Reports are used to create and customize reports in EBS.

  • BIP Reports can be scheduled to run at specific times and delivered to users via email or other channels.

  • BIP Reports can be designed using templates and layouts to present data in a visually appealing format.

  • BIP Reports can access data from various sources within EBS, such as Oracle da...read more

Add your answer

Q189. Sell this watch

Ans.

This watch is a perfect blend of style and functionality, making it a must-have accessory for any occasion.

  • Sleek and stylish design

  • High-quality materials used in construction

  • Water-resistant and durable

  • Accurate timekeeping

  • Suitable for both formal and casual occasions

Add your answer

Q190. diameter for tree

Ans.

The diameter of a tree is the width of the tree trunk measured at breast height (4.5 feet above the ground).

  • Diameter is typically measured in inches or centimeters.

  • To measure the diameter of a tree, use a measuring tape or calipers at breast height.

  • The formula for calculating diameter is circumference divided by pi (3.14).

Add your answer

Q191. define os concepts

Ans.

OS concepts refer to fundamental principles and components of operating systems.

  • Process management - handling processes, scheduling, and resource allocation

  • Memory management - managing memory allocation, virtual memory, and paging

  • File system - organizing and accessing files on storage devices

  • Device management - controlling and communicating with hardware devices

  • Security and protection - ensuring system and data security

  • Networking - facilitating communication between systems

  • Ke...read more

Add your answer
1
2

More about working at American Express

Top Rated Large Company - 2024
Top Rated Company for Women - 2024
Top Rated Financial Services Company - 2024
HQ - New York City,New York, United States
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at TTK Prestige

based on 273 interviews
Interview experience
4.1
Good
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Interview Questions from Similar Companies

3.3
 • 458 Interview Questions
4.1
 • 401 Interview Questions
4.2
 • 177 Interview Questions
4.2
 • 155 Interview Questions
4.1
 • 148 Interview Questions
3.7
 • 140 Interview Questions
View all
Top American Express Interview Questions And Answers
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter