Paytm Payments Bank Interview Questions, Process, and Tips for Experienced

Tree specific and graph specific questions were there.

Q1. Tree , graph , mysql optimization
Add your answer

Q1. SQL and system design
Add your answer

Q1. 1some sql grouping clauuse 2. some java collection based questions
Add your answer

Q1. Some coding and framework related questions based on java and sql
Add your answer

Q1. Salary discussion
Add your answer

1 hour coding test including leetcode medium questions related to tree

Q1. How do you minimize the latency
Ans. 
Minimizing latency involves optimizing network, server, and application performance.
• Optimize network infrastructure by reducing network hops and using content delivery networks (CDNs)

• Utilize caching mechanisms to store frequently accessed data closer to the user

• Implement load balancing to distribute traffic evenly across servers

• Optimize code and database queries to reduce processing time

• Use asynchronous processing for
Answered by AI
Add your answer
Q2. Architecture of my current project
Add your answer

Q1. You have a table with unlimited no of rows in it how will you be able to deleted the rows which are dupilicate.
Ans. 
Use SQL query with GROUP BY and HAVING clause to identify and delete duplicate rows.
• Use GROUP BY clause to group rows with same values

• Use HAVING clause to filter out groups with count greater than 1

• Use DELETE statement to remove duplicate rows
Answered by AI
Add your answer
Q2. What is left join ?
Ans. 
Left join is a type of join operation in SQL that returns all rows from the left table and matching rows from the right table.
• Left join combines rows from two tables based on a related column between them.

• If there is no match in the right table, NULL values are returned for the columns of the right table.

• Example: SELECT * FROM table1 LEFT JOIN table2 ON table1.id = table2.id;
Answered by AI
Add your answer
Q3. 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 consist of one or multiple columns

• Primary key values cannot be NULL
Answered by AI
Add your answer

Q1. What are your expectations from this company.
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. What do you know about the job role
Add your answer

Q1. Tell me yourself
Add your answer

Q1. Why did you leave your organization
Add your answer